• Register
search
Log In
0 votes
1.2k views

Problem :

I am getting bellow error while  using hibernate JPA with spring and mongodb and running my application on Glassfish-4.0.

javax.persistence.transactionrequiredexception: executing an update/delete query

6.9k points

1 Answer

0 votes

Solution:

I was simply creating the native query from the persistence EntityManager to perform the 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. By just doing it did not change my error.

I then tried use of application managed entity managers and not container managed and that was joinTransaction().

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

Further Readings:

https://github.com/spring-projects/spring-boot/issues/3576

36.1k points
edited by

Related questions

0 votes
2 answers 110 views
110 views
Problem : I am new to the Spring and JPA, wasted 10 days and no result with the searching on internet. I want to save the object to SQL SERVER, my connection is correct but when I write .flush() I get below exception “nested exception is javax.persistence.TransactionRequiredException: no transaction is in progress”
asked Jan 21 jwilliam 3.9k points
0 votes
1 answer 105 views
105 views
Problem : I am new to Spring and JPA I want to save object to SQL SERVER, connection is correct but when I write .flush() I get the exception as below javax.persistence.TransactionRequiredException: no transaction is in progress
asked Oct 22, 2019 peterlaw 6.9k points
1 vote
1 answer 211 views
211 views
Problem : When I try to compile my spring project, I always face the below error : Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed I have the ... >1.4.1.RELEASE</version> <relativePath /> <!-- lookup parent from repository --> </parent> . . .
asked Dec 12, 2019 alecxe 7.5k points
0 votes
1 answer 773 views
773 views
Problem : I am a completely novice in the hibernate world and facing below error, WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement The ... hibernate 4 version all my code runs very well. I looked for many solutions but they are not working for me.
asked Feb 4 jwilliam 3.9k points
0 votes
2 answers 147 views
147 views
Problem : I want to run the spring-boot application which uses thre hibernate via spring-jpa, but i am facing below error: Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo ... .AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:345) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:308)
asked Jan 3 alecxe 7.5k points