I have a table X which has a foreign key reference to table y.
When I issue a session.get() on table X based on primary key, is there a way so that the all the contents of table Y is also retrieved along with table X.

In the table X hbm.xml file
there is a mapping for table Y

<many-to-one name="Y" class="com.efg.hibernate.Y" fetch="select">
<column name="FK" not-null="true" />
</many-to-one>

Thanks in advance.

Hi Amy,
that option depends on the "fetch" option in your mapping file, if you want to define it at entity-level (meaning you won't be able to disable it).
Or you can do it dynamically using HQL "fetch join".

Please see the hibernate.org reference documentation for details, and use the correct forum: https://forum.hibernate.org/viewforum.php?f=1

Thanks Sanne.