New hotfixes available for Delphi , C++Builder and RAD Studio XE
This fix corrects the error caused when reading an ftMemo field twice using the Firebird dbExpress driver.
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Odbc issues and fixes with OpenOffice/LibreOffice
Interesting issues and fixes with odbc and openoffice (usually you can use jdbc but that is another path to use firebird from OpenOffice/LibreOffice):
My name is Ocke Janssen, I’m the project lead of the dba.openoffice.org
project and I got a problem 😉
While trying to fetch bookmarks I crash inside the newest ODBC version
of Firebird.
Tip : How can i find size of table in firebird?
You get an approximate value by running gstat and then check out the
Data pages value for the table. Multiply that value with your database page size. This is the allocated space on disk.
Multiple Firebird servers in #Ubuntu #Linux
In this tutorial I will show you how to install multiple separate Firebird 2.1 servers on a single Host
Firebird internals : Asyncronous System Trap
What is Asyncronous System Trap ? : This is similar to Unixes signal’s or OS interrupts.
Technically this is callbacks from Lock Manager into the Engine called when
somebody acquires lock at level not compatible with current level. In this case
all processes who owns the lock receives notification and should take appropriate
action to release lock (immediately or deferred-ASAP).
The main trick with AST’s handlers is that AST is send asynchronously and
handler must take care to work correctly. Since v2.5 all ATS handlers runs in
separate thread. Before v2.5 it works using signals on Unixes and threads on
Windows.
PS the issue with old glibc and FB 2.5 is that since v2.5 we abandoned usage of old
System V semaphores (do you remember “semaphores are exhausted” error ? now
you can forget it completely) and start to use pthread mutexes. And old glibc have a
bugs in pthread mutex implementation.
Extracting glibc info in #Linux to see if is greater or equal with 2.7
Related to previous announcement:If you are on ubuntu and your ubuntu release is greater than Hardy (8.04) you are safe , on other distributions you can determine this way the glibc version
You must run the /lib/libc.so.6 and it will return the glibc version
in the first row.
In ubuntu or any debian based distro
/lib/libc.so.6 | head -n 1
GNU C Library (Ubuntu EGLIBC 2.13-0ubuntu1) stable release version
2.13, by Roland McGrath et al.
in this case glibc is 2.13
and is builded from eglibc sources
https://launchpad.net/ubuntu/+source/eglibc
another option is dpkg interrogation
dpkg -l libc6
on rpm based distros
rpm -q glibc
ps: other alternative ways
#Java Web-based Squirrel SQL client
Web-based Squirrel SQL client. It allows you to view database structure, import/export and manage your databases, including create database, table, store procedure, view,trigger and user. it supports Firebird
Firebird usage with SchemaSpy – Java based Graphical Database Schema Metadata Browser
On devshed firebird forum someone asked if anyone used SchemaSpy with firebird , and later he got it working , here is the command line option (after installing jaybird.jar)
1) Download the ZIP file for jaybird
2) unzip it
3) Copy the file jaybird-full-2.1.6.jar into a convenient directory
4) specify the full path to the .jar file when starting schema spy
java -jar /home/java/schemaSpy_5.0.0.jar -t firebird -db /var/lib/firebird/2.1/data/employee.fdb -s schema -u SYSDBA -p ******* -o /home/firebird/ -port 3050 -host localhost -dp /home/user/jaybird-full-2.1.6.jar
ps:that is a single line
Firebird used in AVG Internet Security Business Edition 2011
here is the mention.
Istallation proved very easy, and intelligently chosen defaults allowed us simply to press ‘Next’ through most of the wizard. A Firebird database is provided
Firebird 2.5.1 Snapshot is now in #Debian experimental
For people who want to live on the edge , there is a new upload in experimental for 2.5 release branch
