Multitrheaded application and lock issues
Posted by: Jonathan Short
Date: April 28, 2005 12:34PM

I am having a problem maybe someone here could help with. I have a database utility class using mysql++. This class is used by several threads. The problem I am having is that a function for insert is being called at the same time as a function deleting a different row in the table and I get a LOCK FAILED error. I am using an InnoDB table so I was under the impression this would not be a problem because of row locking. is there a different way I have to execute the function?
mysqlpp::Query query = db.query();
query << "insert blah";
query.execute();

any help would be greatly appreciated

Options: ReplyQuote


Subject
Views
Written By
Posted
Multitrheaded application and lock issues
1050
April 28, 2005 12:34PM


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.