Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

News & Events
August 20, 2016

Jaybird 3.0.0-alpha-1 has been published for testing. We would really appreciate if you could start testing your applications with this version and provide feedback on stability and behavior, but also on the release notes.

Feedback can be sent to the Firebird-java mailinglist or on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

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

We recommend that you do not consider Jaybird 3.0 a drop-in replacement for Jaybird 2.2, and study the release notes carefully.

See:

Jaybird 3.0 Alpha 1 is available from Maven central: see instructions in the release notes.

Jaybird 3.0.0-alpha-1 has been published for testing. We would really appreciate if you could start testing your applications with this version and provide feedback on stability and behavior, but also on the release notes.

Feedback can be sent to the Firebird-java mailinglist or on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

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

We recommend that you do not consider Jaybird 3.0 a drop-in replacement for Jaybird 2.2, and study the release notes carefully.

See:

Jaybird 3.0 Alpha 1 is available from Maven central: see instructions in the release notes.

August 19, 2016
We start to publish announces of talks for Firebird Conference 2016 (don't miss Early Bird registration offer - less than 2 weeks left!) - the first is devoted to CloudaIDE, great web framework designed for database developers.

Introduction to CloudaIDE - Web Framework requiring only database programming skills
Dragging and dropping database objects from the datasource browser to quickly create screen layout with database bound controls. Easy ways to achieve arbitrarily complex master-detail structures of the screen data. Undo-redo, drag ad drop, cut and paste. Property lists.
Innovative lists of values acting also as data entry forms and means of navigation through interrelated data. Innovative menus that integrate breadcrumbs and ordinary menus. Out of the box Query By Example mechanism. Client side programming language as an easy to grasp subset of PL/SQL. Used to program user interaction and remotely call stored procedures. 

Techniques and design recommendations to detect and prevent an attack. Client and server side session state components. Pooled database connections as a mean to reduce server load. Scalability and reliability by reducing network traffic and the database server load. Incremental data transfer between client and server. Single page architecture. Locking strategies.

Automation of all the development steps including the deployment of the application to the integrated test web server. Pre-configured web server.
Free use of CloudaIDE for FirebirdSQL based development and deployment. The project site is http://cloudaide.org
We start to publish announces of talks for Firebird Conference 2016 (don't miss Early Bird registration offer - less than 2 weeks left!) - the first is devoted to CloudaIDE, great web framework designed for database developers.

Introduction to CloudaIDE - Web Framework requiring only database programming skills
Dragging and dropping database objects from the datasource browser to quickly create screen layout with database bound controls. Easy ways to achieve arbitrarily complex master-detail structures of the screen data. Undo-redo, drag ad drop, cut and paste. Property lists.
Innovative lists of values acting also as data entry forms and means of navigation through interrelated data. Innovative menus that integrate breadcrumbs and ordinary menus. Out of the box Query By Example mechanism. Client side programming language as an easy to grasp subset of PL/SQL. Used to program user interaction and remotely call stored procedures. 

Techniques and design recommendations to detect and prevent an attack. Client and server side session state components. Pooled database connections as a mean to reduce server load. Scalability and reliability by reducing network traffic and the database server load. Incremental data transfer between client and server. Single page architecture. Locking strategies.

Automation of all the development steps including the deployment of the application to the integrated test web server. Pre-configured web server.
Free use of CloudaIDE for FirebirdSQL based development and deployment. The project site is http://cloudaide.org
August 07, 2016
The Firebird JDBC team is happy to announce the release of Jaybird 2.2.11.

The following has been changed or fixed in Jaybird 2.2.11:

  • Fixed: Dialect 1, NUMERIC(15,2) and DatabaseMetadata.getColumn returns 0 for DECIMAL_DIGITS (JDBC-426)
  • Updated error messages from latest Firebird 3 to add missing messages (JDBC-428)
  • Fixed: ResultSet.getObject() returns byte[] instead of String for BLOB SUB_TYPE 1 when using octetsAsBytes (JDBC-431)
  • Improvement: Support Firebird 3 48-bit transaction ids. (JDBC-432)
    Note that FBMaintenanceManager.commit/rollbackTransaction(long) with longer than 32 bit transaction ids requires Firebird 3.0.1 because of CORE-5224.
  • Fixed: Batch insert with setBinaryStream inserts an empty BLOB SUB_TYPE TEXT (JDBC-433)
    This is the same issue as JDBC-312 that was fixed in Jaybird 2.2.4 for BLOB SUB_TYPE BINARY.
  • Changed locking to coarser blocks with - as far as possible - a single lock object per connection for all connection-derived objects (JDBC-435)
    This should prevent deadlocks on concurrent access as in some cases locks were obtained in different orders (eg (statement, connection), and (connection, statement)). The downside is reduced concurrency, but as using a connection from multiple threads concurrently is discouraged anyway, that is an acceptable price to pay.
See the JDBC driver download page for download links. The release is also available on maven, with a separate artifact for each supported Java version:

Groupid: org.firebirdsql.jdbc, artifactid: jaybird-jdkXX (where XX is 16, 17 or 18).
Version: 2.2.11

For example:


    org.firebirdsql.jdbc
    jaybird-jdk18
    2.2.11
The Firebird JDBC team is happy to announce the release of Jaybird 2.2.11.

The following has been changed or fixed in Jaybird 2.2.11:

  • Fixed: Dialect 1, NUMERIC(15,2) and DatabaseMetadata.getColumn returns 0 for DECIMAL_DIGITS (JDBC-426)
  • Updated error messages from latest Firebird 3 to add missing messages (JDBC-428)
  • Fixed: ResultSet.getObject() returns byte[] instead of String for BLOB SUB_TYPE 1 when using octetsAsBytes (JDBC-431)
  • Improvement: Support Firebird 3 48-bit transaction ids. (JDBC-432)
    Note that FBMaintenanceManager.commit/rollbackTransaction(long) with longer than 32 bit transaction ids requires Firebird 3.0.1 because of CORE-5224.
  • Fixed: Batch insert with setBinaryStream inserts an empty BLOB SUB_TYPE TEXT (JDBC-433)
    This is the same issue as JDBC-312 that was fixed in Jaybird 2.2.4 for BLOB SUB_TYPE BINARY.
  • Changed locking to coarser blocks with - as far as possible - a single lock object per connection for all connection-derived objects (JDBC-435)
    This should prevent deadlocks on concurrent access as in some cases locks were obtained in different orders (eg (statement, connection), and (connection, statement)). The downside is reduced concurrency, but as using a connection from multiple threads concurrently is discouraged anyway, that is an acceptable price to pay.
See the JDBC driver download page for download links. The release is also available on maven, with a separate artifact for each supported Java version:

Groupid: org.firebirdsql.jdbc, artifactid: jaybird-jdkXX (where XX is 16, 17 or 18).
Version: 2.2.11

For example:


    org.firebirdsql.jdbc
    jaybird-jdk18
    2.2.11