Yes by session I mean TIB_Session.

Not quite sure what you mean by 'using localhost server' - DB is on a
separate Linux machine and uses protocol TCP/IP

Web Module dynamically creates it's own TIB_Session and
IB_Connection/IB_Transaction and destroys it when finished and each
thread the web module opens also dynamically creates it's own
TIB_Session and IB_Connection/IB_transaction and also destroys it.

Every table and query is also dynamically created and verified to be
using the correct IB_Connection and IB_Transaction.

Further after assuming that wrapping TIB_Session creates, table
prepares, table opens and now TIB_Session frees within a critical
section cures the problem - it does not. The operation is better and
load testing the application means we can have 500+connections(not
concurrently, in total) before freezing occurs. We are currently
investigating this.

Lindsay

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 04 December 2004 23:12
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IBObjects, Isapi dll and Threading


At 03:54 PM 4/12/2004 +0000, you wrote:

>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.

By "session", you do mean a TIB_Session, right?

And you *are* using the localhost server when the module's IB_Connection

connects to the database, right?

And you are making sure that the module's objects all point to the
correct
IB_Connection and IB_Transaction properties, right? (Don't use
<default>
for anything in isapi modules!!)

And, no, the transaction isolation should not have any effect on the
thread-safety of the module. The important thing is to totally isolate
the
whole kebab for each instance of the module and to destroy the instance
when it is finished with.

Helen





________________________________________________________________________
___
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