String strSql="SELECT * FROM QUOTEHEADER WHERE RKEY=5 FOR UPDATE NOWAIT";
con.setAutoCommit(false);
smt=con.prepareStatement(strSql);
ResultSet rs=smt.executeQuery();
.....
if(con !=null){
try{con.close();} catch(SQLException e){;}
con=null;
}//end if