This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes How to call stored procedure that returns an array Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How to call stored procedure that returns an array" Watch "How to call stored procedure that returns an array" New topic
Author

How to call stored procedure that returns an array

Jitesh Sinha
Ranch Hand

Joined: Jun 19, 2004
Posts: 146
Hi Folks,

I have searched a lot on internet trying to find sample code for my requirement.The closest solution to my problem that I can find is -


The part that bothers me is the resultClass attribute inside org.hibernate.annotations.NamedNativeQuery annotation.I don't have any class for this attribute since my stored procedure is going to return 2 dimensional array.Is it even possible to call this kind of stored procedure from hibernate code?
 
rocket mass heater kickstarter
 
subject: How to call stored procedure that returns an array