Subject | Re: [Firebird-Java] Setting isolation level from iSQL using JayBird |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-09-15T22:41:25Z |
>> I query the connection metadata and I see I'm using isolation levelSorry, that was temporary problem at the keyboard... :)
>> 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
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