My suggestions:
1) Convert the ResultSet into a collection of objects
that represent the data you wish to display on the
JSP.
or
2) Convert the ResultSet to a RowSet object. However,
RowSet is just an interface so you would need a
concrete implementation. Sun has an early access
version of a CachedRowSet obtainable from JDC.
--- Steve A Drake <[EMAIL PROTECTED]> wrote:
> On Thu, 28 Dec 2000, Ted Husted wrote:
>
>
> So can you clone a ResultSet? The last time I
> looked into this I found
> that you have to maintain the Connection you used to
> obtain a ResultSet
> until you've finished iterating through it. If you
> close the connection,
> you lose the ResultSet. If you can clone a
> ResultSet, close the
> connection, and then later iterate the cloned
> ResultSet, I'd sure like to
> see how to do that.
>
> In lieu of cloning, I store a ResultSet in another
> object and then pass
> this new object along by firing an event. Problem
> is, my formulation is
> not a generic solution. But it does have the
> advantage that I can return
> the connection to the pool sooner and it confines
> connection handling to
> one method.
>
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
