MySQL Forums
Forum List  »  Connector/JDBC and Java

missing clarity on select for update when using with jdbc
Posted by: Muralidhar yaragalla
Date: November 21, 2013 01:50AM

Hi i think jdbc calls maintain separate session for each call. So if i do a "select with lock in share mode". The jdbc session ends after returning the data to me but this select is intended to maintain write lock on the selected data. So when does this lock gets released?

does it get released when there is another call with jdbc to the server for committing the data what i got earlier with the select?

as these are happening in two different sessions how does the database server knows that this is the data that was selected in prior session using select in shared lock?

Thanks and Regards,
Muralidhar Yaragalla.

Options: ReplyQuote

Written By
missing clarity on select for update when using with jdbc
November 21, 2013 01:50AM

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.