using Spring JdbcTemplate

Question

if i create a new instance of JdbcTemplate like so;

JdbcTemplate jdbcTemplate = new JdbcTemplate(getDataSource());

by passing the datasource as a param (the datasource retrieves a connection from server connection pool) am i required to close the connection when im finished with it?

In other words, if i have a pool of connections will the previous code cause my application to create a new connection each time a request executes the code

Answer 1

No. That's the whole deal. Use the JdbcTemplate and it will manage the ressources (Connection, PreparedStatement, ResultSet). It is an implementation of the template method design pattern.

Javadoc:

It simplifies the use of JDBC and helps to avoid common errors. It executes core JDBC workflow, leaving application code to provide SQL and extract results.

Answer 2

What I did, was to extend the JdbcTemplate and override the execute method to use the connection pool (a particular case).