JPA persist , detach, merge creates two records in DB when executed in the same transaction in JBoss

Solution Unverified - Updated -

Issue

We are having problems using JPA in CMT.

Transaction is started from an EJB, and the following code is called to persist records:

EntityManager em = factory.createEntityManager();
try {
     if (serviceRequest.getDbId() == null){
         em.persist(serviceRequest);
     } else {
         em.merge(serviceRequest);
     }
} 
finally {
     em.close();
}

The code is called twice, the first time with a new object, which will execute "em.persist(serviceRequest);", and then a second time after the serviceRequest object is modified, which will execute "em.merge(serviceRequest);". Both these calls are in the same JTA transaction.
The result is that there are 2 records created in the DB, both containing the modified serverRequest. I was expecting only one record.

I attach the datasource and persistence.xml used.

EntityManager is created programmatically in the DAO like this:

entityManagerProps = new HashMap<String, String>();
entityManagerProps.put("hibernate.connection.datasource", "java:TestDS");
entityManagerProps.put("hibernate.default_schema", "TestDSSchema");
factory = Persistence.createEntityManagerFactory("TestPersist", entityManagerProps);

Environment

  • JBoss Enterprise Application Platform (EAP) 4.3.0_CP09

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content