Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

Posted by: marius adrian popa <mapopa <at> gmail.com>


Jaybird 2.2.10 released

I have just released Jaybird 2.2.10.

The release can be downloaded from
http://www.firebirdsql.org/en/jdbc-driver/ or

The release is also available on maven(*):


* The artifactId depends on your target Java version: jaybird-jdk18,
jaybird-jdk17, or jaybird-jdk16.

The following has been changed or fixed since Jaybird 2.2.9:

* Improvement: Transmit encrypted password (isc_dpb_password_enc and 
isc_spb_password_enc) in pure java protocol (JDBC-406)
* Improvement: Specify isc_tpb_lock_timeout in transaction mapping 
* Fixed: DatabaseMetaData.supportsGetGeneratedKeys does not report real 
availability of generated keys feature (JDBC-412)
* Fixed: FBCachedClob throws SQLException instead of 
SQLFeatureNotSupportedException (JDBC-414)
* Fixed: Transaction mapping cannot be configured through JDBC URL 
* Fixed: FBSQLWarning.getMessage() could return null instead of message 

More information will be available in the release notes
(as soon as I can upload them).

Kind regards,
Mark Rotteveel

Mark Rotteveel

Posted by: Mark Rotteveel <mark <at> lawinegevaar.nl>


Re: Firebird Language Reference 2.5 (English) Beta 1 (pdf) and (html).

I tried to post some comments and suggestions to the newsgroup 
gmane.comp.db.firebird.documentation yesterday.
I cannot see the post (using Mozilla Thunderbird) - is it held in 
quarantine, disposed of, rejected, or something else?
The latest posts I can see in the newsgroup are dated 02.02.2016.


Aage J.

Posted by: Aage Johansen <aagjohan <at> online.no>


New contender on Linux

Hi All,

What is your opinion from Firebird POV?






Firebird 3.0 RC2 packages for CentOS 7

First version of Centos7, RHEL7 Firebird 3.0 RC2 packages are here :

I hope that it will help to have more testing before final release.

Posted by: Philippe Makowski <pmakowski <at> ibphoenix.fr>


Unable to connect to Firebird on Linux guest in VirtualBox.

Hello guys,

After many, many, many hours of trying I've decided to seek for help:)  My situation is like this:

I have host machine - Windows 7 and I have guest machine Ubuntu 15.10 installed on VirtualBox. Thanks to the help on this forum, I've managed to install Firebird on Ubuntu and connect to it.

Now I want to connect to Firebird from my host machine. To do this, I've tried two connection methods: NAT and Bridge (chosen from VB Settings). Bridge is not working for me at all (I can't establish connection between machines). So I am trying the NAT, and as far as I understand I need to make a port forwarding.
So I've made such forwarding:
Protocol: TCP, Host IP:, Host Port: 9999, Guest IP Guest Port: 3050.

I am able to ping my host machine from guest. I am trying to connect via FlameRobin from my host machine like this: SYSDBA <at> and I am getting error: "unable to complete network request to host """

Could somone help me on this?

Thank you.

Posted by: un_spoken <at> yahoo.co.uk


What’s new with Pi 3

What’s new with Pi 3? Onboard WiFi/Bluetooth, a new 64-bit quadcore processor, and 50% more processing power.


Posted by: mapopa <at> gmail.com

Community email addresses:
  Post message: Firebird-general <at> yahoogroups.com
  Subscribe:    Firebird-general-subscribe <at> yahoogroups.com
  Unsubscribe:  Firebird-general-unsubscribe <at> yahoogroups.com
  List owner:   Firebird-general-owner <at> yahoogroups.com

Shortcut URL to this page:


Fw: [firebird-support] Problem installing ODBC driver on CentOS 7 linux

Hello all!

Please somebody help me with installing ODBC driver on CcentOS linux. I need it to make Sphinx work.

I followed Marius Popa's instructions, from FB main site: http://www.firebirdnews.org/howto-install-firebird-odbc-driver-for-unixodbc-from-source/

First i installed firebird-superserver, gcc-c++ and unixodbc packets...no problem here.

But when compiling the ODBC driver i get this error:

