Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
JDBC Driver
Firebird Class 4 JCA-JDBC Driver Downloads Jaybird 4
Release Date File Name Description
Jaybird 4.0.0-beta-1
April 27, 2019 jaybird-java11-4.0.0-beta-1.zip Jaybird 4.0.0-beta-1 for Java 11 / JDBC 4.3
April 27, 2019 jaybird-jdk18-4.0.0-beta-1.zip Jaybird 4.0.0-beta-1 for Java 8 / JDBC 4.2
April 27, 2019 jaybird-jdk17-4.0.0-beta-1.zip Jaybird 4.0.0-beta-1 for Java 7 / JDBC 4.1

Jaybird 4.0.0-beta-1 released.

Jaybird 4.0.0-beta-1 is a test version of Jaybird 4. This version is provided for testing purposes only. We'd appreciate your feedback, but we'd like to emphasize that this version is not intended for production.

Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to the Firebird-java mailing list or reported on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

See the full release notes for more information.

The release is also available on maven(*):

groupId: org.firebirdsql.jdbc
artifactid: jaybird-XX*
version: 4.0.0-beta-1

* The artifactId depends on your target Java version: jaybird-java11, jaybird-jdk18, or jaybird-jdk17

Additional resources:

About Jaybird 4

Jaybird 4 is - compared to Jaybird 3 - an incremental release that builds on the foundations of Jaybird 3. The focus of this release has been on further improving JDBC support and adding support for the new data types and features of Firebird 4.

The main new features are:

Upgrading from Jaybird 3 to 4 should be simple, but please make sure to read Compatibility changes before using Jaybird 4. See also Upgrading from Jaybird 3 to Jaybird 4.

Jaybird 3.0
Release Date File Name Description
Jaybird 3.0.6
May 25, 2019 Jaybird-3.0.6-JDK_1.8.zip Jaybird 3.0.6 for Java 8 / JDBC 4.2, zip kit (also suitable for Java 9 and higher)
May 25, 2019 Jaybird-3.0.6-JDK_1.7.zip Jaybird 3.0.6 for Java 7 / JDBC 4.1, zip kit

Jaybird 3.0.6 released.

The following has been changed or fixed since Jaybird 3.0.5

  • Fixed: Exceptions during fetch of cached result sets (holdable over commit, scrollable and metadata) prevented prepared statement reuse/re-execute with error "Statement state CURSOR_OPEN only allows next states [CLOSING, PREPARED, ERROR], received EXECUTING" (JDBC-531)
  • Improvement: Added FBManager.setDefaultCharacterSet to set default database character set during database creation (JDBC-541)
  • New feature: Support for Firebird 3 case sensitive user names (JDBC-549)
  • Fixed: Savepoints did not work in connection dialect 1 as savepoint names were always quoted (JDBC-556)
  • Changed: The DatabaseMetaData statement cache introduced in Jaybird 3 was unlimited, it is now limited to 12 prepared statements; the least recently used statement will be closed and removed when a new statement is added (JDBC-557)
  • Fixed: UPDATE OR INSERT with existing RETURNING clause handled incorrectly for generated keys (JDBC-566)
  • Fixed: Exceptions during initialization of result sets would not properly close the database cursor leading to error "Current statement state (CURSOR_OPEN) does not allow call to prepare" on reuse of the statement (or errors similar to described for JDBC-531 above). (JDBC-571)
  • New feature: boolean connection property ignoreProcedureType to disable usage of metadata for stored procedure types in CallableStatement. When set to true, call escapes and EXECUTE PROCEDURE will default to use EXECUTE PROCEDURE and not switch to SELECT for selectable stored procedures. (JDBC-576)
  • New feature: connection properties timeZoneBind and sessionTimeZone for limited support for Firebird 4 TIME(STAMP) WITH TIME ZONE types, and decfloatBind for limited support for Firebird 4 DECFLOAT types. (JDBC-538)
  • Fixed: Connection property defaultIsolation/isolation did not work through DriverManager, but only on DataSource implementations. (JDBC-584)

See the full release notes for more information.

The release is also available on maven(*):

groupId: org.firebirdsql.jdbc
artifactid: jaybird-jdkXX*
version: 3.0.6

* The artifactId depends on your target Java version: jaybird-jdk18, or jaybird-jdk17

Additional resources:

About Jaybird 3.0

Jaybird 3.0 is a big change from Jaybird 2.2 and earlier. The entire low-level implementation has been rewritten to be able to support protocol improvements in newer Firebird versions. We have also made changes with a stricter interpretation of the JDBC requirements, and removed some parts that were either obsolete or not functioning correctly.

Most notable changes in Jaybird 3:

  • Support for wire protocol versions 11, 12, and 13 (without support for encryption and compression); protocol version 13 contributed by Hajime Nakagami (wire protocol encryption has been added in 3.0.4)
  • Support for the Firebird 3 SRP (Secure Remote Password) authentication mechanism (contributed by Hajime Nakagami)
  • Support for streaming backup and restore (contributed by Ivan Arabadzhiev)
  • Improved Firebird 3 support
  • Improved and stricter JDBC support (including improved java.time support, and more optional methods implemented)
  • Initial JDBC 4.3 (Java 9) support (without real module support)
  • New implementation of the native/embedded Type 2 driver using JNA (a jaybird .dll/.so is no longer needed)
  • Improved character set handling
  • Removal of (buggy) connection pool implementation
  • Removal/replacement of (internal) GDS API

And a large number of smaller bug fixes, improvements, and changes.

We recommend that you do not consider Jaybird 3.0 a drop-in replacement for Jaybird 2.2, and study the release notes carefully. Test your application with Jaybird 3.0 before using it in production.

Jaybird 3.0 supports Firebird 2.0 and higher, on Java 7, 8 and 9. Basic Java 9 compatibility is provided through the Java 8 version of the driver.

See Jaybird 3.0.x release notes for details.

Jaybird 2.2

Release Date File Name Description
Jaybird 2.2.15
April 6, 2019 Jaybird-2.2.15-JDK_1.8.zip Jaybird 2.2.15 for Java 8 / JDBC 4.2, zip kit
April 6, 2019 Jaybird-2.2.15-JDK_1.7.zip Jaybird 2.2.15 for Java 7 / JDBC 4.1, zip kit
April 6, 2019 Jaybird-2.2.15-JDK_1.6.zip Jaybird 2.2.15 for Java 6 / JDBC 4.0, zip kit


Jaybird 2.2.15 released,  this the final version of Jaybird 2.2.x, we recommend switching to Jaybird 3.

The following has been changed or fixed since Jaybird 2.2.14:

  • Fixed: Exceptions during fetch of cached result sets (holdable over commit, scrollable and metadata) prevented prepared statement reuse/re-execute with error “Attempt to reopen an open cursor” (JDBC-531)
  • Fixed: Jaybird cannot parse Firebird version numbers with revisions (JDBC-534)
  • Fixed: Incorrect parsing of Firebird version numbers (JDBC-535)

See the full release notes for more information.

The release is also available on maven(*):

groupId: org.firebirdsql.jdbc
artifactid: jaybird-jdkXX*
version: 2.2.15

* The artifactId depends on your target Java version: jaybird-jdk18, jaybird-jdk17, or jaybird-jdk16

All released versions are available at GitHub.

Additional resources:

Sponsors
YourKit logo The Firebird JDBC team would like to thank YourKit for providing licenses to their YourKit Java Profiler.

Join Firebird!
RSS Newsletter
Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2018, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.