I am using JDBC connection to get the resultset. I am using same JDBC connection to update some records of same table. It is working. My question is: Should I lock the connection when I do update or resultset.next() If not, will resultset.next() give me correct data or there can be potential problem