Subject Re: Help with Multi-threaded application on Localhost
Author marcel_nic <>
--- In, Helen Borrie <helebor@t...> wrote:
> At 10:07 AM 25/02/2003 +0000, you wrote:
> >--- In, Helen Borrie <helebor@t...>
> > > At 10:37 PM 24/02/2003 -0500, you wrote:
> > > >Helen,
> > > >
> >Hi all,
> >
> >I work on a 3-tier application and I have a very similar problems.
> >client-server use Indy objects and the sever application maintain
> >individual thread for every client connected to it. In each thread
> >new connection to Firebird database is created(I use dbexpres but I
> >also try with IBO). Unfortunately when two clients request try to
> >acces the database at the same time, the application freezes( and
> >also firebird server). I read in some material that GDS32.DLL is
> >thread safe, so I asume this is the problem and sincronize all
> >database calls. Now it works but I'm not satisfied with that
> >solution.
> Are you saying that you have this problem with a TCP local loopback
> connection? (localhost as server?)
Yes. Server application reside on the same computer with Firebird
server, and it manage all requests from clients. This is the only
application witch acces the database.
> The problem you describe is "as designed" for the local
> is not capable of being thread-safe as a local client.
Can I do something to avoid this?
Thanks! Marcel
> heLen