Hibernate version: 2.1.8

Mapping documents:


<hibernate-mapping>
<class name="com.notiva.cbo.buyer.data.setup.types.MemoLineReasonSetupImpl" lazy="true" table="MEMO_LINE_REASON_SETUP" >

<id column="MEMO_LINE_REASON_ID" name="id" type="java.lang.Long" unsaved-value="null">
<generator class="com.notiva.util.hibernate.SequenceIntervalGenerator">
<param name="sequence">SEQ_MEMO_LINE_REASON_SETUP_ID</param>
<param name="interval">50</param>
</generator>
</id>
<version column="VERSION_NBR" name="version" type="integer"/>
<property column="CODE" length="5" name="code" type="java.lang.String"/>
<property column="SHORT_DESC" length="40" name="shortDescription" type="java.lang.String"/>

<joined-subclass name="com.notiva.cbo.buyer.data.setup.types.VarianceDetailReasonSetupImpl" lazy="true"
table="VARIANCE_DETAIL_REASON_SETUP">

<key column="MEMO_LINE_REASON_ID" />

<property column="VARIANCE_TYPE_ID" name="varianceType" not-null="true" type="com.notiva.core.data.lookup.VarianceType"/>

</joined-subclass>

</class>

</hibernate-mapping>

Name and version of the database you are using: Oracle 9i


Here's my problem, my table: VARIANCE_DETAIL_REASON_SETUP needs to have its own PK because of a long story. I cannot figure out how to do this, is it possible?

I need to add something like this to the <joined-subclass mapping:


<id column="VARIANCE_DETAIL_REASON_ID" name="myId" type="java.lang.Long" unsaved-value="null">
</id>


..but then it wouldn't quite be a subclass then would it? Hmm... anyone have any design suggestions?

Thanks,

Matt Dowell
Notiva Corp.

I found someone with the same problem.

http://forum.hibernate.org/viewtopic.ph ... edsubclass

We are going to manually manage the PK on the joined-subclass.

Matt