Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: missing clarity on select for update when using with jdbc


Advanced Search

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.
http://yaragalla.blogspot.in/

Options: ReplyQuote


Subject Written By Posted
missing clarity on select for update when using with jdbc Muralidhar yaragalla 11/21/2013 01:50AM
Re: missing clarity on select for update when using with jdbc Todd Farmer 11/21/2013 10:22AM
Re: missing clarity on select for update when using with jdbc Muralidhar yaragalla 11/21/2013 12:48PM
Re: missing clarity on select for update when using with jdbc Mark Matthews 11/21/2013 08:31PM
Re: missing clarity on select for update when using with jdbc Muralidhar yaragalla 11/22/2013 02:14AM


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.