Stored Procedures with Hibernate and JPA Annotations

Here's a nice article on stored procedures with Hibernate. This might answer some questions:

Stored Procedures with Hibernate