Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CachedRowSet

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Pie
Posts: 64824
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by steve souza:
I don't think the CachedRowSet allows random access.

What about the absolute(int row) method?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic