Subject | Re: [Firebird-Java] Transaction parameters + Jaybird |
---|---|
Author | Roman Rokytskyy |
Post date | 2011-01-14T09:37:20Z |
> Is there a way to specify TBP parameters in the JDBC URL string? Could youYou can override the default transaction parameters for each isolation
> provide an example for doing this for SNAPSHOT WAIT transaction isolation
> level?
levels via the URL, but not for individual transactions:
Properties props = new Properties();
props.setProperty("user", "SYSDBA");
props.setProperty("password", "masterkey");
props.setProperty("TRANSACTION_READ_COMMITTED",
"isc_tpb_read_committed,isc_no_rec_version," +
"isc_tpb_write,isc_tpb_nowait");
Connection connection = DriverManager.getConnection(
"jdbc:firebirdsql:localhost/3050:c:/example.fdb", props);
or simply
Connection connection = DriverManager.getConnection(
"jdbc:firebirdsql:localhost/3050:c:/example.fdb?"+
"TRANSACTION_READ_COMMITTED=isc_tpb_read_committed,"+
"isc_rec_version,isc_tpb_read,isc_tpb_nowait",
"SYSDBA",
"masterkey");
or you can put a file isc_tpb_mapping.properties with appropriate
content in your classpath before the driver, it will load that mapping
instead.
Roman