GlassFish and Firebird JDBC driver Jaybird
This page describes how to configure GlassFish for use with Jaybird. These instructions are based on GlassFish Server Open Source Edition 3.1.2.2 and Jaybird 2.2.3.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Django Firebird current status
Maximiliano Robaina announced django firebird driver status related to django 1.6 :
I’m pleased to announce that django-firebird with django 1.6 support is underway.
Django 1.6 is still in alpha state, so django-firebird 1.6 too.
Then, you can see the current status at the master branch . The master branch has the “in develop” version. If you need stable support (django 1.5) take a look at stable/1.5.x
What are the changes in database field?
The main changes is on transaction management and including BinaryField
Django 1.6 release notes
Windows Azure Web Sites and Firebird
Jiří Činčura wrote about his experience with Firebird Embedded and Azure Websites
To sum up. Firebird Embedded works well in Windows Azure Websites. If you need fully featured SQL database for zero extra-money with option to go hassle-free to full server if the need comes, it’s a way to go.
Jaybird 2.2.3 (Firebird JDBC) released
The Firebird JDBC team is happy to announce the release of Jaybird 2.2.3.
See http://www.firebirdsql.org/en/jdbc-driver/ for the downloadlinks.
The release is also available on maven:
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.3</version>
The artifactId depends on your target Java version: jaybird-jdk15, jaybird-jdk16 or jaybird-jdk17.
The following has been changed or fixed in Jaybird 2.2.3:
- Fixed incorrect synchronization in native and embedded protocol (JNI) implementation for iscBlobInfo and iscSeekBlob (JDBC-300)
- Fixed holdable ResultSet is closed on auto-commit (JDBC-304, JDBC-305)
- Fixed table names missing or padded with spaces in Database view of IntelliJ IDEA (JDBC-308, IDEA-100786)
- Fixed incorrect JDBC minor version reported under Java 7; this resulted in an incorrect column name (for Java 7) in the metadata of DatabaseMetaData.getColumns(…) (JDBC-309)
- Added IOException to cause of GDSException with error 335544721; “Unable to complete network request to host “”” for further investigation (JDBC-306)
More details are available in the Jaybird 2.2.3 releasenotes.
isql documentation update
The manual for isql has been hugely updated, tidied up and is now online at
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/isql.html for the html and at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-isql.pdf for the pdf version.If you get an older version that document 0.5 then the cache needs to be flushed.
It’s still not fully complete, but it’s a lot further down the line than before.
Cheers,
Norm.—
Norman Dunbar
Dunbar IT Consultants Ltd
Thank you Norman, for the excellent work!
Updated Jaybird – JDBC driver Roadmap
Mark Rotteveel wrote on Firebird-Java group : I updated the Jaybird roadmap to outline the basic plans for Jaybird
2.3. You can find it on
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=info:roadmap
I will probably add more detail in the future.
Mark
The Firebird Book (Second Edition) released : printed and ebooks
The Firebird Book (Second Edition) is now available as a print on demand book (at createspace) in three parts,
Volume 1: Firebird Fundamentals
https://www.createspace.com/4203352
Volume 2: Developing with Firebird Data
https://www.createspace.com/4206843
Volume 3: Administering Firebird Servers and Databases
https://www.createspace.com/4206991
Also and also in electronic format (e-book) on the Developer DVD or as an immediate download. It covers Firebird upto Firebird V2.5.x.
Anybody purchasing the DVD gets a download link immediately,
and the DVD is sent later as a backup hard copy, along with a lot of other useful stuff.
YiiFirebird 1.0 is marked as stable we need more volunteers for writing and doing tests
It seems that now the YiiFirebird extension is stable enough (please let me know it is not so) for merge in YiiFramework master repo.
Now, the next step is to create the automated tests for this extension. Volunteers? Ideas?
We need to add a “tests” directory for that purpose in our local repo before committing Yii master repo.
Example: https://github.com/yiisoft/yii/blob/master/tests/framework/db/schema/CPostgresTest.php
Comment on this issue
Custom conventions in Entity Framework 6 helping Firebird – part 2
Few days ago I wrote a post “Custom conventions in Entity Framework 6 helping Firebird“.Arthur Vickers from Entity Framework team had a good question whether it works also for columns and tables that are generated by Entity Framework (like join tables for M:N, FK columns (if not in model), etc.). And it actually does not. 
For this you have to dig a little bit deeper and use model-based convention.
New implementation for wire protocol in Jaybird and all drivers need a faster wire protocol
Mark Rotteveel wrote on twitter about the Jaybird improvement:
Writing a new implementation of the wire protocol in Jaybird. I fear it is going to cascade into a total rewrite of the driver
Jiri chatted later:
IMO the whole “communication layer” needs redesign. It’s (way) too legacy.
And later on the twitter channel Brent Rowland wrote:
Contemplating creating a new wire protocol. Stop me now…
I have a replication system for Firebird I need to extend across a WAN. Firebird has no built-in replication and the protocol is chatty.
Editor:All these conversations are around Firebird 2.5.x protocol , there is work conducted by Dmitry Yemanov on improving the Firebird 3.x protocol