Subject Re: AW: [Firebird-Java] urgend charset problem
Author Roman Rokytskyy
> Hi

> And what unit is pingInterval messured in? ms? s?

ms

> What are the uses of these:
> nonStandardProperty a non-standard connection parameter in form
> name[=value].

Setter with one parameter provides a possibility to set a DPB parameter
using following syntax:

dataSource.setNonStandardProperty("isc_dpb_sql_dialect=3");

Such syntax is not very common in Java code, it would be much more natural
to use two-parameter setter. However there's no possibility to use
two-parameter setter method in configuration files. Usually, when setting a
configuration parameter of a data source, web-containers use Java reflection
API and consider only those setters that take one parameter. In Tomcat
configuration parameter would look like this:

<parameter>
<name>nonStandardProperty</name>
<value>sql_dialect=3</value>
</parameter>


> tpbMapping mapping of the TPB parameters to JDBC transaction
> isolation levels.

Resource bundle (.properties file) with mapping between standard isolation
levels in JDBC to the TPB parameters in Firebird. For more information on
TPB see Firebird API reference.

> And what is the difference between:
> transactionIsolationLevel default transaction isolation level,
> number from Connection interface.

ds.setTransationIsolationLevel(2) or
ds.setTransactionIsolationLevel(Connection.TRANSACTION_READ_COMMITTED)

> isolation default transaction isolation level for connections as
> string;

ds.setIsolation("TRANSACTION_READ_COMMITTED");

more useful for config files, since "transactionIsolationLevel = 2" is not
very informative.

Roman