About “WFLYJPA0060: Transaction is required”

[usharik]

Not sure if here is right place for this question but I simply want to know more about that.

I'm using JPA in Wildfly application.

If I use datasource from the application server with this persistence.xml all is fine

<?xml version="1.0" encoding="UTF-8"?> 
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd" 
version="2.1">  
   <persistence-unit name="ds" transaction-type="JTA"> 
      <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
         <jta-data-source>java:/jboss/datasources/MySQLDS</jta-data-source>
         <properties> 
             .... some options 
         </properties> 
   </persistence-unit>
</persistence>

But if I'm trying to use it with in application DB connection properties I got "WFLYJPA0060: Transaction is required" exception.

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd" 
version="2.1">  
   <persistence-unit name="ds" transaction-type="JTA">
      <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider> 
      <properties>
         <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/javaee_test_db?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8&amp;serverTimezone=UTC"/> 
         <property name="javax.persistence.jdbc.user" value="root"/> <property name="javax.persistence.jdbc.password" value="root"/>
         <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>  
         .... some options
      </properties>
   </persistence-unit>
</persistence>

Why it works this way? What should I do to fix?

[zhurlik]

Hi,

Maybe it can help you, I guess you are tying to use RESOURCE_LOCAL

Tackling RESOURCE_LOCAL Vs. JTA Under Java EE Umbrella and Payara Server - DZone Java

Thanks,

Vlad

[usharik]

Hi,

Very likely that is what I need! Thank you!

[smarlow]

I hadn't seen that doc before, looks well written! 

[smarlow]

But if I'm trying to use it with in application DB connection properties I got "WFLYJPA0060: Transaction is required" exception.

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd" 
version="2.1">  
   <persistence-unit name="ds" transaction-type="JTA">
      <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider> 
      <properties>
         <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/javaee_test_db?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8&amp;serverTimezone=UTC"/> 
         <property name="javax.persistence.jdbc.user" value="root"/> <property name="javax.persistence.jdbc.password" value="root"/>
         <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>  
         .... some options
      </properties>
   </persistence-unit>
</persistence>

What should I do to fix?

I think that you should make two changes, switch to RESOURCE_LOCAL and also do not use a "transaction scoped persistence context" (use @PersistenceUnit EntityManagerFactory yourEMF instead of @PersistenceContext EntityManager yourEM). 

Why it works this way?

When you inject an @PersistenceContext into an EntityManager, the underlying entity manager (persistence context) that is managed by the JPA container, will ensure that any non-JTA-transactional calls to EntityManager.remove/merge/persist/refresh methods, will throw a "Transaction Is Required" exception. 

Scott