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.