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. Thanks! bear JDBC Forum Bartender
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.
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.