Hi.
After calling insertRow() on a resultset, the modifications are not
reflected until the query is invoked again.
For example, in the following sequence of commands the inserted data
is not reported:
ResultSet rs = stmt.executeQuery("select * from user");
rs.moveToInsertRow();
rs.updateString("logName", "newuser");
rs.updateString("password", "newpass");
rs.insertRow();
rs.first();
while (rs.next()) { // Loop through the
result set
System.out.println (rs.getString("logName")+":"+
rs.getString
("password"));
}
Is this normal behaviour in H2 or am I doing something wrong ?
Regards
- Aritemo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---