Using stored procedure which is not related to data retrival

sudhirph · **Joined:** Thu Apr 20, 2006 3:44 am **Posts:** 32

Can we call a stored procedure through a java class in hibernate which is not at all involved related to retrieval of the data from the table?

I have seen usage of stored procedure which is used in retrieving values of certain columns of a table, using hbm files and named queries......

but my pupose is some what different, I just want to call one stored procedure...

Sudhir

r1ch · **Joined:** Wed Aug 25, 2004 6:23 am **Posts:** 91

Yes, you can call session.connection() to retrieve the JDBC connection and then call the stored procedure as normal using a CallableStatement.

sudhirph · **Joined:** Thu Apr 20, 2006 3:44 am **Posts:** 32

Is there any other ways of doing the same ?

r1ch · **Joined:** Wed Aug 25, 2004 6:23 am **Posts:** 91

I guess that you could use a named sql query in your mapping, eg something like:-

Code:

<sql-query name="callMyStoredProcedure">
    <return-scalar column="result" type="long"/>
    { ? = call myStoredProcedure() }
</sql-query>

What is it exactly that you're trying to do?

max · **Posted:** Fri Apr 28, 2006 9:42 am

yes, and why is it bad to use a connection to do what it is supposed to be used to ? ;)