TransactionRequiredException Executing an update/delete query

by

I am not sure if this will help your situation (that is if it stills exists), however, after scouring the web for a similar issue.

I was creating a native query from a persistence EntityManager to perform an update.

Query query = entityManager.createNativeQuery(queryString);

I was receiving the following error:

caused by: javax.persistence.TransactionRequiredException: Executing
an update/delete query

Many solutions suggest adding @Transactional to your method.
Just doing this did not change the error.

Some solutions suggest asking the EntityManager for a EntityTransaction so that you can call begin and commit yourself.
This throws another error:

caused by: java.lang.IllegalStateException: Not allowed to create
transaction on shared EntityManager – use Spring transactions or EJB
CMT instead

I then tried a method which most sites say is for use application managed entity managers and not container managed (which I believe Spring is) and that was joinTransaction().

Having @Transactional decorating the method and then calling joinTransaction() on EntityManager object just prior to calling query.executeUpdate() and my native query update worked.

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. Could not commit JPA transaction: Transaction marked as rollbackOnly
  14. Change database schema during runtime based on logged in user
  15. Spring JpaRepository – Detach and Attach entity
  16. How to map sql native query result into DTO in spring jpa repository?
  17. Difference between save and saveAndFlush in Spring data jpa
  18. The onFlushDirty Hibernate Interceptor method is never called
  19. spring data jpa @query and pageable
  20. Hibernate, spring, JPS & isolation – custom isolation not supported
  21. Error creating bean with name ‘entityManagerFactory
  22. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  23. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  24. java.lang.IllegalStateException: No transactional EntityManager available
  25. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  26. How to find distinct rows with field in list using JPA and Spring?
  27. Hibernate and no PK
  28. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  29. MongoDB $aggregate $push multiple fields in Java Spring Data
  30. How to use @Transactional with Spring Data?

Leave a Comment