db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-2516) Network Client allows execution of callable statement when one of the parameters is not set
Date Wed, 02 Jan 2013 11:10:12 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Knut Anders Hatlen updated DERBY-2516:

    Attachment: d2516-1a.diff

Attaching a patch that makes checkThatAllParametersAreSet() throw an exception if an INOUT
parameter has not been set and adds a test case to ProcedureTest to verify that it works.

The patch also enables the failing code in LangProcedureTest for the client driver. Note that
LangProcedureTest does not run as part of suites.All yet, as it needs more fixes to run cleanly
(Dag has a patch for that in DERBY-5945, but it's not yet committed).

All the regression tests ran cleanly with the patch.
> Network Client allows execution of callable statement when one of the parameters is not
> -------------------------------------------------------------------------------------------
>                 Key: DERBY-2516
>                 URL: https://issues.apache.org/jira/browse/DERBY-2516
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions:
>            Reporter: Kathey Marsden
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>              Labels: derby_triage10_8
>         Attachments: d2516-1a.diff
> If the second input parameter is set and the first is not.  Client allows execution of
the stored procedure.  See the following code in LangProcedureTest.java with a reference to
this bug.
>             op.clearParameters();
>             op.setString(2, "2");
>             try {
>                 // a not set
>                     op.execute();                
>                     fail("FAIL - a  not set");
>             } catch (SQLException sqle) {
>                 assertSQLState("07000", sqle);
>             }

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message