Using EJB transaction, when I insert a record in a main outer transaction, I can't find it in the inner transaction(Annotated by REQUIRES_NEW)

Question

My goal is inserting a record into my database, then updating it in a new transaction.

I try it like this:

@PersistenceContext(unitName="Table")
private EntityManager manager;

@EJB
private ITransactionTest itt;

public void insertRecord(int i) throws RuntimeException{
      Record record = new Record();
      record.setId(i+"");
      record.status(1);
      manager.persist(record);
      manager.flush();
      itt.updateRecord(i);
}

@TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)
public void updateRecord(int i) throws RuntimeException{
      Record record = manager.find(Record.class, i+"");
      record.setStatus(2);
      manager.flush();
}

However, it doesn't work. I also try to use getReference() to retrieve my record, then it throws an exception saying entity not found. It seems that the entity no longer resides in the persistence context.

If I remove the annotation of REQUIRES_NEW, it works and I can update my record successfully.

So how can I update my record in a new transaction? How can I keep entities in managed status in the persistence context crossing transactions?

It seems executing a update sql query using JPA can achieve my goal. But are there any other methods?

Best Regards,

Kajelas

score 0 · Accepted Answer · edited May 23 '17 at 10:32

0

"A persistence context is usually bound to a JTA transaction in Java EE, and a persistence context starts and ends at transaction boundaries (transaction-scoped) unless you use an extended entity manager."

source : http://docs.jboss.org/hibernate/orm/4.0/hem/en-US/html/transactions.html.

JPA support only (theoretically) READ_COMMITTED isolation (see Hibernate, spring, JPS & isolation - custom isolation not supported) for an eventual workaround

edited May 23 '17 at 10:32

Community

1
1

answered Apr 04 '13 at 15:05

Gab

7,869
4
37
68

Yeah, u're right. Perharps extended entity manager within stateful session bean is an alternative solution. – Kajelas Apr 06 '13 at 16:03

score 0 · Answer 2 · answered Apr 04 '13 at 15:24

0

Look at http://www.adam-bien.com/roller/abien/entry/how_to_self_invoke_ejb
I think that the problem is solved in that entry.

answered Apr 04 '13 at 15:24

Waji

71
3

Using EJB transaction, when I insert a record in a main outer transaction, I can't find it in the inner transaction(Annotated by REQUIRES_NEW)

2 Answers2