Subject | Re: [Firebird-Java] Transaction parameters + Jaybird |
---|---|
Author | Roman Rokytskyy |
Post date | 2011-01-19T09:56:05Z |
> 1. What's the default transaction isolation level?For Jaybird - TRANSACTION_READ_COMMITTED.
> 2. How do I translate Firebird terms SNAPSHOT WAIT into JDBC terms? Is thereyes, there is file isc_tpb_mapping.properties in the driver.
> a translation matrix somewhere?
> Does your example above set transactionNo, to READ COMMITTED NO WAIT.
> isolation level to SNAPSHOT WAIT?
SNAPSHOT WAIT in Firebird uses isc_tpb_concurrency + isc_tpb_write +
isc_tpb_wait, you can map this to any JDBC isolation level, however in
order to keep the semantics close to what is written in JDBC specs, map
it to either TRANSACTION_REPEATABLE_READ or TRANSACTION_SERIALIZABLE.
Roman