Spring framework to pass Connection object to legacy code

Question

I am using Spring JDBC 3.0.6. I also have legacy code which uses plain JDBC. There are methods in the legacy code which required java.sql.Connection object. I want to call this method from my Spring code. How can I pass the java.sql.Connection object?

If I take connection object from the datasource then I need to manage the return/release of this connection. Can I not just get the reference of a connection object which is in the transaction.

I am using annotation based configuration and aop based declarative transactions.

JB Nizet · Accepted Answer · 2011-10-04 16:33:02Z

6

Use JdbcTemplate.execute(ConnectionCallback). The connection callback will have access to the connection which is automatically opened, closed and associated to the current transaction by Spring.

answered Oct 4, 2011 at 16:33

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gkamal · Accepted Answer · 2011-10-04 17:59:12Z

0

Use the DataSourceUtils.getConnection method, this will retreive the connection associated with the transaction. Use DataSourceUtils.releaseConnection to release it (a noop if the connection is the one associated with the Transaction.

If the legacy code has util classes to open / close connection - you can just modify that to use the DataSourceUtils functions.

answered Oct 4, 2011 at 17:59

gkamal

21k4 gold badges62 silver badges57 bronze badges

4 Comments

Sharad Yadav Over a year ago

This will not work for me as I do not want to write release connection. Since spring provides all the connection handling I want to stay away from that.

gkamal Over a year ago

You don't have to call releaseConnection if you are sure that the connection you retreived was the one associated with Transaction.

Sharad Yadav Over a year ago

How do I know that? I used DataSourceUtils.getConnection(datasource) and passed the datasource reference. I got the connection but the connection never returned.

gkamal Over a year ago

The call needs to happen in the context of a spring managed transaction (a method annotated by @Transactional).

Collectives™ on Stack Overflow

Spring framework to pass Connection object to legacy code

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related