[
https://issues.apache.org/jira/browse/OPENJPA-3032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18138833#comment-18138833
]
ASF subversion and git services commented on OPENJPA-3032:
----------------------------------------------------------
Commit 0616bd3cccf11e4bc0b56cb8669d7fc4fb29e13c in openjpa's branch
refs/heads/OPENJPA-3032 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=0616bd3cc ]
[OPENJPA-3032] Find stored procedures on Derby and call them on SQL Server
Stored procedures created with an unquoted mixed case name are stored
in upper case by Derby (and Oracle), so the metadata lookup now also
tries the name folded to upper case on databases folding unquoted
names to upper case, before the existing lower case fallback. A
procedure that is not found is no longer cached and the metadata
result sets are closed.
SQL Server reports procedures as name;version and parameters with a
leading @, and does not understand a bare CALL statement. The
SQLServerDictionary strips both and calls procedures with the JDBC
escape syntax {call name(?,...)}.
> StoredProcedureQuery tests fail on Derby and SQL Server
> -------------------------------------------------------
>
> Key: OPENJPA-3032
> URL: https://issues.apache.org/jira/browse/OPENJPA-3032
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Priority: Major
>
> The StoredProcedureQuery tests fail on Derby and on SQL Server and pass on
> PostgreSQL.
> On Derby the procedures are not found:
> {noformat}Rollback Procedure [GetEmpIdFNameLNameFromRS] not found{noformat}
> (also {{GetEmpASCFromRS}}, {{GetEmpOneFirstNameFromOut}}). This may be the
> TCK setup for Derby (Java procedures) rather than OpenJPA, to be checked
> first.
> On SQL Server the same tests only report "failed".
> Failing tests:
> * {{Client1}}: {{executeTest}}, {{executeUpdateOf*}}, {{getFirstResultTest}},
> {{getMaxResultsTest}}, {{getOutputParameterValue*}}, {{getParameter*}},
> {{getSingleResult*}}, {{setHintStringObjectTest}}, {{setParameter*}},
> {{setgetFlushModeTest}}, {{set/getLockMode*}},
> {{xmlOverridesNamedStoredProcedureQueryTest}},
> {{xmlOverridesSqlResultSetMappingAnnotationTest}}
> * {{Client2.setParameter*CalendarTemporalType*}}
> * {{Client3}} / {{Client}}: {{create*StoredProcedureQuery*}}
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
