Subject RE: [IBO] IBObjects, Isapi dll and Threading
Author lgauton
It's a WebBroker application, and the session and connection are created
dynamically within each thread - session first, then connection. We are
using TCP/ip. Changing the isolation mode in IIS make no difference.

Thanks


-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: 04 December 2004 14:52
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] IBObjects, Isapi dll and Threading


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)




________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Links







---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004