[root <at> pali2 Gcc.lin]# make -f makefile.linux
../makefile.environ:6: ARCH is x86_64
../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64
../makefile.environ:50: FBINCDIR is /usr/lib64/firebird/include
../makefile.environ:56: FBLIBDIR is /usr/lib64/firebird/lib
mkdir: cannot create directory ‘Release_x86_64’: File exists
make: [createdirs] Error 1 (ignored)
mkdir: cannot create directory ‘Release_x86_64/obj’: File exists
make: [createdirs] Error 1 (ignored)
g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/lib64/firebird/include -I/include -I/usr/lib64/firebird/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/Attachment.cpp -o Release_x86_64/obj/Attachment.o
In file included from ../../IscDbc/Attachment.cpp:35:0:
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory
 #include <ibase.h>
compilation terminated.
make: *** [Release_x86_64/obj/Attachment.o] Error 1

Then i tried another way:

I downloaded the ready-to-run version ODBC driver, from FB main site:
November 26, 2014 OdbcFb-LIB-
1.0 MB
Linux x86 Library

I unzipped and copied it to /usr/lib/firebird/libOdbcFb.so

I also made 2 another copies because the provided odbc config referred to libOdbcJdbc.so and libOdbcJdbcS.so files, and i had none of them. I guess the compiler should create them.

(Note: First i tried with symlinks, but not working i created real copies. But also not working.)

Here are odbc configs:

[root <at> pali2 Gcc.lin]# cat /etc/odbcinst.ini

Description = Firebird ODBC Driver
Driver = /usr/lib/firebird/libOdbcFb.so
Setup = /usr/lib/firebird/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

[root <at> pali2 Gcc.lin]# cat /etc/odbc.ini
Description = Firebird
Driver = Firebird
Dbname = localhost:/data/sample.fdb
Password = masterkey
Role =
CharacterSet = UTF8
ReadOnly = No
NoWait = No

When trying to connect i get this error:

[root <at> pali2 Gcc.lin]# isql -v sample
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/firebird/libOdbcJdbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

The /usr/lib/firebird/libOdbcJdbc.so file DOES EXIST.
On a forum i read that someone had the same issue and installing libstdc++ solved the problem.
But i had it installed before:

[root <at> pali2 Gcc.lin]# rpm -qa | grep libstdc++

Here is my system's architecture:

[root <at> pali2 Gcc.lin]# uname -a
Linux pali2 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

Please help me!

Thank you,

