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:
| Java 7 (JDBC 4.1) | Jaybird-2.2.3JDK_1.7.zip |
|---|---|
| Java 6 (JDBC 4.0) | Jaybird-2.2.3JDK_1.6.zip |
| Java 5 (JDBC 3.0) | Jaybird-2.2.3JDK_1.5.zip |
| Sources | Jaybird-2.2.3-src.zip |
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:
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.
DatabaseMetaData.getColumns(...) (JDBC-309)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:
FBMaintenanceManager.listLimboTransactions() reports incorrect transaction id when the result contains multi-site transactions in limbo (JDBC-266)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)isc_dpb_types.properties (JDBC-284SQLException 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)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:
UnsatisfiedLinkError in libjaybird22(_x64).so undefined symbol: _ZTVN10__cxxabiv117__class_type_infoE on Linux (JDBC-259) 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).
setString(column, null) on “? IS (NOT) NULL” condition does not set parameter to NULL (JDBC-264)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)charSet property are case-sensitive (JDBC-268)NULL with the native protocol does not work when Firebird describes the parameter as not nullable (JDBC-271)New features:
getGeneratedKeys(),Changes since Jaybird 2.2.0-beta-1:
ConcurrentModificationException when closing connection obtained from org.firebirdsql.ds.FBConnectionPoolDataSource with statements open (JDBC-250),FBBackupManager does not allow 16kb page size for restore (JDBC-255),Connection when no explicit connection character set is specified (JDBC-257)See Older versions