Hi,
I've got a problem with an app and its DB access under IB6.
In the application there are two Q's that process DB requests. Q1 processes
these requests via the mainthread, Q2 is in a separate thread. When the
app starts up each Q creates a connection to the DB ( I'm using IBX4.2 so
its a TIBDatabase ).
When a request is executed the Q passes it the DB ref. The request then
creates IBTransaction and IBSQL objects, sets up the transaction params,
and hooks them all together. The transaction is started and the SQL is
processed.
The transaction is then committed or rollbacked and the transaction is
removed from the DB.
Everything was working fine with IB5 but with IB6 starting a transaction
while there's an active transaction on the other Q causes the app to hang.
It never returns from the Transaction.StartTrransaction call.
The transaction parameters I'm using are 'nowait', 'rec_commited',
'rec_version' and depending on the type of request, 'read' or 'write'.
I've tried playing with these but with no luck.
Has anyone else had similar problems, or any ideas that might help?
Cheers
Delwin.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
