On 07/18/2011 07:16 AM, Lahiru Gunathilake wrote:
Hi Byan,I am creating the connection with autoCommit=true parameter, does this work with derby or should I explicitly commit the transaction? Lahiru
I believe if you do this, the system will automatically insert a 'commit' immediately after your 'lock table' statement, thus releasing the lock immediately and making the lock not very useful. When I use 'lock table', I always do it with autocommit=false. thanks, bryan
