Instantiating a JdbcTemplate from a java.sql.Connection

Question

I want to obtain a JdbcTemplate in my Java code. I've already got a working java.sql.Connection. To create a new JdbcTemplate it would normally need an instance of the javax.sql.DataSource interface.

Is it somehow possible to obtain a new JdbcTemplatefrom an existing java.sql.Connection?

score 34 · Accepted Answer · answered Jun 24 '10 at 09:47

34

new JdbcTemplate(new SingleConnectionDataSource(connection, false))

However, this is not quite advisable, unless for unit-tests for example.

You'd better use a full-featured DataSource and wire things using spring.

answered Jun 24 '10 at 09:47

Bozho

Thanks for the work around, but nevertheless I've ended up implementing it in my application context. – Jun 24 '10 at 10:36
1

+1 This makes perfect sense deep down in some Hibernate listener code of mine, where I already have the current open connection in my hand. – Stefan Haberl Mar 19 '14 at 08:11

score 2 · Answer 2 · answered Jun 24 '10 at 09:37

2

No, JdcbTemplate is a Spring class; Connection is part of the JDK. Connection knows nothing about JdbcTemplate.

The way to do it is to add a JdbcTemplate bean in your Spring app context; then inject it into the classes that need it declaratively.

answered Jun 24 '10 at 09:37

duffymo

2 Answers2