The same results with this:

@Autowired
DataSourceTransactionManager txMgr;


public Integer insert(Integer parentGroupsId, Groups groups) throws Exception {
    TransactionStatus tx = txMgr.getTransaction(new 
DefaultTransactionDefinition());
    try {
        Integer groupsId = groupsDAO.insert(groups);
        if (groupsId != null) {
            groupsDAO.insertNode(groupsId, parentGroupsId);
        }
        return groupsId;
    } catch (Exception e) {
        txMgr.rollback(tx);
    }

    return null;
}



10:20:37,537 DEBUG DataSourceUtils:110 - Fetching JDBC Connection from 
DataSource
10:20:37,545 DEBUG DataSourceUtils:327 - Returning JDBC Connection to DataSource
10:20:37,549 DEBUG ExceptionTranslationFilter:115 - Chain processed normally
10:20:37,549 DEBUG SecurityContextPersistenceFilter:97 - SecurityContextHolder 
now cleared, as request processing completed
10:20:37,550 DEBUG DataSourceTransactionManager:223 - Switching JDBC Connection 
[ConnectionJavassistProxy(346098337) wrapping 
com.mysql.jdbc.JDBC4Connection@160ded6f] to manual commit
10:20:37,554 TRACE TransactionSynchronizationManager:193 - Bound value 
[org.springframework.jdbc.datasource.ConnectionHolder@53e6a2c4] for key 
[HikariDataSource (springHikariCP)] to thread [qtp2039810346-49]
10:20:37,556 TRACE TransactionSynchronizationManager:272 - Initializing 
transaction synchronization


10:22:40,637 TRACE DataSourceTransactionManager:939 - Triggering 
beforeCompletion synchronization
10:22:40,639 DEBUG DataSourceTransactionManager:847 - Initiating transaction 
rollback
10:22:40,641 DEBUG DataSourceTransactionManager:284 - Rolling back JDBC 
transaction on Connection [ConnectionJavassistProxy(346098337) wrapping 
com.mysql.jdbc.JDBC4Connection@160ded6f]
10:22:40,642 TRACE DataSourceTransactionManager:968 - Triggering 
afterCompletion synchronization
10:22:40,644 TRACE TransactionSynchronizationManager:331 - Clearing transaction 
synchronization
10:22:40,646 TRACE TransactionSynchronizationManager:243 - Removed value 
[org.springframework.jdbc.datasource.ConnectionHolder@53e6a2c4] for key 
[HikariDataSource (springHikariCP)] from thread [qtp2039810346-49]
10:22:40,647 DEBUG DataSourceTransactionManager:327 - Releasing JDBC Connection 
[ConnectionJavassistProxy(346098337) wrapping 
com.mysql.jdbc.JDBC4Connection@160ded6f] after transaction
10:22:40,648 DEBUG DataSourceUtils:327 - Returning JDBC Connection to DataSource


-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to