Subject Re: [Firebird-Java] Transaction parameters + Jaybird
Author Roman Rokytskyy
> Is there a way to specify TBP parameters in the JDBC URL string? Could you
> provide an example for doing this for SNAPSHOT WAIT transaction isolation
> level?

You can override the default transaction parameters for each isolation
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