Calling Stored procedure using hibernate

talk2niraj · **Posted:** Mon Aug 24, 2009 7:40 am

Hi,

I'm very new to Hibernate.
Friends, I would like to know, is it possible to call stored procedure in java using hibernate?
If yes, How it can be done. If a stored procedure return a resultset how to deal with that?Is it database dependent?

I have been chasing around the web trying to find any concrete examples of configuring Hibernate for use with stored procedures

Please give me some clue to do so........

thanks in advance.

Cameron McKenzie · **Posted:** Mon Aug 24, 2009 8:40 am

Here's a good little tutorial on calling Stored Procedures from Hibernate:

http://mybiblebook.spaces.live.com/blog/cns!8D4E97688DE1E193!416.entry

Code:

 Call SQL Procedure with JDBC
 
connection = openSessionInViewInterceptor
.getSessionFactory().openStatelessSession().connection();
CallableStatement callableStatement = connection
.prepareCall("call proc_my_procedure(?)");
callableStatement.setObject("in_user _id", userID);
callableStatement.registerOutParameter("out_username", java.sql.Types.VARCHAR);
ResultSet resultSet = callableStatement.executeQuery();  

Now, I'm a little concerned that you're new to Hibernate and already trying to call stored procedures. Remember, we want to think of our problems in an object-oriented way, and not as a bunch of queries that return data. Shift your mind, and programming with Hibernate will be much, much easier!

Quote:

The CallableStatement interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1.

http://www.coderanch.com/t/443101/Object-Relational-Mapping/java/JPA-Stored-Procedure
http://www.coderanch.com/forums/t/216142

talk2niraj · **Posted:** Mon Aug 24, 2009 8:47 am

Thanks Cameron....
Its always pleasent to see the quick response from someone when u r eagerly looking for it.

L.C. Wild · **Joined:** Tue Mar 10, 2009 11:26 am **Posts:** 6

Hi.

I would like to add that the "connection()" method is deprecated since Hibernate 3.2.4

You can find more informations here

shaikeliasmca · **Joined:** Wed Sep 18, 2013 5:12 am **Posts:** 6

Can I use out parameter in storedprocedure in hibenate