Hello, friends!
I can not uderstand how to use mapping for discribing foreign key:
I want to create foregn key as Table1.Id --> Table2.Id.
But Table1 has 1 primary key and Table 2 has 2 primary key.


Table1
----------------
Name_Id (PK)
----------------
Id (FK)



Table2
----------------
Id(PK)
Parametr(PK)
---------------
Col1
Col2
Col3
..
---------------

Could you help me, please!

I may have got the columns in the <key> tag the wrong way around, I'm working off memory here. If this doesn't work, try flipping them.

Hello!
May be You do not understand.
I want to malke the mapping for follow structute:

Table1 Class1
---------------
- Name(PK) -
---------------
- D_ID (FK) -
---------------

Table2 CLass2
---------------
- ID(PK) -<-------(D_ID from table1)
- LID(PK) -
---------------
- Param1 -
- Param2 -
- Param3 -
---------------

I Used code below, but this structure does not allow save two record as (ID=1, LID=1, Param1=0, Param2=0, Param3=0) and (ID=1, LID=2, Param1=0, Param2=0, Param3=0).
It only REPLACE parameters. I thik it happens because column "LID" does not mark at mapping as primary key.


<hibernate-mapping package="com...." default-cascade="save-update">

<class name="Class1" table="TABLE1" schema="MAIN" >

<id name="Name" column="Name">
<generator class="assigned" />
</id>

<many-to-one name="D_ID" column="D_ID" class="Class2" outer-join="true" > </many-to-one>

</class>

<class name="Class2" table="TABLE2" schema="MAIN">


<id name="id" column="ID"> <generator class="identity" /> </id>

<property name="lID" column="LID"></property>

<property name="param1" column="Param1"></property>

<property name="param1" column="Param1"></property>

<property name="param1" column="Param1"></property>

</class>

</hibernate-mapping>


When I change mapping for Class2 on code below I got the mistake. What is problem?

<class name="Class2" table="TABLE2" schema="MAIN">

<composite-id>
<key-property name="dsc_id" column="DSC_ID"/>
<key-property name="lang" column="LANG"/>
</composite-id>

<property name="param1" column="Param1"></property>

<property name="param1" column="Param1"></property>

<property name="param1" column="Param1"></property>
</class>


Could you help me, please!

My previous post would handle that situation: the important point is the property-ref attribute.

If you don't want to use a collection mapping (like <set>), then your mapping is close. The main problem is that you used a key-property instead of a key-many-to-one: if you use a key-property in Class2 to refer to the PK of Class1, then hibernate has no idea that they're actually the same thing. They're separate values. ChangetoRead up on that attribute, it's in section 5.1.5, "composite-id", of the 3.1 ref docs (though admittedly, the documentation on key-many-to-one is quite poor).

When posting code, please use code tags. The code you posted is very hard to read.