Subject | TPB problem |
---|---|
Author | Leonid Kandyba |
Post date | 2003-04-17T06:53:55Z |
Hi!
I am using Firebird-SQL jdbc driver and want to map
TRANSACTION_REPEATABLE_READ to
isc_tpb_read_committed,isc_tpb_rec_version,isc_tpb_nowait.
I have tryed following code to create connection:
String dbUrl =
"....mydb.gdb?TRANSACTION_READ_COMMITTED=isc_tpb_read_committed,isc_tpb_rec_
version,isc_tpb_nowait";
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection con = DriverManager.getConnection(dbUrl,"sysdba","masterkey");
con.setAutoCommit(false);
con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
....
But the connection behaves so as if it would have isc_tpb_wait flag
It functioned however if I use TRANSACTION_REPEATABLE_READ or
TRANSACTION_SERIALIZABLE
but not TRANSACTION_READ_COMMITTED
Thanx
Leonid Kandyba
I am using Firebird-SQL jdbc driver and want to map
TRANSACTION_REPEATABLE_READ to
isc_tpb_read_committed,isc_tpb_rec_version,isc_tpb_nowait.
I have tryed following code to create connection:
String dbUrl =
"....mydb.gdb?TRANSACTION_READ_COMMITTED=isc_tpb_read_committed,isc_tpb_rec_
version,isc_tpb_nowait";
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection con = DriverManager.getConnection(dbUrl,"sysdba","masterkey");
con.setAutoCommit(false);
con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
....
But the connection behaves so as if it would have isc_tpb_wait flag
It functioned however if I use TRANSACTION_REPEATABLE_READ or
TRANSACTION_SERIALIZABLE
but not TRANSACTION_READ_COMMITTED
Thanx
Leonid Kandyba