File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes scrollable ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "scrollable ResultSet " Watch "scrollable ResultSet " New topic

scrollable ResultSet

anirudh kumar

Joined: Dec 08, 2001
Posts: 1
I want to scroll the Record with rs.prevoius()so what can i do for this below in this code a sql "UnsupportedOpertationException" genreted in runtime

[ Edited by Dave to format code and remove the ]
[This message has been edited by David O'Meara (edited December 10, 2001).]
Shiva Kumar
Ranch Hand

Joined: Feb 09, 2001
Posts: 30
May be the problem is in your JDBC Driver or in the DataBase. what DataBase you are using? Oracle, Access, MySQL are supporting this type of scrollable ResultSet with the Support of JDB driver, Please check your JDBC driver version or download the JDBC Driver(2.0 or 3.0) from the NET and update it.
I worked with Access, MySQL and Oracle with JDBC driver 3.0, the scrollable ResultSet worked fine.
I agree. Here's the link:
subject: scrollable ResultSet
It's not a secret anymore!