Hi,
I have a java code that delete records from a table using ResultSet.DeleteRow() method:
Class.forName("com.hxtt.sql.access.AccessDriver");
String url = "jdbc:access:/C:/Dev/test.mdb";
Connection con = DriverManager.getConnection(url);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet r = stmt.executeQuery("SELECT * FROM Test");
while (r.next()) {
r.deleteRow();
}
r.close();
It seems like this code delete only 50% of records in a table (I had 10 records and only 5 were deleted). The same code works fine when I connect to DB2 database with IBM DB2 driver. Is there a way to delete all records from resultSet using deleteRow()?
Thanks,
Roman
|
ResultSet r = stmt.executeQuery("SELECT * FROM Test");
r.next();
while (!r.isAfterLast()) {
r.deleteRow();
}
r.close();
|