Multiple Concurrent connections: how to avoid locking?
Posted by: Henry Widd
Date: February 17, 2005 09:40AM

Hi, I am using the jdbc driver: org.gjt.mm.mysql.Driver and my tables are inno_db (but could change).

I need to be able to create multiple connections which can edit tables. At the moment, the connections appear to be locking the tables, which means other connections cannot update, insert data etc.

I understand the danger of this but my app is able to avoid problems relating to that.

All I need is to work out how to unlock tables - I have had no luck issuing an 'unlock tables' command.

The connections are created via connection pool and handed out as required etc

I am very grateful for any help.


thanks,

Henry Widd

Options: ReplyQuote


Subject
Written By
Posted
Multiple Concurrent connections: how to avoid locking?
February 17, 2005 09:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.