Connection properties

List of connection properties (incomplete, see Extended connection properties in Jaybird JDBC Driver Java Programmer’s Manual for a complete list)

Property	Description
database	Path to the database in the format [host/port:]/path/to/database.fdb
type	Type of the driver to use. Possible values are PURE_JAVA or TYPE4 for type 4 JDBC driver, NATIVE or TYPE2 for type 2 JDBC driver, EMBEDDED for using embedded version of the Firebird.
blobBufferSize	Size of the buffer used to transfer blob content. Maximum value is 64k-1.
socketBufferSize	Size of the socket buffer. Needed on some Linux machines to fix performance degradation.
buffersNumber	Number of cache buffers (in database pages) that will be allocated for the connection. Makes sense for ClassicServer only.
charSet	Character set for the connection. Similar to encoding property, but accepts Java names instead of Firebird ones.
encoding	Character encoding for the connection. See Firebird documentation for more information.
useTranslation	Path to the properties file containing character translation map.
userName	Name of the user that will be used by default.
password	Corresponding password.
roleName	SQL role to use.
sqlDialect	SQL dialect for the client connection.
useStreamBlobs	Boolean flag tells driver whether stream blobs should be created by the driver, by default false. Stream blobs allow seek operation to be called, however due to a bug in gbak utility they are disabled by default.
useStandardUdf	Boolean flag tells driver to assume that standard UDFs are defined in the database. This extends the set of functions available via escaped function calls. This does not affect non-escaped use of functions.
tpbMapping	TPB mapping for different transaction isolation modes.
defaultIsolation	Default transaction isolation level. All newly created connections will have this isolation level. One of TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
defaultTransactionIsolation	Integer value from java.sql.Connection interface corresponding to the transaction isolation level specified in isolation property.
useFirebirdAutocommit	(experimental, since 2.2.9) enables the use of isc_tpb_autocommit in auto-commit mode. Real transaction commit only occurs at connection close, when disabling auto-commit or executing DDL.