Configuration for the
Following properties are supported:
size of the buffer used to transfer BLOB data.
time in milliseconds during which
block if no free connection is in pool.
encoding, but takes Java character set name
instead of Firebird's encoding.
path to a database including the server name; for example
character encoding for the JDBC connection.
read-only: gives amount of free connections in the pool, when 0, blocking
will occur if
workingSize is equal to
default transaction isolation level for connections as string; possible
, in this context is a synonym
blockingTimeout (however value is specified in seconds).
time in milliseconds after which idle physical connection in the
pool is closed.
maximum number of pooled prepared statements, if 0, pooling is switched
maximum number of physical connections that can be opened by this data
minimum number of connections that will remain open by this data source.
a non-standard connection parameter in form
password that is used to connect to database.
time interval during which connection will be proved for aliveness.
allows switching pooling off.
alternative way to switch statement pooling off.
size of the socket buffer in bytes. In some cases values used by JVM by
default are not optimal. This results in performance degradation
(especially when you transfer big BLOBs). Usually 8192 bytes provides
SQL role name.
mapping of the TPB parameters to JDBC transaction isolation levels.
default transaction isolation level, number from
total number of allocated connections.
type of connection that will be created. There are four possible types:
pure Java (or type 4), type 2 that will use Firebird client library to
connect to the database, local-mode type 2 driver, and embedded that
will use embedded engine (access to local databases). Possible values
are (case insensitive):
for pure Java (type 4) JDBC connections;
to use Firebird client library;
to use Firebird client library in local-mode (IPC link to server);
to use embedded engine.
name of the user that will be used to access the database.
number of connections that are in use (e.g. were obtained using
method, but not yet closed).
- Roman Rokytskyy