Re: How to unlock a table in derby

2011-07-18 Thread Lahiru Gunathilake 
I will try it, thank you Byan !

Lahiru

On Fri, Jul 15, 2011 at 8:47 PM, Bryan Pendleton bpendleton.de...@gmail.com
 wrote:

  I execute query lock table table name
 in share mode but I cannot see any documentation on how to unlock a derby
 table.


 Commit.

 thanks,

 bryan

Re: How to unlock a table in derby

2011-07-18 Thread Peter Ondruška 
Rollback might work as well :)
Dne 18.7.2011 15:57 Lahiru Gunathilake glah...@gmail.com napsal(a):
 I will try it, thank you Byan !

 Lahiru

 On Fri, Jul 15, 2011 at 8:47 PM, Bryan Pendleton 
bpendleton.de...@gmail.com
 wrote:

 I execute query lock table table name
 in share mode but I cannot see any documentation on how to unlock a
derby
 table.


 Commit.

 thanks,

 bryan

Re: How to unlock a table in derby

2011-07-18 Thread Lahiru Gunathilake 
Hi Byan,

I am creating the connection with autoCommit=true parameter, does this work
with derby or should I explicitly commit the transaction?


Lahiru

On Mon, Jul 18, 2011 at 9:58 AM, Peter Ondruška 
peter.ondruska+de...@kaibo.eu wrote:

 Rollback might work as well :)
 Dne 18.7.2011 15:57 Lahiru Gunathilake glah...@gmail.com napsal(a):

  I will try it, thank you Byan !
 
  Lahiru
 
  On Fri, Jul 15, 2011 at 8:47 PM, Bryan Pendleton 
 bpendleton.de...@gmail.com
  wrote:
 
  I execute query lock table table name
  in share mode but I cannot see any documentation on how to unlock a
 derby
  table.
 
 
  Commit.
 
  thanks,
 
  bryan

Re: How to unlock a table in derby

2011-07-18 Thread Bryan Pendleton 

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

How to unlock a table in derby

2011-07-15 Thread Lahiru Gunathilake 
Hi Devs,

I am using derby as embedded database in my system and I want to lock a
table for that I execute query lock table table name in share mode but I
cannot see any documentation on how to unlock a derby table.

Please provide some information on how to handle a scenario like this with
embedded derby.

Thanks in advance
Lahiru

Re: How to unlock a table in derby

2011-07-15 Thread Bryan Pendleton 

 I execute query lock table table name
in share mode but I cannot see any documentation on how to unlock a derby 
table.


Commit.

thanks,

bryan