Forums Register Login

CachedRowSet

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
 

Originally posted by steve souza:
I don't think the CachedRowSet allows random access.


What about the absolute(int row) method?
I will open the floodgates of his own worst nightmare! All in a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 2225 times.
Similar Threads
How do I use the CacheRowSet?
reading cachedRowSet
CachedRowSet is an abstract class
CachedRowSet: Can't find it
how to read few records at a time?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 17:50:27.