Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-406
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-406
Summary: HSQLDB stored procedure syntax not correct
Type: Bug
Status: Assigned
Priority: Minor
Project: Cayenne
Components:
Cayenne Core Library
Versions:
1.1
1.2 [DEV]
Assignee: Andrus Adamchik
Reporter: Cris Daniluk
Created: Thu, 8 Dec 2005 4:49 PM
Updated: Thu, 8 Dec 2005 4:49 PM
Description:
Cayenne currently executes HSQLDB stored procedures as follows:
{? = call procedureName(?, ?, ...)}
However, HSQLDB's parser (incorrectly) requires:
{?= call procedureName(?, ?, ...)}
Additionally, if procedureName contains periods, it must be enclosed in quotes.
The attached patch adds a new createTranslator on ProcedureAction, along with a new HSQLDBProcedureTranslator. HSQLActionBuilder is updated accordingly.
Note that HSQLDB supports reading OUT parameters at some level, but not through the traditional CallableStatement routines. It may or may not be possible to do through Cayenne - I haven't been able to figure out a consistent way to get the OUT parameters yet, and the documentation is not surprisingly unhelpful in that department.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Thu Dec 08 2005 - 16:50:47 EST