Hi, Sorry, this feature is not implemented in H2. Own updates are detected, however own inserts and deletes are not. This is quite tricky to implement. I suggest to re-run the query instead.
Regards, Thomas On Sat, Sep 5, 2009 at 9:54 AM, aritemo <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
