JPA UserTransaction not rolled back

[Jochem Pim]

The BMT(transaction) in the following code isn't rolled back after an exception. I use EJB 3.1 with JPA 2.0. My programs calls TaskExecutor:executeTask(Task) to begin.

    @Stateless
    @LocalBean
    @TransactionManagement(TransactionManagementType.BEAN)
    public class TaskExecutor {

        @Inject SomeEntityFacadeLocal someEntityEJB;
        @Resource private UserTransaction ut;

        @Asynchronous
        public Future<String> executeTask Task p_task) { // we start here
            Task task;
                
            try {
                ut.begin();
                task= taskEJB.edit(p_task);
                task.setStatus("busy");
                ut.commit();
                // the transaction above is succesful
            
                ut.begin();
                task = taskEJB.edit(task);
            
                try {
                    switch (task.getName()) {
                        case "WC1":   
                            // SomeEntity should not be in de the database if the transaction is rolled back, but it is...
                            SomeEntity se = new SomeEntityEJB();
                            someEntityEJB.create(se);
                        
                            // CREATE EXCEPTION AS TEST
                            int i = 5 / 0;
                            break;
                        default:
                            task.setStatus("stopped");
                    }
                
                    ut.commit();
                
                } catch (java.lang.ArithmeticException ex) {
                    if (ut != null) {
                        ut.rollback();
                        System.out.println("Rolled Back"); // is printed
                    } 
                
                    ut.begin();
                    task = taskEJB.edit(task);
                    task.setStatus("stopped"); // is succesfully set in database
                    ut.commit();
                }
            
            } catch (RollbackException | HeuristicMixedException | HeuristicRollbackException | SecurityException | IllegalStateException | NotSupportedException | SystemException ex) {
                ex.printStackTrace();
            }
        
            return new AsyncResult<>("");
        }
    }

As you might guess, the SomeEntity is in the database after the transaction is rolled back.
If you are interested, this is my persistence.xml:

    <?xml version="1.0" encoding="UTF-8"?>
    <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
        <persistence-unit name="com.mysite.PU" transaction-type="JTA">
        <jta-data-source>jdbc/myDatabase</jta-data-source>
        <properties></properties>
        </persistence-unit>
    </persistence>

To be complete, here is the essential part of SomeEntity:

    @Stateless
    @LocalBean
    public class SomeEntityFacade {

        @PersistenceContext(unitName = "com.mysite.PU")
        private EntityManager em;

        public void create (SomeEntity p_someEntity) {
            em.persist(p_site);
        }

Why is the SomeEntity in the database after the UserTransaction is rolled back?

[Hebert Coelho]

This catch is not rollingback

catch (RollbackException | HeuristicMixedException | HeuristicRollbackException | SecurityException | IllegalStateException | NotSupportedException | SystemException ex) {  
                ex.printStackTrace();  
            }  

Maybe your problem is here.

[Jochem Pim]

Hebert Coelho wrote:Maybe your problem is here.

The program newer reached that part of the code. The java.lang.ArithmeticException is caught in the first catch.

[Hebert Coelho]

What about the others: SecurityException | IllegalStateException | NotSupportedException | SystemException ex

[Jochem Pim]

I tested if the code reached that part and it didn't:

            } catch (RollbackException | HeuristicMixedException | HeuristicRollbackException | SecurityException | IllegalStateException | NotSupportedException | SystemException ex) {  
                   System.out.println("This nor the printStackTrace is printen when the code is executed");
                   ex.printStackTrace();  
            } 

[Jochem Pim]

After some extensive research, the problem seams to be different.
I created a new post here: http://www.coderanch.com/t/561174/EJB-JEE/java/JPA-transaction-rollback-fails-call