geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <>
Subject Re: Changing Derby transaction isolation level
Date Tue, 30 May 2006 19:18:24 GMT
Zakharov, Vasily M wrote:
> Hi, all,
> Can I somehow change the transaction isolation level for built-in Derby
> database?
> The "DB Info" page in Geronimo console states:
> Default Transaction Isolation   dirty reads are prevented;
> non-repeatable reads and phantom reads can occur
> and I'd like to somehow change it to "dirty reads and non-repeatable
> reads are prevented; phantom reads can occur".
> Is it possible?
> Thank you!
> Vasily Zakharov
> Intel Middleware Products Division
The default transaction isolation level for Derby is READ_COMMITTED.  
This can be overriden on an per-connection basis using the Derby SQL 
statement:  SET [CURRENT] ISOLATION = <desired isolation>
or by invoking the desired transaction isolation method of 

There is more information about Derby isolation levels at:

View raw message