Hi, Thank you for your E-Mails. I'm sorry, but this is rather difficult to support from only the logs and the code you've provided - and it might be due to a combination of using:
- Spring transactions - Your custom exception translator - Hikari - JDBC batch statements I'm afraid it will be hard to help you without a fully reproducible test case in a test project that is available for download. Another option would be to ask a question on Stack Overflow as it might be a problem related to Spring rather than to jOOQ - Lukas 2015-04-06 9:54 GMT+02:00 Stanimir Marinov <[email protected]>: > 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. > -- 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.
