Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Transaction isolation 2
Transaction isolation 2 [message #1763914] Mon, 22 May 2017 20:43 Go to next message
Anthony Levesque is currently offline Anthony LevesqueFriend
Messages: 3
Registered: May 2017
Junior Member
I am using EclipseLink with Spring and MySQL.

Transaction A calls an inner transaction B that creates data.

After transaction B returns, transaction A does not see inserted data.

I have tried the followings :

  • Change database isolation from REPEATABLE_READ to READ_COMMITED -> it solves the problem

  • Change datasource isolation -> it solves the problem

  • Change transaction isolation -> it does not work

  • Add a custom dialect to call setTransactionIsolation() -> it does not work

  • Add a SessionCustomizer -> it does not work

Why and how can I make transaction isolation work without changing isolation globally ?

It looks like a basic needs.

Thanks in advance.

Regards,
Re: Transaction isolation 2 [message #1764089 is a reply to message #1763914] Wed, 24 May 2017 16:24 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1275
Registered: July 2009
Senior Member
This is a database level setting, and so is entirely dependent on your database and driver support. We can help if you have trouble with specifics, but there is no setting JPA/EclipseLink gives that can control this for you - You'll have to look at the docs for them to see how they require it be set. Unrelated question: why is your database set to REPEATABLE_READ - it must have some requirement as it doesn't seem like a default.
Previous Topic:problem when migrating from oracle11 to oracle12e
Next Topic:Eclipselink PerformanceProfiler Not Thread Safe
Goto Forum:
  


Current Time: Mon Dec 18 07:21:04 GMT 2017

Powered by FUDForum. Page generated in 0.01554 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software