TransactionRequiredException Executing an update delete query

Question

Hi I am using hibernate JPA with spring and mongodb and i am running my application on Glassfish-4 0   My service class is     Component public class Test        PersistenceContext     EntityManager em      EntityManagerFactory emf        Transactional     public String persist Details details            details getUsername            details getPassword             Query query   em createNativeQuery  db details find username   details getUsername     amp password   details getPassword              em getTransaction   begin            em persist details           em getTransaction   commit            em flush            em clear            em close            query executeUpdate            System out println  Sucessful             return  persist                     And my spring-context xml is     lt  xml version  1 0  encoding  UTF-8   gt   lt beans xmlns  http   www springframework org schema beans      xmlns xsi  http   www w3 org 2001 XMLSchema-instance      xmlns p  http   www springframework org schema p      xmlns mvc  http   www springframework org schema mvc      xmlns tx  http   www springframework org schema tx      xmlns context  http   www springframework org schema context      xsi schemaLocation  http   www springframework org schema beans     http   www springframework org schema beans spring-beans-3 0 xsd     http   www springframework org schema tx     http   www springframework org schema tx spring-tx-3 0 xsd     http   www springframework org schema context     http   www springframework org schema context spring-context-3 0 xsd     http   www springframework org schema mvc     http   www springframework org schema mvc spring-mvc-3 0 xsd  gt        lt context component-scan base-package  com javapapers spring mvc    gt       lt context annotation-config   gt       lt mvc annotation-driven   gt       lt tx annotation-driven transaction-manager  txManager    gt       lt bean class  org springframework web servlet view InternalResourceViewResolver  gt           lt property name  prefix  value   WEB-INF view     gt           lt property name  suffix  value   jsp    gt       lt  bean gt       lt bean id  entityManagerFactory  class  org springframework orm jpa LocalEntityManagerFactoryBean  gt           lt property name  persistenceUnitName  value  ogmTest   gt       lt  bean gt       lt bean id  txManager  class  org springframework transaction jta JtaTransactionManager  gt       lt  bean gt   lt  beans gt    I have applied some changes in the code but their is no effect  Can anyone please help me to sort out this  Thanks in advance

User · Answer

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.

I hope this helps someone else experiencing this issue.

TransactionRequiredException Executing an update/delete query

The Solution to TransactionRequiredException Executing an update/delete query is

Most Viewed Questions: