I am a new user to hibernate - using version 2.1.2. I'm sure I'm doing something very basic wrong, but I can't seem to figure it out. I have a very simple one-to-one relationship between 2 tables.

I am using the session.find method to retrieve all of the rows in the table (no where clause). I would expect a single sql statement joining the 2 tables, but instead when I have show-sql set to true, I see that there is one sql statement returning all rows from the first table, and then 1 sql statement being generated for each row in the second table. In this case, thousands of statements are being generated.

Any help is greatly appreciated!!!

The code I am using is:

SessionFactory sessions=createHibernateSessionFactory();
Session session = sessions.openSession();
List joblist = session.find("from Job job");
session.close();


The mappings are defined as follows:

<class name="com.taos.server.hibernate.autosys.Job" table="job">
<cache usage="read-only"/>
<id name="joid" type="int" column="joid" > <generator class="assigned" /> </id>
<property name="jobName" type="java.lang.String" column="job_name" not-null="true" unique="true" length="30" />
<property name="jobType" type="java.lang.String" column="job_type" not-null="true" length="1" />
<one-to-one name="job2" constrained="true" class="com.taos.server.hibernate.autosys.Job2" />
</class>

<class name="com.taos.server.hibernate.autosys.Job2" table="job2">
<cache usage="read-only"/>
<id name="joid" type="int" column="joid" > <generator class="assigned" /> </id>
<property name="timezone" type="java.lang.String" column="timezone" length="50" />
</class>
[/code]

Thanks!