Subject Re: [Firebird-Java] Setting isolation level from iSQL using JayBird
Author Roman Rokytskyy
>> I query the connection metadata and I see I'm using isolation level
>> TRANSACTION_READ_COMMITTED. I want to change that to
>> TRANSACTION_REPEATABLE_READ or TRANSACTION_SERIALIZABLE which I
>> think are mapped to SNAPSHOT isolation level in the firebird world.
>> Is there a way to execute some SQL script or send some connection
>> url or driver property to make that happen?

> You can specify TPB mapping in the connection
> string/parameters.uzfurfhdidfhgeszsuodfhdrt

Sorry, that was temporary problem at the keyboard... :)

Ok, now about parameters. You can specify TPB mapping in the connection
string:

TRANSACTION_READ_COMMITTED=isc_tpb_consistency,isc_tpb_write,isc_tpb_wait

There is no chance to tell driver to use other isolation than read
committed, but you can redefine the mapping.

Roman