You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Xanana Gusmao <gm...@spamgourmet.com> on 2006/11/27 08:12:47 UTC

SQL command to view active locks

Hi,

Is there a SQL command to display the lists of active locks in a Derby database
running in embedded mode ? For example, you can easily write scripts to do the
same in Oracle.

See http://www.dba-oracle.com/t_locked_rows_user_locks.htm

Thanks

Xanana

Re: SQL command to view active locks

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> I tried doing what you said, but the table does not seem to exist.
> I am running 10.1.1.0 via the NetworkServerControl API.

In version 10.1, you have to use the old name for the table. Try:

   SELECT * FROM NEW org.apache.derby.diag.LockTable() as LOCK_TABLE

See DERBY-571 for more info: http://issues.apache.org/jira/browse/DERBY-571

thanks,

bryan

Re: SQL command to view active locks

Posted by Xanana Gusmao <gm...@spamgourmet.com>.

Oystein,

I tried doing what you said, but the table does not seem to exist.
I am running 10.1.1.0 via the NetworkServerControl API.

ij> select * from SYSCS_DIAG.LOCK_TABLE;
ERROR 42X05: Table 'SYSCS_DIAG.LOCK_TABLE' does not exist.

Do I need to configure anything ? Thanks.

Xanana

Re: SQL command to view active locks

Posted by Oystein Grovlen - Sun Norway <Oy...@Sun.COM>.

Xanana Gusmao wrote:
> Hi,
> 
> Is there a SQL command to display the lists of active locks in a Derby database
> running in embedded mode ? For example, you can easily write scripts to do the
> same in Oracle.

select * from SYSCS_DIAG.LOCK_TABLE

-- 
Øystein