Firebird Class 4 JCA-JDBC Driver Downloads
Jaybird 4
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
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
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
The Firebird JDBC team would like to thank YourKit for providing licenses to their YourKit Java Profiler.
