openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Craig Russell (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-918) Stored procedures not handling returns properly
Date Mon, 16 Feb 2009 21:26:02 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12674069#action_12674069
] 

Craig Russell commented on OPENJPA-918:
---------------------------------------

> However, stored procedures also have the ability to return multiple types of objects
in separate ResultSet of data. 

This use case is not covered by the specification. The only cases covered are getResultList()
and getSingleResult() that expect the query to return a ResultSet, and executeUpdate(), that
expects an int returned from the query. 

So, getResultList() and getSingleResult() are mapped to a Statement.executeQuery(), and executeUpdate()
is mapped to executeUpdate().
 
> When trying to get a ResultList(), I use 

> Query query = em.createNativeQuery(sql); 
> List<Applicant> appList = query.getResultList(); 

> and get: 

> Statement.executeQuery() cannot be called with a statement that returns a row count.
Odd message since a row count is not being returned, but multiple ResultSets 

Considering that the error description for Statement.executeQuery() says "if a database access
error occurs; this method is called on a closed PreparedStatement or the SQL statement does
not return a ResultSet object", the error message might better read "Statement.executeQuery()
cannot be called with a statement that does not return a ResultSet object". 

But in any case, I don't see how to handle a native query that returns multiple result sets
without changing the specification to deal with it.




> 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
>
>
> 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