JayBird 3 is released

We are happy to announce the release of Jaybird 3.0.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
  • 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 also:

FirstAID 5.0: Firebird 3.0 and InterBase XE7 and support of 100+Gb databases

We are proud to present IBSurgeon FirstAID 5.0 – the new version of the recovery software with the highest rate of successful repairs. FirstAID 5.0 is a major improvement: now it supports Firebird 3.0, InterBase XE7, and big databases (100Gb+).

Download IBSurgeon FirstAID 5.0

If you are a user of FirstAID version 3.x or 4.x, you can log into IBSurgeon Deploy Center and see that you were automatically upgraded to version 5.0. All your licenses were transferred to 5.0.

IBSurgeon FirstAID 5.0 -50% upgrade offer till May 15
If you have the license for FirstAID version 1.x or 2.x (including Pack 3.x), or if you have used all licenses for 3.x/4.x, we would like to offer you 50% discount to upgrade to FirstAID 5.0 Tech Support (for 50 databases) for the special price: USD$99. This is a limited offer till May 15 only!
Upgrade Now!

Firebird Pascal Client API 1.0.2 is now available for both FPC and Delphi

MWA Software’s  Firebird Pascal Client API package (fbintf) release 1.0.2 is now available for download. The package has been updated to support Delphi Win32 (from Delphi 2010 onwards) in addition to the Free Pascal Compiler (3.0.0 onwards). The package is otherwise functionally identical to release 1.0.1.

The Firebird Pascal Client API package provides common Pascal language bindings to the Firebird API that are independent of the Firebird API version. Both legacy and Firebird 3 APIs are supported. The fbintf package provides the Firebird API in a format where all data types for SQL data, interface parameters and results are native Pascal types, including all parameter blocks and database information. The Pascal API is pitched at a similar level and purpose to the IBPP Firebird API provided to the C++ world. It is a required dependency for version 2 onwards of IBX for Lazarus, and is provided as both a standalone package and as part of IBX2.

The Firebird Pascal API is intended to be simple to use and to place the minimum burden on the API user when it comes to managing the Firebird client library and the various Pascal objects that are created to provide the API. It is implemented as reference counted COM interfaces which, for the API user, are as easy to use as other managed types such as AnsiStrings and dynamic arrays. The user only needs to worry about accessing and using the interface; disposing of interfaces is performed automatically whenever an interface goes out of scope. It is intended to be a full implementation of the Firebird API, including events, services, blobs and arrays.

It is distributed under the IDP Licence.

The package may be downloaded from https://www.mwasoftware.co.uk/fb-pascal-api

A comprehensive user manual fully describing the API is available from https://www.mwasoftware.co.uk/documentation

Firebird encryption plugin and sources of client application

IBSurgeon has released the complete trial kit for Firebird encryption, which includes fully functional time-limited AES256 encryption plugin and demo application (in Delphi) to demonstrate how to connect to the encrypted database.

The trial kit is designed for the following:
1) Easy performance testing of the existing databases with the encryption: you can encrypt database on the server and test your existing applications without changing them.
2) Implement client-side security: there is a simple example of Delphi application (sources included) which demonstrates how to send the key from the client to the server.
Download Firebird encryption plugin and example of a client application.

1 7 8 9 10 11 57