Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Murach's Java Servlets and JSP this week in the Servlets 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: 145
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?
 
 
subject: How to call stored procedure that returns an array
 
Similar Threads
Stored procedures JPA and mappings
Calling Stored Procedure from Hibernate mapping file
eclipselink stored procedures with result returned from different tables
How to map returned cursor to a POJO / Bean in Hibernate?
Calling Stored Procedure using hibernate