Firebird Class 4 JCA-JDBC Driver Downloads

• Jaybird 4
• Jaybird 3
• Jaybird 2.2

Jaybird 4

Jaybird 4.0.6 released.

Jaybird 4.0.6 is the sixth maintenance release of Jaybird 4.

See the full release notes for more information.

The release is also available on maven(*):

groupId: org.firebirdsql.jdbc
artifactid: jaybird
version: 4.0.6.javaXX*

* The version depends on your target Java version: 4.0.6.java11 (for Java 11 and higher), 4.0.6.java8, or 4.0.6.java7

Additional resources:

• Jaybird 4.0.x javadoc
• Jaybird JDBC Driver Java Programmer's Manual

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:

• Wire encryption support (backported to Jaybird 3.0.4)
• Database encryption support (backported to Jaybird 3.0.4)
• Wire compression support
• Authentication plugin improvements
• Firebird 4 data type bind configuration support (since Jaybird 4.0.0-beta-2)
• Firebird 4 DECFLOAT support
• Firebird 4 extended numeric precision support
• Firebird 4 time zone support
• Firebird 4 statement timeout support (since Jaybird 4.0.0-beta-2)
• JDBC RowId support
• DatabaseMetaData getPseudoColumns implemented
• DatabaseMetaData getVersionColumns implemented
• DatabaseMetaData getFunctions implemented (since Jaybird 4.0.0-beta-2)
• DatabaseMetaData getFunctionColumns implemented (since Jaybird 4.0.0-beta-2)
• Improved JDBC function escape support
• New JDBC protocol prefix jdbc:firebird:
• URL encoding in query part of JDBC URL (backported to Jaybird 3.0.9)
• Generated keys support improvements
• Operation monitoring

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.

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 https://github.com/FirebirdSQL/jaybird/issues.

See also the full Jaybird 4 release notes.

Jaybird 3.0

Jaybird 3.0.12 released, this the final version of Jaybird 3, we recommend switching to Jaybird 4.

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.12

* The artifactId depends on your target Java version: jaybird-jdk18 (for Java 8 and higher), or jaybird-jdk17

Additional resources:

• Jaybird 3.0.x javadoc
• Jaybird JDBC Driver Java Programmer's Manual

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

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

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:

• Jaybird 2.2.x javadoc
• Jaybird JDBC Driver Java Programmer's Manual

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