File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 144
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to call stored procedure that returns an array
 
Similar Threads
Stored procedures JPA and mappings
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
Calling Stored Procedure from Hibernate mapping file