File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes CachedRowSet - still early access? 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 - still early access?" Watch "CachedRowSet - still early access?" New topic

CachedRowSet - still early access?

Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
I'm considering using CachedRowSet so that I can free up my database connections more quickly, but I have a few concerns.
* Is it still early access?? If so, it's been EA for several years now, which gives me a bit of pause.
* Any usage stories on performance? How does it it populate from a resultSet, and is that an efficient operation?
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
More on CachedRowSet:
I've discovered the following interesting behavior. . . If I populate my cachedRowSet from a ResultSet, and then do a getString(columnName), that columnName cannot be prepended by a tableName.. For example, I have a query that says "SELECT demo.o1, demo.o2 from demo where demo.o1 = 0". If I use a straight resultSet, I can query for getString("demo.o1"). If I use a CachedRowSet, I cannot query for "demo.o1", only "o1". This is problematic for me, as my database repeats column names across tables. A potential workaround would be to get my results by column id, rather than column name.
Stats: I'm using Sun's rowset.jar (version 1.0 ea 4) and Connect/J's JDBC driver (version 3.0.6).
Interested in hearing if other folks have worked with CachedRowSet and whether they've run into similar problems.
I agree. Here's the link:
subject: CachedRowSet - still early access?
It's not a secret anymore!