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 Hibernate 3 : Storing return value from Stored procedure call Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate 3 : Storing return value from Stored procedure call" Watch "Hibernate 3 : Storing return value from Stored procedure call" New topic
Author

Hibernate 3 : Storing return value from Stored procedure call

Arpit Todi
Greenhorn

Joined: Nov 03, 2004
Posts: 2
Is it possible to retrieve return value from stored procedure call
called within CUD operations.
eg.
<sql-insert callable="true">{? = call wp_Insert (?)}</sql-insert>

I am calling <sql-insert> using (In spring),

HibernateTemplate.save(usr);
or
session.save(usr);

Here,"wp_Insert" is a stored procedure call and returning value.How to
retrieve that return value?
Is there any other way to have call that custom sql query <sql-insert>.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate 3 : Storing return value from Stored procedure call