Hi,
I am new to Hibernate and in our application we have to make calls to oracle stored procedures. Does Hibernate 2 support this feature?
Any info would be appreciated.

Thanks

you can get jdbc connection from hibernate session, then call the stored procedure in jdbc

be carefull to evict objects if the stored procedure update mapped rows...

Thanks for the reply.
so you mean of doing something like this:
Connection conn = session.getConnection(); // get this from hibernate session
CallableStatement cstmt = conn.prepareCall(sqlcall);
cstmt.registerOutParameter(1, Types.VARCHAR);
cstmt.setString(2, key);
cstmt.execute();
retval = cstmt.getString(1);

Also, what do you mean by "be carefull to evict objects if the stored procedure update mapped rows"?

Thanks again.

that's exactly what i mean.

i wanted to say if you do something like:
1- get from ObjectA // ObjectA is mapped to table A
2- call SP using your code // IF SP UPDATE the row you have retrieved in table A --> myObjA is false --> you must refresh or evict it from current session

H2 does not support it directly, but you can do as the previous posters say or write a custom classpersister.

In H3 there are better support for providing custom sql (including stored procedures) with the built-in persisters.

Thanks for the reply. Are there any examples as to how to write the custom classpersister?

Thanks again.

yes - look at the ClassPErsister hierachy.

I also think there is a CustomPersister.java in the unit tests for your pleasure.

I have a stored procedure returning a REF_CURSOR. How do I get these results using hibernate having a custom persistor implemented.

I am using Hibernate 2.1.7
Oracle 9i

look into the source on e.g. SQLLoader (which is for querying)

...but again, you will need to do most of the "wiring" your self in H2 since it does not have support for callable statements inside the code....