Downloads

Jaybird 2.2.3 is the latest version of the Firebird JDBC driver. See the full Jaybird 2.2.3 releasenotes for all information. These releasenotes are also included in the download.

The download includes javadoc, which are also available online (Java 7 version).

As an additional resource, you can use the Jaybird 2.1 JDBC Driver Java Programmer's Manual.

You can download Jaybird 2.2.3 from:

Jaybird 2.2.3 is also available on Maven

Depency info:

<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.3</version>

Where jdkXX is either jdk17, jdk16 or jdk15.

Older Jaybird releases can be downloaded from SourceForge

There is also an Android port of Jaybird 2.2 available. This is a separate project http://sourceforge.net/projects/androidjaybird/

Changes since Jaybird 2.2.3:

• Fixed incorrect synchronization in native and embedded protocol (JNI) implementation for iscBlobInfo and iscSeekBlob (JDBC-300)

WARNING: Although Jaybird strives for correct synchronization, a JDBC Connection, and its dependent objects should be used from a single Thread at a time, sharing on multiple threads concurrently is not advisable.

• Fixed holdable ResultSet is closed on auto-commit (JDBC-304, JDBC-305)
• Fixed table names missing or padded with spaces in Database view of IntelliJ IDEA (JDBC-308, IDEA-100786)
• Fixed incorrect JDBC minor version reported under Java 7; this resulted in an incorrect column name (for Java 7) in the metadata of DatabaseMetaData.getColumns(...) (JDBC-309)
• Added IOException to cause of GDSException with error 335544721; “Unable to complete network request to host ““” for further investigation (JDBC-306)

The following are known in issues in Jaybird 2.2.3 (and earlier):

• ResultSets opened with CLOSE_CURSORS_AT_COMMIT aren’t correctly closed on commit when auto-commit is off (JDBC-307)

This list is not exhaustive, see the Jaybird tracker (http://tracker.firebirdsql.org/browse/JDBC) for a full list of open bugs.

Changes since Jaybird 2.2.1:

• Fixed: FBMaintenanceManager.listLimboTransactions() reports incorrect transaction id when the result contains multi-site transactions in limbo (JDBC-266)
• Fixed: Calling PreparedStatement.setClob(int, Clob) with a non-Firebird Clob (eg like Hibernate does) or calling PreparedStatement.setClob(int, Reader) throws FBSQLException: “You can’t start before the beginning of the blob” (JDBC-281)
• Fixed: Connection property types not properly processed from isc_dpb_types.properties (JDBC-284
• Fixed: JNI implementation of parameter buffer writes incorrect integers (JDBC-285, JDBC-286)
• Changed: Throw SQLException when calling execute, executeQuery, executeUpdate and addBatch methods accepting a query string on a PreparedStatement or CallableStatement as required by JDBC 4.0 (JDBC-288)
• Fixed: LIKE escape character JDBC escape ({escape '<char>'}) doesn’t work (JDBC-290)
• Added: Support for a connect timeout using connection property connectTimeout. This property can be specified in the JDBC URL or Properties object or on the DataSource. If the connectTimeout property is not specified, the general DriverManager property loginTimeout is used. The value is the timeout in seconds. (JDBC-295)

Changes since Jaybird 2.2.0:

• Fixed: UnsatisfiedLinkError in libjaybird22(_x64).so undefined symbol: _ZTVN10__cxxabiv117__class_type_infoE on Linux (JDBC-259)
• Added connection property columnLabelForName for backwards compatible behavior of ResultSetMetaData#getColumnName(int) and compatibility with bug in com.sun.rowset.CachedRowSetImpl (JDBC-260)

Set property to true for backwards compatible behavior (getColumnName() returns the column label); don’t set the property or set it to false for JDBC-compliant behavior (recommended).

• Fixed: setString(column, null) on “? IS (NOT) NULL” condition does not set parameter to NULL (JDBC-264)
• The charSet connection property now accepts all aliases of the supported Java character sets (eg instead of only Cp1252 now windows-1252 is also accepted) (JDBC-267)
• Fixed: values of charSet property are case-sensitive (JDBC-268)
• Fixed: setting a parameter as NULL with the native protocol does not work when Firebird describes the parameter as not nullable (JDBC-271)

New features:

• Enhanced support for JDBC 4.0 (Java 6),
• Support for JDBC 4.1 (Java 7) - including try-with-resources support,
• Implementation of getGeneratedKeys(),
• Enhanced support for the services API,
• Support for 64 bit native libraries for Type 2 / Embedded,
• A number of bug fixes.

Changes since Jaybird 2.2.0-beta-1:

• ConcurrentModificationException when closing connection obtained from org.firebirdsql.ds.FBConnectionPoolDataSource with statements open (JDBC-250),
• Memory leak when obtaining multiple connections for the same URL (JDBC-249),
• CPU spikes to 100% when using events and Firebird Server is stopped or unreachable (JDBC-232),
• Events do not work on Embedded (JDBC-247),
• Provide workaround for characterset transliteration problems in database filenames and other connection properties (JDBC-253),
• FBBackupManager does not allow 16kb page size for restore (JDBC-255),
• Log warning and add warning on Connection when no explicit connection character set is specified (JDBC-257)

See Older versions

• Firebird-J, custom Firebird build to show the possibilities of the Java stored procedures.
• Release notes

• IronEyeSQL 1.2.358 - binary version of IronEyeSQL tool (some time ago was available on SourceForge.net under the name IronGrid)