Subject Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
I'm using Firebird 2.1.6. Also I tried to upgrade to latest jaybird before but it does not work properly with JBoss 4.2.3. I remember something has changed and as soon as I try to start apps server and run client, exceptions were starting to popup in the log.

This code path uses long running transaction only if for some reason the history for a cash box is lost and has to be rebuild day by day. This is not the case in the moment.

usually the execution of this operation have to take not more then just a second or a little more when more then 5-6 cash boxes has to be recalculated.