Hi Chintan, This has come up before and the net was that we could not support multiple result sets without some help (or changes) from the specification.
There's a bit more information in OPENJPA-918<https://issues.apache.org/jira/browse/OPENJPA-918>, but unfortunately right now you're best advice is to run the stored procedure manually. Some people have had luck by obtaining the connection used by the EntityManager and executing the stored procedure there (in particular take a look at this thread<http://openjpa.208410.n2.nabble.com/Open-JPA-Persistence-td6224283.html>from earlier today). Hope this helps -mike On Wed, Mar 30, 2011 at 10:12 AM, chintan4181 <[email protected]> wrote: > Hi, > > I am using openJPA 2.0 and calling SQL sever stored procedure using > CreateNativeQuery. My stored proc is returning multiple resultset. When i > use Query.getResultList(), it returns me only first result set. rest of the > result sets i can not see. > > Is there a way to get the multiple result set return by Stored procedure > from OpenJPA api? > > Your help will be highly appreicated. > > Thanks > Chintan > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Read-Multiple-Resultset-from-Stored-Proc-call-using-Open-JPA-tp6223507p6223507.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. >
