db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: How to unlock a table in derby
Date Mon, 18 Jul 2011 14:45:30 GMT
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

Mime
View raw message