Skip to content

Connection properties

Jump to bottom
Mark Rotteveel edited this page Jan 19, 2025 · 5 revisions

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.
Clone this wiki locally