jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes CachedRowSet 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 "CachedRowSet" Watch "CachedRowSet" New topic


Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Can we go directly to the ith row and jth column of the CachedRowSet Object with out rotating it in while loop.Is it possible to do so ? If yes kindly send me some hint how to do it .Thnx
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

1) This is a JDBC question, not a servlet question. It will be moved to the JDBC forum

2) your display name needs to be changed to something conforming to the naming convention in use at Javaranch. Names
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63865

Welcome to the Ranch iitm079!
You'll find this forum a great place to seek help on JDBC, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
JDBC Forum Bartender

[Asking smart questions] [About Bear] [Books by Bear]
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 862
I don't think the CachedRowSet allows random access. I have a class in the FormattedDataSet API that converts a ResultSet into a Object[][] arrays. Arrays have random access. Another advantage of using this approach is that my code handles all jdbc calls such as opening and closing Connections, Statements, and ResultSets.
Steve - http://www.fdsapi.com

All FormattedDataSet code is performance monitored with JAMon, so if there is a bottleneck you will know it.
Check out http://www.fdsapi.com for more info.

http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 862
Thought you guys in the jdbc forum would be interested in this. I have just added a live demo page that allows you to type in a query and have the results returned as an HTML table with Sortable/clickable column headers. You can just hit submit when the default query comes up or you can enter your own query.
The demo is at http://www.ssouza.com/fdsapi/sortdemo.jsp
steve - http://www.fdsapi.com - the easiest way to generate dynamic xml and html.
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Originally posted by steve souza:
I don't think the CachedRowSet allows random access.

What about the absolute(int row) method?

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link: http://aspose.com/file-tools
subject: CachedRowSet
It's not a secret anymore!