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 Making ResultSet  object scrollable 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 "Making ResultSet  object scrollable" Watch "Making ResultSet  object scrollable" New topic

Making ResultSet object scrollable

sajeev varghese

Joined: Jan 27, 2006
Posts: 14
I am using getColumns method of databasemetadata which returns resultset.
This resultset returns information about each columns as seperate rows.I want to iterate through these rows.
please note that I am not using any preparedStatement or createstatement methods.
Please tell me how to make this resultset scrollable.
Thanks in advance.
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Here's a link to the JDBC tutorial:

Notice how that page contains the words "scrollable result set", so that should help you to find the information.

By the way I don't keep that link anywhere, when I want to find it I type "jdbc tutorial" into my favourite search engine and it pops up as the first result. You can go a long way with that technique.
I agree. Here's the link:
subject: Making ResultSet object scrollable
It's not a secret anymore!