Is there a way to determine that a Connection is managed?

Question

I have some legacy JDBC code that is used within an EJB, in this code a call to setAutocommit() is made (which is not allowed for managed transactions, for understandable reasons).

I would like to skip this method call if the code is used within a managed transaction, but let the call remain if used in an un-managed context.

Is there a standardised way to detect if a JDBC Connection object is "managed" or not?

Answer 1

A bit decent transaction manager does setAutoCommit(false) and setTransactionIsolation(Connection.TRANSACTION_XXX).

Depending on the JDBC driver and the transaction manager used, you may have some luck with getAutoCommit() and/or getTransactionIsolation(). Determine by testing which values are been used in both cases so that you can learn how to distinguish the one from other.