Subject | Setting isolation level from iSQL using JayBird |
---|---|
Author | Federico Tello Gentile |
Post date | 2004-09-15T21:14:38Z |
I'm using an iSQL tool (SQuirreL SQL Client) to access Firebird 1.5
using JayBird.
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?
I know I can do it from java code using java.sql.Connection's
protocol, but this is a different case.
Thanks in advance.
using JayBird.
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?
I know I can do it from java code using java.sql.Connection's
protocol, but this is a different case.
Thanks in advance.