This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes CachedRowSet - still early access? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
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.
subject: CachedRowSet - still early access?