geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zakharov, Vasily M" <>
Subject RE: Changing Derby transaction isolation level
Date Tue, 30 May 2006 22:29:57 GMT

Thank you very much for the details.

Well, I'll continue fighting with TranQL connectors then, to make them
set the proper level. :)


-----Original Message-----
From: Stanley Bradbury [] 
Sent: Tuesday, May 30, 2006 11:18 PM
Subject: Re: Changing Derby transaction isolation level

Zakharov, Vasily M wrote:
> Hi, all,
> Can I somehow change the transaction isolation level for built-in
> 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