I'm looking for a way to create and call stored procedures with hibernate.

The SP will be a simple row delete based on an expression that should run daily. Currently i'm using annotations so the only example i've seen is within a configuration file. I would like to avoid this if possible.

Anyone have any documents, examples, or suggestions?

Hi,
I'm afraid there is no short answer for this question; I would recommend you the book on the banner above... it has several pages of examples and explanations about how to integrate stored procedures in you HQL.