Subject Re: [Firebird-Java] Default transaction settings
Author Roman Rokytskyy
> I'm using jaybird 1.0.1 with transactions in my code, so I'm
> configuring the driver to meet my application transaction
> requirements, and i'd like to know if I must do it in a explicit way
> or my requirements are the default ones. This is my configuration:

> HashMap tpbMap = new HashMap();
> tpbMap.put("TRANSACTION_READ_COMMITTED", "isc_tpb_read_committed,
> isc_tpb_rec_version, isc_tpb_write,isc_tpb_wait");

> Is this the default configuration ?
> What are the default transaction configuration settings?

Default mapping is written in file isc_tpb_mapping.properties that is
included in the driver's jar file.

The mappings is like this:

TRANSACTION_SERIALIZABLE=isc_tpb_consistency,isc_tpb_write,isc_tpb_wait
TRANSACTION_REPEATABLE_READ=isc_tpb_concurrency,isc_tpb_write,isc_tpb_wait
TRANSACTION_READ_COMMITTED=isc_tpb_read_committed,isc_tpb_rec_version,isc_tp
b_write,isc_tpb_wait

> It's Jaybird responsible for this default settings or its a
> firebird configuration issue, so I must ask in the firebird list?

JayBird is responsible for it. Firebird talks in terms of TPB, JayBird maps
JDBC isolation levels to the appropriate TPB blocks.

> The last question, although it must not be the rigth place to
> ask it: I have a web application accessing the same database through
> DBCP/Jaybird with no explicit transaction configuration. Anyone
> knows if DBCP is altering the default transaction settings?

DBCP has no chance to do this unless you specify the mapping in the
connection string or parameters.

Roman