JBake Bootstrap Template
I am happy to announce the release of version 3.0 of Firebird External Table Generator ( ext-table-gen for short). Firebird External Table Generator is a commandline tool to transform CSV files to Firebird external table files (a binary format for external table data). Compared to version 2.0, we added support for more datatypes: Approximate numeric types (binary floating point) float…
We are happy to announce the release of Jaybird 6.0.5 and Jaybird 5.0.12, providing bug fixes. Jaybird is the Firebird JDBC driver. Changes The following was fixed or changed since Jaybird 6.0.4: JDBC 4.5 support: JaybirdTypeCodes.DECFLOAT and JaybirdType.DECFLOAT now use type code 2015 instead of -6001 ( #906 ) JDBC 4.5 support: implemented methods enquoteIdentifier , enquoteLiteral ,…
We are happy to announce the release of Jaybird 6.0.4 and Jaybird 5.0.11, providing bug fixes. Jaybird is the Firebird JDBC driver. Changes The following was fixed or changed since Jaybird 6.0.3: Fixed: Statement close of a leaked statement by the cleaner did not detect fatal connection errors ( #879 ) Fixed: Statement.cancel() causes lockup ( #892 ) Fixed: Negative buffer size on Firebird 2.5 if…
We are happy to announce the release of Jaybird 6.0.2 and Jaybird 5.0.8. Both releases provide support for upcoming Firebird 5.0.3 inline blobs, and some other improvements. For more information on inline blobs, for Firebird 5.0.3 and higher, see also New Article: Data access methods used in Firebird . Changes The following was fixed or changed since Jaybird 6.0.1 / Jaybird 5.0.7: Improvement:…
We are happy to announce the release of Jaybird 6.0.1 and Jaybird 5.0.7. Both releases provide a number of performance improvements to blob handling, and some bug fixes. We plan to offer more blob performance improvements in upcoming releases of Jaybird 5 and 6, for Firebird 5.0.3 and higher (see also New Article: Data access methods used in Firebird ). Jaybird 6.0.1 The following was fixed or…
We are happy to announce the first release of Jaybird 6. Jaybird 6 is from a JDBC perspective an incremental change from Jaybird 5. However, internally, Jaybird underwent some major changes, the biggest was splitting off the native and embedded protocols to a separate plugin artifact ( jaybird-native ). What s new The major changes and new features in Jaybird 6 are: Minimum supported Java version…
We are happy to announce the release of Jaybird 5.0.6. The following has been fixed since Jaybird 5.0.5: Fixed: Exceptions during statement execution did not always complete the statement, which could delay transaction commit in auto-commit mode ( #806 ) Fixed: Closing a connection when the database was shutdown, or the connection was otherwise broken, could result in a NullPointerException ( #812…
We are happy to announce the release of Jaybird 5.0.5. The following has been fixed since Jaybird 5.0.4: Fixed: FBResultSetMetaData.getPrecision would always estimate the precision of NUMERIC or DECIMAL columns instead of obtaining the actual precision if the column position was 71 or higher ( #731 ) Optimized the query to retrieve extended field info for ResultSetMetaData.getPrecision to only…
A recent question on firebird-support about using Firebird on Xubuntu, and the problems the asker ran into, lead me to trying it out myself. This post is basically a collection of the steps I took to get Firebird up and running on Xubuntu. I m usually a Windows user, and although I have collected some Linux knowledge over the years, I m far from an expert. In other words, this might not be the…
We are happy to announce the release of Jaybird 5.0.4. The following has been fixed since Jaybird 5.0.3: Firebird 5.0 is now formally supported Fixed: Potential NPE when warningMessageCallback is null while reading operations or consuming packets ( #778 ) Fixed: FBRowUpdater incorrectly considers result set with only partial PK updatable backported from Jaybird 6 ( #780 ) Fixed: Use of offset…
We are happy to announce the release of Jaybird 5.0.3 and Jaybird 4.0.10. With this release, Jaybird 4 is end-of-life. We recommend upgrading to Jaybird 5. Jaybird 5.0.3 The following has been changed or fixed since Jaybird 5.0.2: Improvement: Do not reject attempts to read blob id 0 backported from Jaybird 6 ( #765 ) Previously, Jaybird rejected attempts to read blobs with blob id 0 (not on all…
I am happy to announce the release of version 2.0 of Firebird External Table Generator ( ext-table-gen for short). (It was released back in September, but I forgot to put up a post on my own website.) Firebird External Table Generator is a commandline tool to transform CSV files to Firebird external table files (a binary format for external table data). Compared to version 1.0, a lot of new…
I am happy to announce the release of Firebird External Table Generator ( ext-table-gen for short). Firebird External Table Generator is a commandline tool to transform RFC 4180 CSV files to Firebird external table files (a binary format for external table data). External tables are a good way for bulk-loading data into Firebird. Unfortunately, external tables use a fixed-width binary format, and…
We are happy to announce the release of Jaybird 5.0.2. The following has been fixed since Jaybird 5.0.1: Fixed: Reconnect transaction with a transaction id exceeding 0x7FFF_FFFF did not work ( jaybird#734 ) New feature: add connection property parallelWorkers to set Firebird 5.0 isc_dpb_parallel_workers ( jaybird#737 ) New feature: add MaintenanceManager.upgradeOds() for the Firebird 5.0…
We are happy to announce the release of Jaybird 5.0.1 and Jaybird 4.0.9. Jaybird 5.0.1 The following has been fixed since Jaybird 5.0.0: Fixed: Executing DML with a RETURNING clause containing a blob column would return the blob-id instead of the blob value ( jaybird#728 ) Fixed: CallableStatement.getString and CallableStatement.getObject would incorrectly trim string values ( jaybird#729 ) Fixed:…
We are happy to announce the first release of Jaybird 5. Jaybird 5 is from a JDBC perspective an incremental change from Jaybird 4. However, internally, Jaybird underwent some major changes, the biggest was the removal of JCA (Java Connector Architecture) support. The major changes and new features in Jaybird 5 are: Java 7 support dropped Java Connector Architecture (JCA) support removed ChaCha…
We are happy to announce the first beta for Jaybird 5. 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 Google Group or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues . Jaybird 5 is from a JDBC perspective…
Jaybird 4.0.8 has been released The following has been changed or fixed since Jaybird 4.0.7: Improvement: Backported new generated keys parser from Jaybird 5 to remove dependency on ANTLR ( jaybird#718 ) With this change, Jaybird no longer relies on antlr-runtime-4.7.2.jar , if you don t need it yourself, you can remove this library from the classpath. See New parser for generated keys handling…
Jaybird 4.0.7 has been released The following has been changed or fixed since Jaybird 4.0.6: Improvement: (VAR)CHAR is now sent to the server with blr_varying2 or blr_text2 which includes the character set information ( jaybird#692 ) Changed: Usages of String.toUpperCase and String.toLowerCase now use Locale.ROOT to prevent locale-sensitivity issues ( jaybird#697 ) New feature: Support for NBackup…
Jaybird 4.0.6 has been released The following has been changed or fixed since Jaybird 4.0.5: Improvement: Connection.isValid(int) now uses the timeout as a network timeout, if possible ( jaybird#685 ) This is only supported for pure Java connections. For native connections, the timeout is ignored (and a SQLWarning is registered). NativeResourceUnloadWebListener would fail in Servlet containers…
Jaybird 4.0.5 and 3.0.12 have been released. Jaybird 3.0.12 is the final release of Jaybird 3. The following has been changed or fixed since Jaybird 4.0.4 and 3.0.11: Fixed: JnaService implementation call to isc_service_query incorrectly includes type ( jaybird#678 ) Jaybird 4.0.5 Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11 and 17 (support for Java 17 using the Java 11 version of…
Jaybird 4.0.4 has been released. The following has been changed or fixed since Jaybird 4.0.3: Fixed: ResultSet.updateRow() sets fields to null in result set only ( jaybird#37 ) New feature: Support for NBackup GUID-based backup and in-place restore ( jaybird#672 ) Fixed: Logic error could lead to incorrect logging of "Specified statement was not created by this connection" ( jaybird#674 ) Changed:…
In December 2019, Yahoo shutdown the online archive of Yahoo Groups. At that time I had created a backup of all Firebird groups I had access to. I finally got around to publishing it online. You can find the archive at http://fb-list-archive.s3-website-eu-west-1.amazonaws.com/ . Update 2026-01-29: the archive has been moved to https://fb-list-archive.lawinegevaar.nl/ (the old URL will redirect for…
Jaybird 4.0.3 and 3.0.11 have been released. The following has been changed or fixed since Jaybird 4.0.2 and 3.0.10: Changed: Closing a statement will now be sent to the server immediately ( JDBC-638 ) Jaybird 4.0.3 Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11 and 15 (support for Java 15 using the Java 11 version of the driver); Java 16 has not been fully tested yet. See also:…
Jaybird 4.0.2 and 3.0.10 have been released. Jaybird 4.0.2 The following has been changed or fixed since Jaybird 4.0.1: Fixed: First letter of JDBC escape was case-sensitive ( JDBC-632 ) Fixed: Some usernames cannot authenticate using SRP ( JDBC-635 ) Fixed: ServiceConfigurationError while loading plugins could prevent Jaybird from loading ( JDBC-636 ) Jaybird 4 supports Firebird 2.5 and higher,…
Jaybird 4.0.1 has been released. Jaybird 4.0.1 is the first maintenance release of Jaybird 4, and introduces support for INT128 (a new type in Firebird 4), improves support for the Firebird 4 WITH TIME ZONE types by adding support for java.time.ZonedDateTime and making some of the derivation rules more consistent with Firebird. It also provides some bug fixes and other changes. The following has…
Jaybird 3.0.9 has been released. This release contains the following changes: Fixed: changes to the transaction configuration (transaction parameter buffer configuration) of one connection are no longer propagated to other connections with the same connection properties ( JDBC-386 ) New feature: Firebird 4 data type bind configuration support ( JDBC-603 ) New feature: Jaybird now supports UTF-8…
We are happy to announce the first release of 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…
We are happy to announce the second beta for Jaybird 4. 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 -…
Jaybird 3.0.8 has been released. This release contains one bug fix: Fixed: On Firebird 3 and 4 with WireCrypt = Enabled , the connection could hang or throw exceptions like "Unsupported or unexpected operation code" . ( JDBC-599 ) Jaybird 3.0 supports Firebird 2.0 and higher, on Java 7, 8, 11 and 13. Basic Java 9 and higher compatibility is provided through the Java 8 version of the driver. See…
Jaybird 3.0.7 has been released. This release contains a new feature and two bug fixes: Fixed: attempts to use a blob after it was freed or after transaction end could throw a NullPointerException or just work depending on whether the connection had a new transaction. ( JDBC-587 ) Fixed: Instances of java.sql.Blob and java.sql.Clob obtained from a result set were freed after calls to…
Flyway is a database migration (versioning) tool that supports a wide variety of database systems. Recently, they accepted my pull request to add support for Firebird in Flyway 6.0. Although my pull request supported Firebird 2.1 and higher, the Flyway team has decided to only support Firebird 3 and higher. I assume this was decided as Firebird 2.5 and earlier are all end-of-life. At this time,…
I have just released org.firebirdsql:firebird-testcontainers-java:1.0.0 , based on Testcontainers . This library allows you to start a Firebird docker container for a JUnit 4 or 5 test or manually from your code. This can be useful for JUnit-based integration tests. For a very simple example, add to your pom.xml: <dependency> <groupId>org.firebirdsql</groupId>…
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…
We are happy to announce the first beta for Jaybird 4. 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…
We are happy to announce the release of Jaybird 2.2.15. Jaybird 2.2.15 is the last version of Jaybird 2.2.x, and we will not plan new changes or fixes for 2.2.x. This effectively means that Jaybird 2.2.x is End-Of-Life. If you run into problems, we will recommend that you switch to Jaybird 3 (or 4 once it is released). Contact us on Firebird-Java for questions. Jaybird 2.2.15 contains the…
We are happy to announce the release of Jaybird 3.0.5. This release is largely a bugfix release, but contains additional support for Firebird 3.0.4 and Firebird 4. Jaybird 3.0.5 contains the following fixes and changes: Fixed: FBManager does not accept page size of 32768 (Firebird 4 and higher) ( JDBC-468 ) Fixed: Jaybird cannot parse Firebird version numbers with revisions ( JDBC-534 ) Fixed:…
We are happy to announce the release of Jaybird 3.0.4. This release of Jaybird introduces two new features: wire protocol encryption and database encryption callback support. Jaybird 3.0.4 contains the following fixes and changes: New feature: Back-ported wire encryption support from Jaybird 4 ( JDBC-415 ) Fixed: Native/embedded (JNA) connections truncate varchars to length 255 on read ( JDBC-518…
This post serves as documentation of the steps to migrate the remaining CVS repositories of the Firebird project from SourceForge to GitHub. General steps Some steps for the migration are inspired by (or plainly copied from) https://sourceforge.net/p/forge/documentation/CVS/ The most important step, the migration itself, is explicitly not taken from the SourceForge documentation, as this turned…
I just published a small example program using Firebird 3 Embedded with Jaybird 3. You can find it on https://github.com/mrotteveel/jaybird-embedded-example . This example is Windows (64 bit) specific, but should easily translate to other platforms (just a matter of including the equivalent libraries in the fb folder). Running the example To compile and run the example application from the…
We are happy to announce the release of Jaybird 3.0.2. The following has been changed or fixed in Jaybird 3.0.2: Fixed: Specifying an unknown Java character set in connection property charSet or localEncoding was handled as if no connection character set had been specified, now we throw an exception that the character set is unknown. ( JDBC-498 ) Changed: Specifying a connection character set is…
We are happy to announce the release of Jaybird 3.0.1. The following has been changed or fixed in Jaybird 3.0.1: Fixed: FBTraceManager.loadConfigurationFromFile strips line breaks ( JDBC-493 ) Fixed: FBDatabaseMetaData.getTables does not list tables where rdb$relation_type is null ( JDBC-494 ) Improvement: Character sets are now initialized lazily ( JDBC-495 ) Fixed: Memory leak caused by…
Vlad Mihalcea recently posted the blog How to run integration tests at warp speed using Docker and tmpfs , and I thought it would be interesting to see what needed to be done to run the Jaybird tests against a Firebird instance on docker. I am writing this post as documentation for myself, but I hope it might be useful for others as well. Note that I don t have a lot of experience with docker, so…
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…
Bugfix version Fixes: Loading of multi-action triggers Column loading for tables containing blobs Loading of constraints Loading of index columns Order of indices in DDL generation Linebreaks in DDL stored procedures and triggers DDL generation for sequences Leave delegation to plugin config, don t hardcode Gotcha s: Largely untested (only minor testing done under Eclipse 3.5.2 with DTP 1.7.2 and…
Bugfix and 'less-is-more' release Changes: Code cleanup More delegation to standard DTP implementation Sourcecode added to distribution Fixes: Now all stored procedures are shown Numeric fields are shown correctly in 'Data > Edit' (tested in Eclipse 3.5 / DTP 1.7) Stored procedures code should be correct (unverified) Trigger code is loaded Menu 'Sample contents' now works correctly Gotcha s:…
First step integrating Roman Rokytskyy work. Changes: Used other (generic) UI for connection The full jdbc-URL must be used Connection now uses two 'virtual' schemas, SYSTEM and USER, to separate system metadata (RDB$.. and MON$.. tables/views) from the usermetadata Sequences (generators) are now visible Selectable stored procedures are now grouped under stored procedures Constraints are now shown…
First version based on Brian Fitzpatrick s work. Gotcha s: Database version is 2.1, but it should work with most - if not all - Firebird versions The connectionprofile wizard has a browse button (copied from the SQLite or Derby implementation): this doesn t work correctly forfirebird and will be removed in a next version (see also next bullet) Manually enter the 'Database location' as the string…