HELP: Mapping composite primary key

Kango · **Joined:** Sun Jun 13, 2004 9:49 pm **Posts:** 38

I'm getting quite stuck with this. I need to create a mapping for a very simple table with a composite primary key. Every way i have tried has given me errors. Here is the table.

Code:

create table z@ifmpsgl.ifmpsglx 
( 
   m_admin_div    char(10) not null,
   m_finance_div    char(10) not null,
   m_unit          char(10) not null,
   m_nature       char(10) not null,
   p_business_unit char(5)  not null,
   p_account       char(10),
   p_dept          char(10),
   p_project       char(15), 
   p_product       char(6), 
   p_affiliate    char(5),
   constraint z@ifmpsgl.ifmpsglx_pk primary key
   (
      m_admin_div,
      m_finance_div,
      m_unit,
      m_nature
   )      
);

Could someone provide an example hbm.xml file for this. I'm trying to justify dumping our in-house mapping system (written by me) for Hibernate. So far i'm failing.

Please help.

Darren.

Kango · **Joined:** Sun Jun 13, 2004 9:49 pm **Posts:** 38

Mapping:

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
   <class name="com.dolby.hibernate.test.XRMapping" table="ifmpsglx" schema="z@ifmpsgl">
   
      <composite-id>
         <key-property name="mapicsAdminDivision"/>
         <key-property name="mapicsFinanceDivision"/>
         <key-property name="mapicsUnit"/>
         <key-property name="mapicsNature"/>
      </composite-id>

      <property name="mapicsAdminDivision" column="m_admin_div" type="string" length="10" not-null="true"/>
      <property name="mapicsFinanceDivision" column="m_finance_div" type="string" length="10" not-null="true"/>
      <property name="mapicsUnit" column="m_unit" type="string" length="10" not-null="true"/>
      <property name="mapicsNature" column="m_nature" type="string" length="10" not-null="true"/>
      <property name="peoplesoftBusinessUnit" column="p_business_unit" type="string" length="5" not-null="true"/>
      <property name="peoplesoftAccount" column="p_account" type="string" length="10" not-null="false"/>
      <property name="peoplesoftDepartmentId" column="p_dept" type="string" length="10" not-null="false"/>
      <property name="peoplesoftProjectId" column="p_project" type="string" length="15" not-null="false"/>
      <property name="peoplesoftProductId" column="p_product" type="string" length="6" not-null="false"/>
      <property name="peoplesoftAffiliateId" column="p_affiliate" type="string" length="5" not-null="false"/>
   </class>
</hibernate-mapping>

SQL:

Code:

select 
   xrmapping0_.mapicsAdminDivision as x0_0_, 
   xrmapping0_.mapicsFinanceDivision as x0_1_, 
   xrmapping0_.mapicsUnit as x0_2_, 
   xrmapping0_.mapicsNature as x0_3_ 
from 
   z@ifmpsgl.ifmpsglx xrmapping0_

I MUST be doing something wrong.[/code]

anthony · **Posted:** Thu Jul 22, 2004 6:36 am

you're telling us the error you get....

don't forget equals & hashcode...

Kango · **Joined:** Sun Jun 13, 2004 9:49 pm **Posts:** 38

But, look at the columns being selected in the sql statement. It's trying to select the attribute names in the class and not the column names. Therefore i'm getting a JDBC error.

This is very strange.

anthony · **Posted:** Thu Jul 22, 2004 7:24 am

<composite-id>
<key-property name="mapicsAdminDivision"/>
<key-property name="mapicsFinanceDivision"/>
<key-property name="mapicsUnit"/>
<key-property name="mapicsNature"/>
</composite-id>

your forgot to specify column attribute, doing that, it is wanted that the column names are the same as the attributes names...

so just add the colunm name, and of course you don't need to duplicate a property when it is part of a composite-id: so also remove

Code:

     <property name="mapicsAdminDivision" column="m_admin_div" type="string" length="10" not-null="true"/> 
      <property name="mapicsFinanceDivision" column="m_finance_div" type="string" length="10" not-null="true"/> 
      <property name="mapicsUnit" column="m_unit" type="string" length="10" not-null="true"/> 
      <property name="mapicsNature" column="m_nature" type="string" length="10" not-null="true"/> 

Kango · **Joined:** Sun Jun 13, 2004 9:49 pm **Posts:** 38

Hehe,

I knew i must have been doing something wrong.
Thanks Anthony, that solved it.

I was making the assumption that you just referenced which columns were in the composite key, but still declared all columns as properties.

I must get our in-house system out of my head :)

Thanks again.

Darren.

anthony · **Posted:** Thu Jul 22, 2004 7:47 am

you're welcome

one thing about composite id, don't forget to code equals & hashcode and do it well. It is extremely important

Kango · **Joined:** Sun Jun 13, 2004 9:49 pm **Posts:** 38

Ahh i see commons.lang a calling. lol