Hi, forward only means you step thru the resultset using the next()-method. This is also true for scrollable resultset. So I think using scrollable resultsets instead of forward only resultset as default fullfill also the specification. Forward only resultsets in SAP DB are not faster than scrollable resultsets, because forward only is handled by the JDBC-driver (throwing some exceptions) and uses the same kernel communication as scrollable resultsets.
There are no plans to change the default resultset type and I don't see any advantage of using forward only resultset as default for SAP DB. Regards, Marco Paskamp > -----Original Message----- > From: Sven Köhler [mailto:[EMAIL PROTECTED]] > Sent: Samstag, 25. Januar 2003 19:28 > To: [EMAIL PROTECTED] > Subject: [BUG, JDBC] default mode is bot forward-only > > > Hi, > > as > http://java.sun.com/j2se/1.4.1/docs/api/java/sql/Connection.ht > ml#prepareStatement(java.lang.String) > states, ResultSets returned by a Statement created with this method > should be TYPE_FORWARD_ONLY. > I verified in the JDBC-driver's source, that they are > TYPE_SCROLL_SENSITIVE. > > BTW: > what is faster? > TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE ? > > > _______________________________________________ > 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
