Hi

I've got a stored procedure like this:

CALL LOGIN (?,?,?,?)

I can call it using JDBC using a callable statement (basic JDBC), but not in Hibernate (with JPA).

I've tried a few things, such as



Using JDBC I'd call 'registerOutParameter' for :addesss and :folio (they are what the procedure returns to me) but I can't see any way to do this with JPA.

I read that the Stored Proc may need changing to return a ResultSet to get Hibernate to recognise it at all.

Please could someone recommend the best way of working with these kinds of procedures?

I don't see anyway that you can do this with EntityManager. I think you will have to get the Hibernate Session object from the EntityManager and then get the JDBC connection and do it the old way.

Thanks nestorjb, that's helped a lot.

On a side note, it took me a while to figure out that getDelegate was the method I needed to call on EntityManager to get the session. So now, for the benefit of anyone else having the same question, I just do this:



...and it works!

I noticed that the .connection method is deprecated, although it's not appearing on the site's API docs yet. I checked the source code and it mentions this:




Sounds like the replacement isn't quite ready yet, so I'll continue using .connection for now. If I shouldn't, pls let me know

Thanks again

This is the way to access connection now
SessionFactoryImplementor sessionFactory = (SessionFactoryImplementor)new Configuration().configure().buildSessionFactory();
try{
Connection con = sessionFactory.getConnectionProvider().getConnection();

}catch(Exception e){
e.printStackTrace();
}