Does the transactionManager close the statement atuomatically?

Now we are using spring transactionManager to manager the DB transaction. Since we use a connection pool to hold all the connections, the connection will not be closed. I won开发者_JAVA百科der if the opended statement will be closed automatically after the transaction get failed and rollback?

We are using C3p in our project to maintain Connection pool. We have a configuration in it to close the connection after a transaction completes.

<prop key="connection.release_mode">after_transaction</prop>

So which transaction manager are you using?

No it won't. You should always explicitely close your statements, and do it in finally blocks. Or use Spring's JdbcTemplate which handles this for you.