Hi,

I was wondering which method you guys use when forced to use a stored proc returning a result set joining several tables? If I have understood correctly there is no way to do this - Hibernate can't map the joined columns in the result set to the correct entities?

Do you map these with normal Hibernate means to an 'entity' that you then parse to represent the real entitities? Or do you simply use jdbc and omit Hibernate alltogether? Or use something else like iBatis?

Thanks,

Kari

I believe if you are using JPA you can specify a result set mapping on a native query telling the persistence provider how to map result columns into entities.

I thought that JPA has no support for stored procs? Could you elaborate? Thanks again!

I was under the impression that JPA can invoke any native SQL using EntityManager.createNativeQuery(...).