hi, we are using db2 udb v8.1 on windows with fp3. type 4 driver.
our program use this way to create a row lock
Statement stm = conn.createStatement(
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
sqlStr = "select id, brnum, ITMNUM, DESC from xx.xx where id = 34 ";
(there is regular type index on id column)
resultset = stm.executeQuery(sqlStr);
after this, there is Row(U) and table(IX) lock. i have another session
try to grab the same record (same kind of statement created and sql
string), intead of giving me error code 911, it gives me error code
99999 stating fetch exception occured. but why not the error code
911?(lock timeout)