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
