we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.
i would like to switch to use app driver, while using jdbc, i can't
get pessimistic row lock, here is the way i try, table have index on
column id and it is unique value for each row.
stm =
conn.createStatement(
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
sqlStr = "select id, brnum, ITMNUM, DESC from DDAI.JTLD0011 where
id = 28 ";
but i only get table IS lock, so how can i get row U lock, please
help. thanks