Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.help > #680

How to map the table clas

Show all headers | View raw

  To: comp.text.xml,comp.lang.j
I have two existed tables, I am NOT allow to altering those tables
The 1st table (tableA) has one column for its primary key, the 2nd
table (tableB) has tow columns for its primary key. I am try to map
these two tables with Hibernate XML. Here are my XML file.

Please see ????? in tow places.

Question 1
1st ???? is <many-to-many> tag in class TableA, but <many-to-many> tag
only allows one column. How do I map it for two columns?

Question 2
2nd ????? is the <key> tag in class TableB, similar that <key> tag only
allows one column. How do I map it for two columns?

Thank Q very much in advance!

<hibernate-mapping auto-import="false"
default-lazy="true" default-access="field">

     <class name="tableA" table="TABLEA" entity-name="TableA.class">
         <id name="tableAId" type="string" column="TABLEAID" 

                                             access="field">
             <generator class="native">
                 <param name="key">TABLEAID</param>
             </generator>
         </id>
         <property name="column1" type="string" column="COLUMN1" />
         <property name="column2" type="string" column="COLUMN2" />
         .....
         <set name="idsa" table="IDS" inverse="true">
             <key column="TABLEAID" />
             <many-to-many column="????" class="tableB" />
         </set>
      </class>

       <class name="tablesB" table="TABLEB" entity-name="TableB.class">
         <composite-id>
         <!-- this table's primary key has two columns -->
             <key-property name="tableBId1" type="string"
                                            column="TABLEBID1" />
             <key-property name="tableBId2" type="integer"
                                            column="TABLEBID2" />
         </composite-id>
         <property name="column1" type="string" column="COLUMN1" />
         <property name="column2" type="string" column="COLUMN2" />
         ....
         <set name="idsb" table="IDS">
             <key column="?????" />
             <many-to-many column="TABLEAID" class="tableA" />
         </set>
       </class>
</hibernate-mapping>

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.help | Previous | Next | Find similar

Thread

How to map the table clas "RC" <rc@THRWHITE.remove-9rw-this> - 2011-05-06 19:52 +0000

csiph-web