I am trying to call a stored procedure in Hibernate. The procedure creates a temp table where it stores complex calculations that it does for a report. The calculations require too much data to bring the records back and perform the routines in (Java) code. The last statement in the stored proc retrieves the single row from the temp table to give the calculations to my code.

Every example I see for stored procs from Hibernate shows a data set that maps to a real table. I don't want that. I need to map my data to an object that doesn't map to a table. The data is never going to be saved. In fact, the calculations are only valid at the time they are done. If I saved them, they would be potentially dirty data.

Is there a way to do this in Hibernate without tricking it into think I have a persistent table?

Thanks in advance!