#yiv9807799491 -- #yiv9807799491ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv9807799491 #yiv9807799491ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv9807799491 #yiv9807799491ygrp-mkp #yiv9807799491hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv9807799491 #yiv9807799491ygrp-mkp #yiv9807799491ads { margin-bottom:10px;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad { padding:0 0;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad p { margin:0;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad a { color:#0000ff;text-decoration:none;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc { font-family:Arial;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc #yiv9807799491hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc .yiv9807799491ad { margin-bottom:10px;padding:0 0;} #yiv9807799491 #yiv9807799491actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv9807799491 #yiv9807799491activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv9807799491 #yiv9807799491activity span { font-weight:700;} #yiv9807799491 #yiv9807799491activity span:first-child { text-transform:uppercase;} #yiv9807799491 #yiv9807799491activity span a { color:#5085b6;text-decoration:none;} #yiv9807799491 #yiv9807799491activity span span { color:#ff7900;} #yiv9807799491 #yiv9807799491activity span .yiv9807799491underline { text-decoration:underline;} #yiv9807799491 .yiv9807799491attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv9807799491 .yiv9807799491attach div a { text-decoration:none;} #yiv9807799491 .yiv9807799491attach img { border:none;padding-right:5px;} #yiv9807799491 .yiv9807799491attach label { display:block;margin-bottom:5px;} #yiv9807799491 .yiv9807799491attach label a { text-decoration:none;} #yiv9807799491 blockquote { margin:0 0 0 4px;} #yiv9807799491 .yiv9807799491bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv9807799491 .yiv9807799491bold a { text-decoration:none;} #yiv9807799491 dd.yiv9807799491last p a { font-family:Verdana;font-weight:700;} #yiv9807799491 dd.yiv9807799491last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv9807799491 dd.yiv9807799491last p span.yiv9807799491yshortcuts { margin-right:0;} #yiv9807799491 div.yiv9807799491attach-table div div a { text-decoration:none;} #yiv9807799491 div.yiv9807799491attach-table { width:400px;} #yiv9807799491 div.yiv9807799491file-title a, #yiv9807799491 div.yiv9807799491file-title a:active, #yiv9807799491 div.yiv9807799491file-title a:hover, #yiv9807799491 div.yiv9807799491file-title a:visited { text-decoration:none;} #yiv9807799491 div.yiv9807799491photo-title a, #yiv9807799491 div.yiv9807799491photo-title a:active, #yiv9807799491 div.yiv9807799491photo-title a:hover, #yiv9807799491 div.yiv9807799491photo-title a:visited { text-decoration:none;} #yiv9807799491 div#yiv9807799491ygrp-mlmsg #yiv9807799491ygrp-msg p a span.yiv9807799491yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv9807799491 .yiv9807799491green { color:#628c2a;} #yiv9807799491 .yiv9807799491MsoNormal { margin:0 0 0 0;} #yiv9807799491 o { font-size:0;} #yiv9807799491 #yiv9807799491photos div { float:left;width:72px;} #yiv9807799491 #yiv9807799491photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv9807799491 #yiv9807799491photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv9807799491 #yiv9807799491reco-category { font-size:77%;} #yiv9807799491 #yiv9807799491reco-desc { font-size:77%;} #yiv9807799491 .yiv9807799491replbq { margin:4px;} #yiv9807799491 #yiv9807799491ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv9807799491 #yiv9807799491ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv9807799491 #yiv9807799491ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv9807799491 #yiv9807799491ygrp-mlmsg select, #yiv9807799491 input, #yiv9807799491 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv9807799491 #yiv9807799491ygrp-mlmsg pre, #yiv9807799491 code { font:115% monospace;} #yiv9807799491 #yiv9807799491ygrp-mlmsg * { line-height:1.22em;} #yiv9807799491 #yiv9807799491ygrp-mlmsg #yiv9807799491logo { padding-bottom:10px;} #yiv9807799491 #yiv9807799491ygrp-msg p a { font-family:Verdana;} #yiv9807799491 #yiv9807799491ygrp-msg p#yiv9807799491attach-count span { color:#1E66AE;font-weight:700;} #yiv9807799491 #yiv9807799491ygrp-reco #yiv9807799491reco-head { color:#ff7900;font-weight:700;} #yiv9807799491 #yiv9807799491ygrp-reco { margin-bottom:20px;padding:0px;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov li a { font-size:130%;text-decoration:none;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov ul { margin:0;padding:0 0 0 8px;} #yiv9807799491 #yiv9807799491ygrp-text { font-family:Georgia;} #yiv9807799491 #yiv9807799491ygrp-text p { margin:0 0 1em 0;} #yiv9807799491 #yiv9807799491ygrp-text tt { font-size:120%;} #yiv9807799491 #yiv9807799491ygrp-vital ul li:last-child { border-right:none !important;} #yiv9807799491

Posted by: Nagy Szilveszter <nagy_szilveszter <at> yahoo.com>


Firebird Language Reference 2.5 (English) Beta 1 (pdf) and (html).

Firebird Language Reference 2.5 (English) Beta 1 (pdf) and (html). The review of the translated text has got this far, thanks to the efforts of Paul Vinkenoog and Mark Rotteveel. Unfortunately, we didn't get any more Englsh speakers to help with the review, so there is still a way to go. (Helen Borrie).

If you find any typos or mistak es, please report to firebird-docs


Posted by: mapopa <at> gmail.com


C++ Exception Handling

Dear all, (apologies if you receive multiple copies)

We are investigating the use of C++ exception handling constructs in well known open-source C++ systems, and have published some results in the last International Conference on Source Code Analysis and Manipulation [1] 

We are expanding this research to a broader community, so I kindly invite you to answer our new version of the survey at:



Rodrigo Bonifácio (on behalf of the authors of this research effort).

[1] "The use of C++ exception handling constructs: A comprehensive study"

Posted by: Rodrigo Bonifacio <rbonifacio123 <at> gmail.com>


Database Workbench 5.1.10 released

This release adds a few small features and includes Windows Terminal Server support.

Change log available for version 5.1.x.

Posted by: mapopa <at> gmail.com