openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B.J. Reed (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-918) Stored procedures not handling returns properly
Date Tue, 24 Feb 2009 19:59:01 GMT

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

B.J. Reed updated OPENJPA-918:
------------------------------

    Attachment: TORC.patch

I've narrowed the problem down a little further.  Not sure if this is something that OpenJPA
is supposed to (or planning on) support or not...

I have attached TestOracleRefCursor.java as TORC.patch

The Oracle function is a function that returns a SYS_REFCURSOR

create or replace function selectAllApplicants  
return SYS_REFCURSOR  
as  
cuApplicants SYS_REFCURSOR;  
begin  
open cuApplicants for  
select id, name from applicant;  
return cuApplicants;  
end selectAllApplicants;  
/ 

When I get the ResultList from the NativeQuery, I get an exception:
Missing IN or OUT parameter at index:: 1 {callstmnt 32580443 { ? = call selectAllApplicants()
}} [code=17041, state=null]

When I try the NativeQuery without the ? = , I get an exception that the procedure doesn't
exist.

> Stored procedures not handling returns properly
> -----------------------------------------------
>
>                 Key: OPENJPA-918
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-918
>             Project: OpenJPA
>          Issue Type: New Feature
>          Components: query
>    Affects Versions: 2.0.0
>            Reporter: B.J. Reed
>            Assignee: B.J. Reed
>             Fix For: 2.0.0
>
>         Attachments: OPENJPA-918-test.patch, TORC.patch
>
>
> Stored procedures with output parameters are not being handled properly.  Patch will
be attached shortly with test cases.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message