JDBCTemplate with TransactionTemplate and Connection Pool, which datasource to use

Question

I'm not quite sure how to formulate the question, so feel free to tell me that I am thinking completly wrong.

I want to use the JdbcTemplate and the TransactionTemplate. I start of by initilizing my connection pool as datasource and the create a transaction manager as a datasource aswell?

        BoneCPConfig connectionPoolConfig = new BoneCPConfig();
    connectionPoolConfig.setJdbcUrl(...);
    connectionPoolConfig.setUsername(...); 
    connectionPoolConfig.setPassword(...);
    connectionPoolConfig.setMinConnectionsPerPartition(...);
    connectionPoolConfig.setMaxConnectionsPerPartition(...);
    dataSource = new BoneCPDataSource(connectionPoolConfig);
    DefaultTransactionDefinition definition = new DefaultTransactionDefinition();
    definition.setIsolationLevel(TransactionDefinition.ISOLATION_READ_COMMITTED);
    DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();
    transactionManager.setDataSource(dataSource);

But now I want to create my TransactionTemplate and JdbcTemplate:

transactionTemplate = new TransactionTemplate(transactionManager);
JdbcTemplate jdbc = new JdbcTemplate(transactionManager.getDataSource());

Now mulitple threads access transactionTemplate and jdbc. Does this code guarantee that everything done in doInTransaction uses the same connection for all jdbc calls?

Is the connection somehow linked internally, because it looks as if JdbcTemplate and TransactionTemplate could use what ever connection they wanted. Is my code correct/save?

Answer 1

This should all be fine. The critical part is that JdbcTemplate and DataSourceTransactionManager are supplied with the same DataSource object, which you have done.

Does this code guarantee that everything done in doInTransaction uses the same connection for all jdbc calls? Is the connection somehow linked internally, because it looks as if JdbcTemplate and TransactionTemplate could use what every connection they wanted.

Internally, Spring uses complex transaction synchronization logic to make sure that the transactions, connections and datasources are all properly synchronized (if you're interested, have a look at TransactionSynchronizationManager, although be warned, it's fearsome).

As long as you operate via the TransactionTemplate and JdbcTemplate APIs, it'll just work without any effort on your part. If you start manually fetching connections from the DataSource yourself, though, then all bets are off.