Subject Re: [ib-support] Firebird and threads
Author Brad Pepers
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 code
> > 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 compile
that for testing next.

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

Its SQLAPI which I saw mentioned here and checked out. Works really nice for
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 Firebird
showing the segfaults.

Brad Pepers