This board has been very helpful in the passed, usually a good search and I find my answer, so this is my first post.
Is there a way to determine if (or a way to set) a scrollable cursor so that is locks the record if one is found as as a "Select for Update" statement.
Reading the JDBC API Tutorial and Reference (ResultSet chapter) it wasn't clear if ResultSet.CONCUR_UPDATABLE can be set to do a write-lock or if it is p to DB on how they want to implement the ResultSet. I am using Oracle 9.2.
I believe that the "Concepts Guide" will explain Oracle's locking mechanisms (and behaviour), while the "JDBC Developer's Guide and Reference" will tell you if you can create an updatable "ResultSet" using the "SELECT ... FOR UPDATE" statement.