Mark Rottevee announced new snapshot of Jaybird driver :
I have just uploaded a new snapshot version for Jaybird 2.2.4 to
sourceforge and the sonatype snapshots repository for Maven.
Most notable changes are support for the Firebird 3.0 alpha 1 BOOLEAN
type and support for Java 8. For other changes see
This snapshot is intended only for testing purposes and has not been
tested with the native or embedded subprotocols.
Download area (Java 5, 6, 7 and 8):
Maven snapshot repository:
artifactId: jaybird-jdk1x (where x = 5, 6, 7 or 8)
If you have any problems, let me know in the Firebird-Java list. Bugs
can be reported in the tracker http://tracker.firebirdsql.org/browse/JDBC
If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:
- The necessity to add ALL parameters manually.
- Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.
- The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).
- The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).
- No execution of SQL scripts which contain several SQL expressions per command.
This list of difficulties a .NET developer has to deal with is far from complete.
Now it’s all different in a fundamentally new ADO.NET Data Provider for OLE DB
Pierre Y wrote on Firebird-devel list about the new Firebird 3.x api and he created a project for it
Now I started playing with the new API. I created a project on github for it :
Is the OO API complete ? I think very strange to still have to build
DPB by hand… Can you expose something that may give access to the
ClumpletWriter to ease that ?
Let us remind you that already 2 months ago we added support of BOOLEAN data type from Firebird 3. In the new version of IBProvider Professional, we added support of PACKAGE instruction.
Now you can put in order a bulk of database procedures and functions and group them by sense into individual modules (PACKAGE). This arrangement will substantially simplify understanding and maintenance of SQL code.
Ream more about Firebird 3 access improvements.
Firebird 3.0 Initial Review and Presentation http://www.slideshare.net/mindthebird/initial-review-of-firebird-3
In this presentation Dmitry Yemanov, lead architect of Firebird Project, introduces the key advantages of upcoming major release of Firebird 3.
Someone on support list asked about identity column in Firebird and how it can be managed easier and i remembered that identity is already supported firebird 3.0 so i fired up flamerobin and created a table with new identity column type similar to MSSQL “identity”, MySQL “auto_increment” or PostgreSQL “serial”
All worked as in documentation 🙂 inserting and selecting from the table no generators/triggers were needed to be created by hand
I have updated the guide and the repository for Ubuntu Maverick to include the Firebird 3.0 Pre Alpha
This is just the upload from debian experimental is and is really prea alpha (so it’s only intended for testers)
Please report any problems you may encounter. The packages should be installable right away (and automaticly remove any existing firebird2.x ones)