MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Can't update table XXX in stored function/trigger because it is already used
Posted by: Michael Gardner
Date: August 07, 2014 11:25AM

Hi Phil,

Actually, concurrency is being handled in our restful service and on the client. I posted this query because we were having issues with the RowVersion (Timestamp) column in our ORM. I was thinking that we could simply use a counter in the database and update it whenever the row is updated or set it to 1 when a row is inserted. After a good night's sleep, I realized why the above code is not working... We are looking into another solution path in the application.

Thank you for your time and comments.

Mike

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Can't update table XXX in stored function/trigger because it is already used
Michael Gardner
August 06, 2014 05:24PM
Re: Can't update table XXX in stored function/trigger because it is already used
Phillip Ward
August 07, 2014 04:54AM
Re: Can't update table XXX in stored function/trigger because it is already used
Michael Gardner
August 07, 2014 11:25AM


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.