Subject | transaction monitor |
---|---|
Author | bemmel2003 |
Post date | 2003-03-06T12:13:49Z |
Hi,
I'm new to this newsgroup, and I'm testing transaction behaviour of
IBobjects now. I have a allways open dbgrid, NOT fetching all rows at
once, tiCommitted, autoCommit and a transaction component allowing to
perform a "real commit" every 120 seconds. So it's pretty much the
default behaviour of TIB_connection (but I contril this using
TIB_transaction). I also have a button which fires a "real commit"
When I look at TIBmonitor I have two different situations:
A. let TIB_transaction do the commit
---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 17339320
---
COMMIT
TR_HANDLE = 17339320
---
A. depressing the "commit key" a new transaction starts
---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 17339320
---
COMMIT
TR_HANDLE = 17339320
---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 17339320
---
Why the difference ?
What does TR_HANDLE tell me ?
Does this commit mean that my OAT will move forward like planned ?
Leon
I'm new to this newsgroup, and I'm testing transaction behaviour of
IBobjects now. I have a allways open dbgrid, NOT fetching all rows at
once, tiCommitted, autoCommit and a transaction component allowing to
perform a "real commit" every 120 seconds. So it's pretty much the
default behaviour of TIB_connection (but I contril this using
TIB_transaction). I also have a button which fires a "real commit"
When I look at TIBmonitor I have two different situations:
A. let TIB_transaction do the commit
---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 17339320
---
COMMIT
TR_HANDLE = 17339320
---
A. depressing the "commit key" a new transaction starts
---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 17339320
---
COMMIT
TR_HANDLE = 17339320
---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 17339320
---
Why the difference ?
What does TR_HANDLE tell me ?
Does this commit mean that my OAT will move forward like planned ?
Leon