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 resultsets 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 resultsets" Watch "scrollable resultsets" New topic

scrollable resultsets

sushant prabhu
Ranch Hand

Joined: Mar 22, 2001
Posts: 66
i want to know whether scrollable resultsets r database dependent.
i hav heard that scrollable resultsets do not work in oracle.
can somebody redirect me to site which can giv me an example of resultset

Sushant Prabhu<br />SCJP2<br />SCWCD<br />OCA9i
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
It all depends on the DB driver you have installed. You should be able to scroll in both directions if you are using the JDBC 2.0 driver.

So much trouble in the world -- Bob Marley
sushant prabhu
Ranch Hand

Joined: Mar 22, 2001
Posts: 66
Thanks bosun
But can u tell me does is thin and oci8 driver a jdbc2.0 driver
I agree. Here's the link:
subject: scrollable resultsets
It's not a secret anymore!