I have recently started looking into Hibernate for our next project, and so far have managed to get up and running with little fuss. However, I have been chasing around the web trying to find concrete examples of configuring Hibernate for use with stored procedures ... The information provided from Chapter 16 plus trawling the Hibernate users forum, and much of the information I found on the web does not provide decent examples of the calls from DAOs and, specifically, the Hibernate mapping files setup - *.hbm.xml. I am currently using MyQSL - moving to DB2 UDB soon - have successfully created a fully working Struts, POJO, Hibernate CRUD demo but can't find examples for the mappings when using stored procedures ...

There is a lot of talk regarding that this CAN be done, but how? and what about those NOT using Oracle?

Yes, stored procedures work, and, yes, it can be done with non-Oracle databases -- I use DB2/400. I just followed the examples in Ch 16 but rather than using { ? = call sp1() }, I use { call sp1() }. As is stated in the docs, the sp must return a resultset.

IMHO, don't use a stored procedure unless your environment requires it or you are trying to solve a difficult performance issue.

Curtis ...