Subject Re: [IBO] IBObjects, Isapi dll and Threading
Author Daniel Rail
Hi,

At December 4, 2004, 09:43, lgautonxx wrote:

> Is IBOJECTS truely thread-safe

It's not IBO that is not thread-safe, but FB's client.

> We are using Delphi 7 and IBObjects 4.2 Ie, Firebird 1.5

> Just completed isapi dll using IBOBJECTS and multiple threads. During
> testing we experienced lots of freezing some with high processor load
> (locked at 100%) and others with low processor load, when many
> concurrent connections are started. Investigation of the problem
> indicates there is an issue with IBSession creation, table prepares
> and table opens. Occasionally we also experience access violations
> with gds32.dll. We've cured the freezing and gsd32.dll access
> violations by wrapping all calls to session creates, table prepares
> and table opens within the primary process and any threads that are
> started within a global critical section.

> Can anyone shed any light on what we are experiencing.

What are you using to create your ISAPI? WebSnap? Intraweb? Other?

Also, make sure that each thread has it's own connection and that the
TIB_Session component is created before TIB_Connection. You can check
the creation order of the non-visual components by right-clicking on
the webmodule(or datamodule) where those components are located.

And, make sure that you are using TCP/IP as the protocol to connect
to Firebird. Using cpLocal will cause lockups.

Also, have you tried chaning the isolation mode for ISAPIs in IIS?


--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)