javax.persistence.TransactionRequiredException:

Question

I am trying to delete records from a table using JPA Controller method, but I get the following exception..

"javax.persistence.TransactionRequiredException: Cannot call methods requiring a transaction if the entity manager has not been joined to the current transaction."

Following is the code I am trying to run

 public void deleteRulesofType(String ruleType) throws NotSupportedException, SystemException, Exception { EntityManager em = getEntityManager(); try { utx.begin(); Query query = em.createQuery("delete from RulesFound r where r.ruleType=:ruleType"); query.setParameter("ruleType", ruleType); query.executeUpdate(); em.flush(); utx.commit(); } catch (Exception e) { try { utx.rollback(); } catch (Exception re) { throw new RollbackFailureException("An error occurred attempting to roll back the transaction.", re); } throw e; } finally { em.close(); } }

Any help is greatly appreciated :)

pleft · Accepted Answer · 2016-03-07 10:57:05Z

2

Try to make your entity manager to join the transaction by calling

em.joinTransaction();

answered Mar 7, 2016 at 10:57

pleft

8,0252 gold badges25 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

andy Over a year ago

Thanks @elefasGR, I removed the em.flush() line and added em.joinTransaction() and then clean and build the project. But I still get the exception when I run it :(

pleft Over a year ago

Can you update your code with the changes you mention please?

andy Over a year ago

sorry.. my bad. I forgot to call em.joinTransaction() before query.executeUpdate();. That's why. Now it works perfect.. Thank you so much :)

Collectives™ on Stack Overflow

javax.persistence.TransactionRequiredException:

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related