Subject | lock conflicts with read-only and nowait options |
---|---|
Author | scharloi |
Post date | 2004-05-05T13:08:57Z |
Hello All,
I'm facing that problem :
My application start two threads that execute the same process :
- start a transaction
- execute a 'select' statement
- open a cursor
- count the number of lines in result.
- close the cursor
The two transactions act on the same database handle and the query in statements are identical.
transaction parameter buffer set to :
- isc_tpb_version3
- isc_tpb_read
- isc_tpb_nowait
My application seems to be in a dead lock or lock conflict case.
In every test, application is locked at different place.
(I'm using Firebird 1.5 RC9.)
What could be wrong with a such process ?
Can somebody help me ?
- Sebastien Charlois-
I'm facing that problem :
My application start two threads that execute the same process :
- start a transaction
- execute a 'select' statement
- open a cursor
- count the number of lines in result.
- close the cursor
The two transactions act on the same database handle and the query in statements are identical.
transaction parameter buffer set to :
- isc_tpb_version3
- isc_tpb_read
- isc_tpb_nowait
My application seems to be in a dead lock or lock conflict case.
In every test, application is locked at different place.
(I'm using Firebird 1.5 RC9.)
What could be wrong with a such process ?
Can somebody help me ?
- Sebastien Charlois-