aspose file tools*
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 Spring in Action this week in the Spring 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?
 
Consider Paul's rocket mass heater.
 
subject: How to call stored procedure that returns an array