Hi. I have a stored procedure that I need to call from Hibernate. I read many posts regarding the restrictions involved. I read about the hack that uses session.connection() with a CallableStatement, but the session.connection() method is deprecated, and I don't like the idea of using it.

On the other hand, StatelessSession connection() is *not* deprecated. Why isn't it, are there plans for it to be deprecated in the future, and what is the difference between the two .connection() methods of Session and StatelessSession?

Thank you.

BTW - I did look up StatelessSession in Gavin King's book. It says at the end of the section on page 540 "Good use cases for a StatelessSession are rare; ...".

Would a stored procedure call be one of those rare cases to break out and use it?

Thanks.