Subject | concurrency locking and IBO-defaults |
---|---|
Author | L.M. Bemmelmans |
Post date | 2003-07-21T13:45:03Z |
Hi,
IBO defaults to itCommitted, and has the following default behaviour:
After a select a transaction starts. It will only commit after a selected
period of time
After updating records IBO generates a COMMIT RETAINING and leaves
committing the transaction to the timer.
This works fine, but if I want to protect users better from changing
eachother records I can go to itConcurrency transactions.
So in that case, what do I have to do to merge as easy as possible into IBO
default behaviour ?
1.just perform a hard "commit" after each select statement in code.
this means: just depend further on the "commit retaining" after post
behaviour and the timer who really commits every n minutes ( IBobjects
behaviour ) ?
2.perform a "commit retaining" after each select statement and leave
everything else to IBobjects ?
Leon
IBO defaults to itCommitted, and has the following default behaviour:
After a select a transaction starts. It will only commit after a selected
period of time
After updating records IBO generates a COMMIT RETAINING and leaves
committing the transaction to the timer.
This works fine, but if I want to protect users better from changing
eachother records I can go to itConcurrency transactions.
So in that case, what do I have to do to merge as easy as possible into IBO
default behaviour ?
1.just perform a hard "commit" after each select statement in code.
this means: just depend further on the "commit retaining" after post
behaviour and the timer who really commits every n minutes ( IBobjects
behaviour ) ?
2.perform a "commit retaining" after each select statement and leave
everything else to IBobjects ?
Leon