Query.executeUpdate() - No transaction is currently active

[d.frank]

Hi,
I'm having trouble using the method executeUpdate (). An example:

public void update() {
		DefaultTransactionDefinition def = new DefaultTransactionDefinition();
		
		def.setName("updateTx");
		def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRES_NEW);
		
		TransactionStatus status = txManager.getTransaction(def);
		Query query = entityManager.createQuery(" update Contact c set c.name = 'Daniel' where c.id = '2'");
		query.executeUpdate();
		
		txManager.commit(status);
}

This code ever throw an Exception:

javax.persistence.TransactionRequiredException: 
Exception Description: No transaction is currently active

Any idea what might be happening?

[pratikbhavsar]

What transaction manager are you using?

[d.frank]

Hi pratikbhavsar,
I am using org.springframework.orm.jpa.JpaTransactionManager.

[pratikbhavsar]

Use

entityManager.getTransaction().begin()

and

entityManager.getTransaction().commit()

to begin and end a JpaTransaction.

[d.frank]

Sorry, but I've tried that before.
entityManager.getTransaction().begin() cause this exception:

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

[robin]

Why don't you use Spring's transaction handling by annotation the method with @Transactional? Anyway, if you want to handle transactions programatically you either have to create an application managed EntityManager by using EntityManagerFactory and then use entityManager.getTransaction() or use Spring's EntityManager and call em.joinTransaction() after starting your own transaction. I'm not shure if the latter works with any transaction manager or if this works with JTA only.

Robin.

[d.frank]

I am using EntityManagerFactory right now to solve this issue.
I do not use @Transactional, because I need two different transactions in the same method.

[mikes]

have this issue with entityManager().createNativeQuery(sql).executeUpda te() as well. singleResult(), resultList() both work without issue - just executeUpdate. @Transactional seems to be ineffective for this... any advice?