How to map inner object using Hibernate/JPA without xml/annotation?

Question

We have an object, A, which contains another object, B. We have Hibernate calling a stored procedure to query the data and populate instances of A. We're using the @NamedNativeQuery annotation with teh resultClass property set to A.class. This works great except that the instances of B are loaded lazily, as if Hibernate can't figure out how to create them based on the metadata returned. We've renamed the 'AS' clauses in the stored procedure to reflect the nesting of B within A and to point directly to the field names of B with no success.

Question is: how do we get eager loading of object fields when a stored procedure is used without resorting to *.hbm.xml or huge @SqlResultSetMapping annotations?

Answer 1

You can't. From the Hibernate documentation:

Stored procedures currently only return scalars and entities. <return-join> and <load-collection> are not supported.

<return-join> is what you would have used to map eagerly loaded association in (non-SP) named SQL query.