Jonck, sorry, there is currently no way to detect InnoDB locks, except by setting globally
innodb_lock_wait_timeout=1 in the [mysqld] section of my.cnf. Then your failing lock requests return with the error 'lock wait timeout'. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ............... Search Result 5 From: Jonck van der Kogel ([EMAIL PROTECTED]) Subject: Detecting locks (using connector/j) This is the only article in this thread View: Original Format Newsgroups: mailing.database.mysql Date: 2003-12-17 06:32:44 PST Hi everybody, I am having a hard time finding any info on this subject, so I was hoping maybe one of you could give me some pointers. I am writing an application in Java that uses Connector/J to interface with a MySQL database with InnoDB tables. When user #1 opens a certain recordset I am locking this recordset in share mode. Therefore if user #2 selects the same recordset (and thus placing a lock as well) user #1 will not be able to update the recordset. Is there a way to detect this, and thus making it possible to inform user #1 that an update is currently not possible due to another lock? Thanks very much for any help, Jonck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]