Hello all, after all, SAP DB imposes some restrictions on whether updated values in the result set are visible or not:
a) Result sets, which are copied (a line with RESULT IS COPIED , COSTVALUE IS can be found in the last row of the output of the EXPLAIN statement of the SELECT that produces the result set as field STRATEGY) do not show changes. b) Result sets which are created with a SELECT statement having a FOR REUSE clause (created when the JDBC flags TYPE_SCROLL_INSENSITIVE is set) do not show changes. c) Whether or not an updated key field (insert/update/delete) does show up in a result set is not predictable for the user, as it depends on the place where the record having this key is inserted and whether this place has already been fetched. d) Updates of non-key fields are visible, if none of the previous cases does apply for the result set. Sorry for any incovenience Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Kolja Kleist [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 4:16 PM > To: Paskamp, Marco; [EMAIL PROTECTED] > Subject: AW: Updated JDBC Driver (was ftp file naming (general)) > > > Hello, > > the main problems seems to fixed, > but i have still the problem that my changes aren't visible in the > resultset. > It has no effect if I call refreshrow after insertRow()/updateRow(); > > The same behaviour i've got, if I select a result > (TYPE_SCROLL_SENSITIVE) > and update one row with another statement. > Calling refreshrow on the resultset created first has no effect. > The changes of the second statement arent't visible. > > Any comments? > Thank you, > Kolja > > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]Im Auftrag von Paskamp, > Marco > Gesendet: Freitag, 10. Januar 2003 14:52 > An: 'Andrius Vilciauskas'; [EMAIL PROTECTED] > Betreff: RE: Updated JDBC Driver (was ftp file naming (general)) > > > Hi, > because of a handling problem with our source control system, > some bugfixes > are not contained in the JDBC-driver released yesterday. > > An updated JDBC driver can be found at: > ftp://ftp.sap.com/pub/sapdb/bin/java/sapdb-jdbc-bin-7.4.04.00d.jar > > Now it should contain the missed bugfixes for updatable resultsets. > > Sorry, > Marco > > ---------------------------------------------- > Marco PASKAMP > SAP DB, SAP Labs Berlin > > > -----Original Message----- > > From: Andrius Vilciauskas [mailto:[EMAIL PROTECTED]] > > Sent: Freitag, 10. Januar 2003 07:16 > > To: [EMAIL PROTECTED] > > Subject: Re: Updated JDBC Driver (was ftp file naming (general)) > > > > > > Hello Alexander, > > > > You have left one submited bug in driver. > > ResultSet.moveToInsertRow() doesn't works with updatable > result sets. > > > > AVi > > > > > > > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
