Could not commit JPA transaction: Transaction marked as rollbackOnly

by

My guess is that ServiceUser.method() is itself transactional. It shouldn’t be. Here’s the reason why.

Here’s what happens when a call is made to your ServiceUser.method() method:

  1. the transactional interceptor intercepts the method call, and starts a transaction, because no transaction is already active
  2. the method is called
  3. the method calls MyService.doSth()
  4. the transactional interceptor intercepts the method call, sees that a transaction is already active, and doesn’t do anything
  5. doSth() is executed and throws an exception
  6. the transactional interceptor intercepts the exception, marks the transaction as rollbackOnly, and propagates the exception
  7. ServiceUser.method() catches the exception and returns
  8. the transactional interceptor, since it has started the transaction, tries to commit it. But Hibernate refuses to do it because the transaction is marked as rollbackOnly, so Hibernate throws an exception. The transaction interceptor signals it to the caller by throwing an exception wrapping the hibernate exception.

Now if ServiceUser.method() is not transactional, here’s what happens:

  1. the method is called
  2. the method calls MyService.doSth()
  3. the transactional interceptor intercepts the method call, sees that no transaction is already active, and thus starts a transaction
  4. doSth() is executed and throws an exception
  5. the transactional interceptor intercepts the exception. Since it has started the transaction, and since an exception has been thrown, it rollbacks the transaction, and propagates the exception
  6. ServiceUser.method() catches the exception and returns

More Related Contents:

  1. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  2. Bypass GeneratedValue in Hibernate (merge data not in db?)
  3. How does the FetchMode work in Spring Data JPA
  4. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  5. No Dialect mapping for JDBC type: 1111
  6. @Transactional method called from another method doesn’t obtain a transaction
  7. How to set up default schema name in JPA configuration?
  8. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  9. Transaction marked as rollback only: How do I find the cause
  10. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  11. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  12. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  13. Change database schema during runtime based on logged in user
  14. Spring JpaRepository – Detach and Attach entity
  15. How to map sql native query result into DTO in spring jpa repository?
  16. Difference between save and saveAndFlush in Spring data jpa
  17. The onFlushDirty Hibernate Interceptor method is never called
  18. spring data jpa @query and pageable
  19. Hibernate, spring, JPS & isolation – custom isolation not supported
  20. Error creating bean with name ‘entityManagerFactory
  21. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  22. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  23. java.lang.IllegalStateException: No transactional EntityManager available
  24. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  25. TransactionRequiredException Executing an update/delete query
  26. How to find distinct rows with field in list using JPA and Spring?
  27. No serializer found for class org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor
  28. Is it possible to dynamically define column names in Hibernate / JPA?
  29. Use abstract super class as parameter for Spring data repository
  30. Why should anybody put annotations on the getters or setters when using JPA to map the classes?

Leave a Comment