Subject RE: [IBO] ASTA, IBO and Transactions
Author Kevin Stanton
I would certainly change the iso to committed.


From: [] On Behalf
Of Roger Pullen
Sent: Wednesday, May 18, 2005 11:00 AM
Subject: [IBO] ASTA, IBO and Transactions

All - we have an IBO ASTA server app running that
is now generating deadlocks. We are experiencing
an increase in users over recent months (about 10 - 12 now)
and have noted the IBTransaction on the ASTA server
is set to Concurrency - having read up on all this and
(tried) to understand it I believe this may be not the best setting
- committed being possibly better.

This ASTA server connects to a FB1.5 db that also has a "conventional"
IBO app connected as well whose transaction isolation
is set to committed and does not (usually) show any problems.

Is this deduction correct - bearing in mind the transaction
has autocommit set to TRUE. Alternativly, of course, it
may be my client app part that is wobbling....


Roger Pullen

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


Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<> .

[Non-text portions of this message have been removed]