Using Hibernate 2.1, can't figure out solution to parent-child type scenarion:

foo
FOO_ID PK

bar
BAR_ID PK
FOO_ID
SEQUENCE
NAME

bar_data
FOO_ID
DATA

There is no PK on bar_data (i know, i know). I'm trying to retrieve all bars, where each bar also contains a Set of bar_data objects based on the FOO_ID FK.

Taking the bar_data out of the equation, i'm able to successfully retrieve all bars with this XML:

<class
name="bar"
table="bar"
mutable="false"
>

<id name="bar_id" column="BAR_ID" type="string">
<generator class="assigned"/>
</id>

<property name="name" column="name_ID" type="string"/>

</class>

I'm tried numerous things to no avail. the last thing i've tried was adding this with above:

<set name="bar_data" lazy="false">
<key column="FOO_ID"/>
<one-to-many class="bar"/>
</set>

But the SQL that is generated is filling in the bar_id in the FK select. 123 is the value of the BAR_ID value from the bar table:

select foo_id, data
from bar_data
where foo_id = 123

What I want is:

select foo_id, data
from bar_data
where foo_id = 456

Where 456 is the FOO_ID value from the bar table.

If you really need a object mapped to the bar_data table you can use composite-element probably. If you dont, map it as a collection of value types, look at http://www.hibernate.org/hib_docs/reference/html/collections.html#collections-s1-5