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: 19742

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
jQuery in Action, 3rd edition