Native SQL Statements not handled by EJB transaction

[vst77]

Hi all,

We are using Wildfly 8.1 and migrated our project from JBOSS 5. All works perfectly except the transaction handling of container managed EJBs.

If we execute a native SQL statement, the changes will get persistent before the transaction is commited by the container.

Thus the "delete from person" statement is never rolled back if an exception occurs. (The ApplicationException is annotated with rollback=true)

@Stateless

@LocalBean

public class PersonSession

     public void recreatePersons() throws ApplicationException

     {

          manager.createNamedQuery("delete from person").executeUpdate();

          // all persons get deleted in the database even if the transaction is rolled back

          person1 = new Person();

          person1.setLastName("Smith");

          person2 = new Person();

          person2.setLastName("Johnson");

          manager.persist(person1);

          manager.persist(person2);

     }

}

[smarlow]

Enable trace logging for org.jboss.jca, org.hibernate, org.jboss.as.jpa and com.arjuna to get more information about what is occurring exactly (from tx start to tx end).  Attach the server.log (zip it if large) to this forum.  Extra points if you also examine the server.log.

[vst77]

Thanks Scott. Your answer led me to the correct settings.

Problem was that my datasource was defined correctly in the peristence.xml:

<persistence-unit name="bcore" transaction-type="JTA">

but it wasn't in the standalone.xml

<datasource jta="false" ... >

Thus when setting jta to true, then CMT (and BMT) work correctly!