I have tried the following piece of code to view the resultSet in an Access database.
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet res = stmt.executeQuery("select * from tableName);
//code to change one columd in the table....
res.UpdateString(/*column name*/);
res.updateRow();
The resultSet gets updated but it also displays the changes made to the database from another transaction. When i use TYPE_SROLL_INSENSITIVE and CONCUR_READ_ONLY, it works fine and does not display any changes.What am i doing wrong?
Thanks
Divya
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet res = stmt.executeQuery("select * from tableName);
//code to change one columd in the table....
res.UpdateString(/*column name*/);
res.updateRow();
The resultSet gets updated but it also displays the changes made to the database from another transaction. When i use TYPE_SROLL_INSENSITIVE and CONCUR_READ_ONLY, it works fine and does not display any changes.What am i doing wrong?
Thanks
Divya