Hello

I went through this book of "Java Persistence with Hibernate" where I was looking for how to execute stored procedure. I came across simple example of procedure returning a selection from User class.

I would like to know that what if procedure is returning result from multiple tables? I have a class which includes huge list of attributes from different tables but then what should I specify mapping table as ? Do I need create such table with all attributes?


I went through Chapter 16 of Native SQL too but couldn't figure out the way to do this.

Thank you

I'd treat the stored procedure as a view on a (virtual) table, so you don't create the table at all but just map the results of its execution to a Java class (or Map).