We are happy to announce the release of Jaybird 3.0.6.
This release is largely a bugfix release, but contains additional support for Firebird 4.
Jaybird 3.0.6 contains the following fixes and changes:
- 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)
Jaybird 3.0 supports Firebird 2.0 and higher, on Java 7, 8 and 9 and
higher. Basic Java 9 and higher compatibility is provided through the
Java 8 version of the driver.
The first beta for Jaybird 4 is available for testing.
We’d really appreciate it if you take the time to test this version
of Jaybird with your applications. 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.
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)
Authentication plugin improvements
Firebird 4 DECFLOAT support
Firebird 4 extended numeric precision support
Firebird 4 time zone support
JDBC RowId support
JDBC DatabaseMetaData.getPseudoColumns implemented
JDBC DatabaseMetaData.getVersionColumns implemented
Improved JDBC function escape support
New JDBC protocol prefix jdbc:firebird:
Generated keys support improvements
Jaybird 4.0.0-beta-1 is for testing purposes only, and not intended for production use.
Alex Peshkoff added 3 new builtin functions : base64_encode/decode and crc32 in Firebird master branch related to
IBSurgeon is happy to announce the new release of HQbird – advanced Firebird distribution for enterprises, with the following features: native (high-performance and transactions friendly) master-slave replication, improved performance, advanced performance monitoring, automated backups, proper maintenance.
HQbird is 100% compatible with Firebird, it does not require backup/restore to move between HQbird and community Firebird.
This release includes many new features and improvements:
Advanced support of DDL during the replication
- Automatic configuration:
- operative and archive logs are created and registered automatically in replication configuration and Cloud Backup jobs
- Windows installer has the option to install a replica with pre-configured database instance.
- Improved automatic database re-initialization
- The Pool of Execute On External connections now is available in Firebird 3.0 (as it was in 2.5) which included to HQbird – greatly increases stability and speed of Execute On External statements. The pool can be reviewed and controlled by SQL commands
- New monitoring options:
- Performance Summary to see cumulative reads/writes/fetches and SQL Ping to monitor database response
- Detailed information about all temporary files in Firebird
- Indices statistics job now recalculates all indices in AUTO mode (recommended to set it to run once per week)
- Automatic upgrade now is also in Linux installer, as it was in Windows – if you already had HQbird installed, Linux installer will update it correctly without reinstallation
- New context variable indicating is it master or replica RDB$GET_CONTEXT(‘SYSTEM’, ‘REPLICA’)
- Fixes in the interface: icons, sorting order of graphs, etc
Download HQbird 2018 R3 and upgrade your existing version!
If you have a valid Firebird Support Service agreement or active Maintenance subscription, our technicians will contact you to perform the upgrade.
Please note that all licenses are compatible with HQbird 2017 and HQbird 2018.
Also, If you already tried HQbird and need a new trial – please send the request to firstname.lastname@example.org
Firebird Performance Tour 2019 will take place in Moscow (November 29, 2018), Prague (Dec 4, 2018) and Bad Sassendorf, Germany (Dec 6, 2018).
Firebird Performance Tour will be devoted to the complex parts of SQL queries optimizations and their monitoring.
More details here
Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.
This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.
Please note that some of the changes includes a new ODS minor version (12.2) for some platforms (Windows and Intel Linux will keeps using 12.0) and a new parameter Srp256 (SHA-256) for AuthClient and AuthServer. Be sure to read the release notes to be aware of all the improvements and bugfixes.
Still using an old Firebird version? Migrate now and don’t forget to read my Migration Guide to Firebird 3 to save you a few hours of headache.