Daniel John Debrunner <[EMAIL PROTECTED]> writes: [snip]
>> 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. -- dt However, experience shows that for many people and many applications a dose of paranoia is reasonable - Bjarne Stroustrup
