Hello,

I am using Hibernate3.
The following iare simplified hbm files:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1

http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->

<class
name="Table1"
table="TABLE_1">

<id
name="primaryKey"
type="java.lang.String"
column="PRIMARY_KEY">
<generator class="assigned" />
</id>

<property
name="departmentNo"
type="java.lang.String"
column="DEPARTMENT_NUMBER"
length="65"/>

<property
name="groupNo"
type="java.lang.String"
column="GROUP_NO"
length="65"/>
</class>
</hibernate-mapping>


**************************************************

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1

http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->

<class
name="Table2"
table="TABLE_2">

<composite-id>
<key-property
name="departmentNumber"
column="DEPTARTMENT_NUMBER"
type="java.lang.String"
length="65"/>
<key-property
name="groupNumber"
column="GROUP_NUMBER"
type="java.lang.String"
length="65"/>
</composite-id>
<property
name="description"
type="java.lang.String"
column="DESCRIPTION"
length="65"/>
</class>
</hibernate-mapping>


********************************************************

I would like to select Table1 and Table2 by linking departmentNumbers
and groupNumbers.

can i add something liek this to Table1?
<one-to-one
name="table2"
class="Table2"
lazy="true">
<column_name>DEPARTMENT_NUMBER</column_name>
<column_name>GROUP_NUMBER</column_name>
</one-to-one>

ANd select like this?

SELECT table1 FROM Table1 table1
LEFT JOIN FETCH table1.table2

DO I use the POJO column idetifiers or the DB Field Names?
<one-to-one
name="table2"
class="Table2"
lazy="true">
<column_name>departmentNumber</column_name>
<column_name>groupNumber</column_name>
</one-to-one>

Do I need to add anything to Table2's definition?

IF this is not possible how would I write the HQL to fetch both objects without the one-to-one association?

THanks for your help