Mode: Embeded I was trying to generate sequence keys with my code, and I faced issue in row level locking
First, I locked my sequence keys holding table ( a table which says what is the next key for a specific table), with the "FOR UPDATE OF <column name>" keyword. Second, Then updating the table by incrementing the existing value, and getting the updated value. With print traces in my code I found that when a select query locks a particular row, and then before the next update, another connection is allowed to make a select on the query and get the same value. Am I missing anything here. -- View this message in context: http://www.nabble.com/Row-level-locking-tf3745257.html#a10550668 Sent from the Apache Derby Developers mailing list archive at Nabble.com.
