db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre.Tjeldv...@Sun.COM
Subject Re: Momory leak in JDBC driver?
Date Wed, 07 Sep 2005 08:20:36 GMT
Daniel John Debrunner <djd@debrunners.com> writes:


>> Can't say, but what I do know is that when you RE-EXECUTE a statement
>> you get a new ResultSet, but you don't automatically close the previous
>> ResultSet. So if you create multiple ResultSets from the same
>> statement before you close it, ResultSets will be leaked, at least
>> temporarily.
>> I have been told that this is incorrect according to the JDBC
>> specification...
> Are you saying Derby client driver does not close any existing
> ResultSet's that were generated by the Statement when the Statement is
> re-executed? That would indeed be against the JDBC spec, I know the
> embedded driver does close existing ResultSets.

Exactly :) And yes, the client program that had this problem with the
client driver, did not have the same problem with the embedded driver.


However, experience shows that for many people and many applications a
dose of paranoia is reasonable - Bjarne Stroustrup

View raw message