beehive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Schoettger (JIRA)" <...@beehive.apache.org>
Subject [jira] Updated: (BEEHIVE-868) Calling stored proc with uppercase 'CALL', and providing SQLParameter arguments, results in a compiler error
Date Mon, 29 Aug 2005 18:44:04 GMT
     [ http://issues.apache.org/jira/browse/BEEHIVE-868?page=all ]

Chad Schoettger updated BEEHIVE-868:
------------------------------------

    Attachment: BEEHIVE-868.diff

Patch for this issue attached. Patch should be applied from the <beehive_home>/system-controls/src/jdbc
directory.

Updated javacc grammar for jdbcontrol's sql parsing to ignore case of jdbc keywords.
Also updated jdbc control's drts to include tests for case-insensitive parsing of the keywords.



> Calling stored proc with uppercase 'CALL', and providing SQLParameter arguments, results
in a compiler error
> ------------------------------------------------------------------------------------------------------------
>
>          Key: BEEHIVE-868
>          URL: http://issues.apache.org/jira/browse/BEEHIVE-868
>      Project: Beehive
>         Type: Bug
>   Components: System Controls
>     Versions: TBD
>     Reporter: Chad Schoettger
>     Assignee: Chad Schoettger
>     Priority: Minor
>  Attachments: BEEHIVE-868.diff
>
> When trying to call SP's via the JdbcControl, and sending SQLParameters as arguments,
a compile time error will be thrown if the 'CALL' part of the statement is in uppercase. The
statement works fine if lowercase 'call' is used instead. It could be that this is a side-effect
of the special processing of the statement that is done because of the presence of the SQLParameter
argument.
> Error:
> org.apache.beehive.controls.api.ControlException: Error parsing SQL statment.Encountered
" " at line 1, column 6.
>       [apt] Was expecting one of:
>       [apt] "}" ...
>       [apt] "|" ...
>       [apt] [Encountered " " at line 1, column 6.
>       [apt] Was expecting one of:
>       [apt] "}" ...
>       [apt] "|" ...
>       [apt] ]
>       [apt] public void callSP_name_city(SQLParameter[] sqlParameters) throws SQLException;
> Workaround:
> Only use lowercase 'call' when accessing SP's with SQLParameters.
> Repro:
> Call a SP, providing a SQLParameter as an argument, and use an uppercase 'CALL' as part
of the statement.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message