BoneCP spring issue

[pankaj]

I am using spring with BoneCP. In my application I want certain calls to DB to be executed in the same transaction but from the getConnection call I am getting always a different connection may be due to the connection pool.

When I use BasicDataSource instead of BoneCP the DB calls are executed in the same transaction.

Any ideas of resolving this issue.

[dbaldes]

You need to keep one specific connection object during your transaction. You cannot call getConnection() multiple times and assume that you get the same connection. It's not meant to be used like that.