How to assign HSQL Datasource to JdbcTemplate in DatabaseFacadeImpl?

[Mark D Anthony]

Hi all,

I am currently working on a Spring Boot app, and am trying to assign a HSQL DB as the datasource of a JdbcTemplate in a DatabaseFacadeImpl class.

Below is what's currently in DatabaseFacade.java

public interface DatabaseFacade {

    JdbcTemplate getJdbcTemplate();
    
}

And here is what is in DatabaseFacadeImpl.java:

@Component
class DatabaseFacadeImpl implements DatabaseFacade {

    private final JdbcTemplate jdbcTemplate;

    @Autowired
    public DatabaseFacadeImpl(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }
}

Can someone please tell me what needs to be done so I can hook this up?

Most of the examples I've found online are using XML files for the configuration, but I don't know how to or want to use that approach.

I did some research on jdbcTemplate, & below is my attempt:

 @Autowired
    public DatabaseFacadeImpl(JdbcTemplate jdbcTemplate) {
    	jdbcTemplate.setDataSource(myDataSource());
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }
   
    public DataSource myDataSource() {
    	DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(myDriverClassName);
        dataSource.setUrl(myUrl);
        dataSource.setUsername(myUsername);
        dataSource.setPassword(myPassword);
        return dataSource;
    }

Should this work, or am I on the wrong track?

[Himai Minh]

Hi,
I think you need to have a @Configuration class. Inside that class , you can define @Bean method that return a JdbcTemplate

@Configuration
public class  myJDBCConfig{

@Bean
 public DataSource myDataSource() {
     DriverManagerDataSource dataSource = new DriverManagerDataSource();
       dataSource.setDriverClassName(myDriverClassName);
       dataSource.setUrl(myUrl);
       dataSource.setUsername(myUsername);
       dataSource.setPassword(myPassword);
       return dataSource;
   }
@Bean
public JdbcTemplate jdbcTemplate(){
 JdbcTemplate jdbcTemplate = new JdbcTemplate();
  jdbcTemplate.setDataSource(myDataSource());

return jdbcTemplate();

}
}

The reason why I am defining JdbcTemplate as a bean because you use @Autowired to autowire JdbcTemplate in the DatabaseFacadeImpl class.
If jdbcTemplate is not a bean, you cannot autowire it.

Here is an example https://www.technicalkeeda.com/spring-tutorials/spring-4-jdbctemplate-annotation-example