Re: [jira] Commented: (DERBY-210) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

[Kathey Marsden]

Deepa Remesh wrote:

>On looking some more, I could narrow down the problem further and
>think the problem is in DRDAResultSet.close(). In this close() method,
>splitQRYDATA variable does not get reset. I think this (combined with
>my other changes for derby-210) is what is causing the intermittent
>failure in derbynet/prepStmt.java.
>
You know, I seem to recall fixing this same sort of bug before, where
something was added to DRDAStatement but not added to close() and odd
intermittent symptoms ensued.  I wonder  how we could best avoid this
trap in the future.