"Ryan Cornia" <[EMAIL PROTECTED]> asks:
> Is anyone using the early access of CachedRowSet
> for data access, or are people just using straight
> JDBC calls?
>
> I've been using straight JDBC calls, but it looks
> like CachedRowSet would be easier. Anyone know when
> it will be officially released? Is it currently stable?
I use cached RowSets beacuse they hide the connections,
SQL and the whole persistence stuff from the JSP which
uses them.
I only had problems with some Oracle specialities (nested
ResultSets will not be serialized by the EarlyAccess
version).
Other option would be to use the Rowset which opens a life
connection to the datasource. The Action would set up its
properties and the RowSet would fetsch the data when needed
in the JSP. The JSP has then to be responsible for closing
teh RowSet (I always call rs.close() in the JSP, even though
for the cached ones it is not necessary and it means I have
to have scriplet in my JSP)
I'd prefer the second option if the caching becomes too heavy
burden for the memory. (Like a JSP which returns a table with
one million rows)
--
gR
