Subject RE: [ib-support] Firebird and threads
Author Bill Morrison
Obvious question, but does each of your threads have it's own connection to
the database?


-----Original Message-----
From: Brad Pepers [mailto:brad@...]
Sent: Friday, November 02, 2001 1:18 AM
Subject: Re: [ib-support] Firebird and threads

On November 1, 2001 04:34 pm, Helen Borrie wrote:
> At 04:04 PM 01-11-01 -0700, you wrote:
> >Is firebird thread safe? I'm trying to write an application that has a
> >thread for each client connection and each thread has its own connection
> > to the Firebird database. The code works fine when using the Sybase
> > database but when using Firebird, it dies and I suspect the Firebird
> > is not thread safe.
> It is not threadsafe on a local connection.

I'm connecting to localhost:/opt/quasar/company/sample.fdb so it should be
using the network and not the local connection.

> What is the development platform for your client application? How are
> clients connecting to the server?

Its Linux with Linux clients. Only 5 clients were connected and they were
fighting over 3 database connections. They complete a few thousand database

selects before the error is triggered. I'm using a version of Firebird from

many months ago so were there any changes along the way that would effects
threads on Linux? I'll try to find the RC1 source code for Linux and
that for testing next.

> If you are using Delphi or BCCB, what data access components are you
> versions,etc. ?

Its SQLAPI which I saw mentioned here and checked out. Works really nice
C++ access to Firebird now that the commit retaining problem is fixed! The
library allows me to switch databases at run time without changing code so
the exact same code was tested against Sybase and Firebird with only
showing the segfaults.

Brad Pepers

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to