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.OK, but it's explicitly stated in the docs. So it's some kind of unexpected behaviour but doesn't breaks compatibility. It's still a false bahaviour according to the docs/specs.
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.So the SAPDB's kernel doesn't include support for forard-only result-sets? That's strange, because Forward-Only ResultSets could be handled differently and more efficiently by the kernel.
Even if it doesn't make a difference at the moment, it might make one for future versions of SAPDB if the kernel-support for forward-only statement would come in let's say version 8.0.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
