posted 17 years ago
All,
We have two tables, Measure and Measure_Values. The Measure_values table has a composite primary key. Hibernate mappings for both tables are given below.
Issue Values are not saved into the Measure_values table and hibernate doesnt throw any exceptions.
Create table measure(measure_id number primary key,measure_nm varchar2, measure_type varchar2);
Create table measure_value(measure_id number, dim_id number, dim_value varchar2); ) (measure_id & dim_id as primary_key
Mappings:
Code:
<class name="Measure" table="MEASURE">
<id name="measureId" column="MEASURE_ID" type="long">
<generator class="sequence">
<param name="sequence">MEASURE_SEQ</param></generator>
</id>
<property name="name"
column="MEASURE_NM"
type="java.lang.String" />
<property name="name"
column="MEASURE_TYP"
type="java.lang.String" />
<!-- Define the relationship with measure values -->
<set name="values"
lazy="false"
order-by="DIM_ID"
table="MEASURE_VALUE"
cascade="save-update,persist">
<key column="MEASURE_ID"/>
<one-to-many class="MeasureValue"/>
</set>
</class>
<!-- Define the mapping for Measure Value -->
<class name="MeasureValue" table="MEASURE_VALUE">
<composite-id>
<key-property
name="dimensionId"
type="long"
column="DIM_ID" />
<key-property
name="measureId"
type="long"
column="MEASURE_ID" />
</composite-id>
<property name="dimensionValue"
column="DIM_VALUE"
type="java.lang.String"/>
</class>