Verify that all JDBC calls occur in a transaction

Question

How can I verify that all JDBC access occurs with an active transaction, i.e. java.sql.Connection.getAutoCommit()always returns false?

I use Spring for transaction management ( @Transactional) and Hibernate for data access.

---

Update. What happens is that some access to Hibernate is done without annotating the service method with @Transactional. This is what I want to be notified about.

Update 2: Sample Code

You can call the following code:

public ServiceImpl implements Service {

     // missing @Transactional
     public List<String> getSomeIds() {
           return getDao().getSomeIds();
     }
}

Answer 1

Use PROPAGATION_REQUIRED for all persistent methods.

Answer 2

, , - JDBC-, , , , Connection # setAutoCommit() Connection # commit() .

Answer 3

, @Transactional documentation, 9.5.6.1:

@Transactional :

 The propagation setting is PROPAGATION_REQUIRED
 ....

PROPAGATION_REQUIRED :

, , .

: , @duffymo :

, DAO , .