Monday, January 6, 2003 11:22 AM
As I understand, the JDBC->ODBC bridge is not well supported by ODBC. Either ODBC cannot provide this function, or will not for the JDBC driver. In either case, I think you'll need to use a db-specific JDBC driver (type III or IV), which might require you to switch RDBMS vendors.
Otherwise, you'll have to find a solution that does not use scrollable result sets.
If you can't switch databases and require scrollability, there is an implementation of a scrollable result set on Sun's site which I (unfortunately) can't find right now.
If you were really desperate, you could simply read-in all the results into a List and do your own scrolling.