Configuring transaction isolation level on a per-transaction basis?

[cowwoc]

Hi,

I need to be able to configure the transaction isolation level on a per-transaction basis as opposed to on a per-connection basis. I was expecting to find EntityTransaction.begin(IsolationType) but as you well know by now this does not exist :(

Are there known workarounds for this sort of thing. Does JPA 2.0 plan on adding this shortcoming?

Thank you,
Gili

[cowwoc]

I found an EclipseLink-specific answer (mentioned below) but is there is a portable way of doing this across all JPA implementations?

Here is the EclipseLink-specific answer: http://wiki.eclipse.org/Using_Advanced_Unit_of_Work_API_(ELUG)#Database_Transaction_Isolation_Levels

I hope this helps others in the future.

Gili

cowwoc wrote:

Hi,

I need to be able to configure the transaction isolation level on a per-transaction basis as opposed to on a per-connection basis. I was expecting to find EntityTransaction.begin(IsolationType) but as you well know by now this does not exist :(

Are there known workarounds for this sort of thing. Does JPA 2.0 plan on adding this shortcoming?

Thank you,
Gili