aspose file tools*
The moose likes Object Relational Mapping and the fly likes Calling stored procedures from hibernate 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 "Calling stored procedures from hibernate" Watch "Calling stored procedures from hibernate" New topic
Author

Calling stored procedures from hibernate

Raj Kumar Bindal
Ranch Hand

Joined: Apr 15, 2006
Posts: 417
Can we call any type of stored procedure from hibernate(e.g. calling stored procedure returning multiple values etc)?

Is it something that only stored procedures returning sys_refcursor can be called from hibernate?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

So long as a stored procedure returns a result set as the first out parameter you can call it from Hibernate. See the documentationfor an example.

One thing worth thinking about is why you might want to call a stored procedure from Hibernate. Unless it is because you have no choice its not something I'd choose to do.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling stored procedures from hibernate
 
Similar Threads
How resultset is returned by stored procedure?
About Hibernate Support for StoredProcedure
how do i get this boolean
Any sucess using Hibernate, MySQL, and sql-update with stored procedures?
stored procedures in hibernate