AutoCommit with JPA?

[C.D.]

Hi,

It looks like the JPA plugin is doing a commit at the end of a request
and a rollback if that request fails.

Is it possible to switch to autocommits, i.e. every db update commits
immediately without waiting for the request to end?

Thanks.

[C.D.]

BTW, calling JPA.em().flush() does not initiate a commit as well.

[Ronald Haring]

You can do it manually using:
JPA.em().getTransaction().commit()

Regards
Ronald

[C.D.]

getTransaction().commit() forces a commit, yes, but the problem with
that approach is that you can't do any DB operation after that.
Basically, if you do something like:

user.setName("A");
user.save();
JPA.em().getTransaction().commit()
.....
user.setName("B");
user.save();

Last save will give you: "TransactionRequiredException occured : no
transaction is in progress " error.

Basically, I want something like jdbc's auto commit, where every txn
is reflected back to the db, when needed.

Thanks.

[Yashaswi Kumar]

Did you find any solution for immediate commit ??

[You Wang]

I asked this question also, no idea why no one give the solution. I wrote a JPAUtil to help to do the manual transaction at play2 java. you can refer this link:

http://stackoverflow.com/questions/18545907/play2-how-to-manage-the-transaction-from-the-service-layer-instead-of-action-lay