Deepa Remesh wrote:

>On 2/24/06, Kathey Marsden <[EMAIL PROTECTED]> wrote:
>  
>
>I will add this comment, slightly modified, because we are now calling
>only reset() instead of close in Database.newDrdaStatement. I am
>rerunning tests after a minor change. Meantime, I will upload a draft
>patch with comments from you and Knut.
>
>  
>
My point though was that we should still keep close() and call both
close() of the old statement  and reset() to reset the statement.   Just
like reset was hidden when it was bundled in close.  The new code with
only reset() hides the fact that the old statement is getting closed. 
So that is why I suggest something like

        if (stmt != null) {
             // close the old statement
            stmt.close();       
             // reset the statement so we can reuse it for this new statement.
            stmt.reset();

            ...



Kathey


Reply via email to