Hello!

I would like to make a many-to-many relation but one of the table is not connected with the id. I have 3 tables:

Table: FOO
PK: ID
ANOTHER_ID

Table: BAR
PK: ID

Table: FOOBAR
FOO_ID
BAR_ID

My problem is that FOO:ANOTHER_ID = FOOBAR:FOO_ID. So this mapping does not work:

<bag name="Bars" table="FOOBAR">
<key column="BAR_ID"/>
<many-to-many class="Bar" column="FOO_ID">
</many-to-many>
</bag>

What can I do to connect my tables?

Regards,
TheB

Hi,

I suppose you are in the Bar.hbm.xml.
So you can try this:

<bag name="Bars" table="FOOBAR">
<key column="BAR_ID"/>
<many-to-many class="FOO" column="FOO_ID">
</many-to-many>
</bag>

Regards,

Hi TonyW,

No I'm in Foo.hbm.xml. What do I need Bars collection in Bar?

But you are right I've messed up the example. The right one looks like this:

<bag name="Bars" table="FOOBAR">
<key column="FOO_ID"/>
<many-to-many class="Bar" column="BAR_ID">
</many-to-many>
</bag>

My problem is that the relation between FOOBAR and FOO look like this: FOO:ANOTHER_ID -> FOOBAR:FOO_ID.

There has to by a way to solve such relation but!?

Regards,
TheB