Multitrheaded application and lock issues
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
Subject
Views
Written By
Posted
Multitrheaded application and lock issues
1050
April 28, 2005 12:34PM
711
April 29, 2005 06:37AM
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.