Subject | Transaction question |
---|---|
Author | Nico Callewaert |
Post date | 2001-03-23T07:49:13Z |
Hi all,
I have a little question : I have 2 TIB_Transactions :
Transactio A : to write data to the database (ReadOnly = False)
Transaction B : for reading data (to generate reports) (ReadOnly = True)
Let's say user A is updating a record, so the query is connected to
Transaction A. While user A is updating the record, user B is generating a
report (that will use that record), so that query is connected to
Transaction B.
My question now is, could a DEADLOCK appear in such a situation, when a user
is only READING information from a readonly transaction ?
Thanks,
Nico Callewaert
ncw@...
nico.callewaert@...
I have a little question : I have 2 TIB_Transactions :
Transactio A : to write data to the database (ReadOnly = False)
Transaction B : for reading data (to generate reports) (ReadOnly = True)
Let's say user A is updating a record, so the query is connected to
Transaction A. While user A is updating the record, user B is generating a
report (that will use that record), so that query is connected to
Transaction B.
My question now is, could a DEADLOCK appear in such a situation, when a user
is only READING information from a readonly transaction ?
Thanks,
Nico Callewaert
ncw@...
nico.callewaert@...