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?
posted 12 years ago
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.