That's really, really great. On Sun, Jun 1, 2008 at 4:24 PM, Knut Anders Hatlen <[EMAIL PROTECTED]> wrote:
> sin(EaTing), wrote: > >> Hi, >> >> And one of the tricky point I found in the example is if a ResultSet is >> returned by a stored procedure, the Statement which generates the ResultSet >> cannot be closed in the procedure, or the ResultSet won't be returned >> correctly. >> So in the example ps1 and ps2 is not closed. Quite interesting, should >> they be garbage collected properly or whether they will cause some >> transaction problem if they are not closed? >> > > Hi, > > The result sets that are created inside a stored procedure are marked with > a flag internally, and when such a result set is closed it will also close > the statement that created it. So there shouldn't be any resource leak by > using this approach. > > -- > Knut Anders >
