Hello,

I use MS SQL Server and I have a table named "MyTable", whose primary key is
a "triple key".
Well, may be that's not the right vocabulary, but I hope you'll see what I
mean:
- The columns in "MyTable" are: "ID1", "ID2", "ID3", "Description".
- Each element in "MyTable" my table is (uniquely) identified by (ID1, ID2,
ID3).
- Each object of the class "MyClass" maps to "MyTable"
- "ID1" is an ID that relates to a java object of the Class "MyClass1"
- "ID2" is an ID that relates to a java object of the Class "MyClass2"
- "ID3" is an ID that relates to a java object of the Class "MyClass3"

The big question is: how do I write the part in the "mapping.xml" file that
describes how "MyClass" maps to "MyTable"?

    <class name="MyClass" identity="<??? I dont know !!!>"  >
        <map-to table="MyTable"/>
        <field name="ID1" type="integer">
                <sql name="ID1" type="integer" />
        </field>
        <field name="ID2" type="integer">
                <sql name="ID2" type="integer" />
        </field>
        <field name="ID3" type="integer">
                <sql name="ID3" type="integer" />
        </field>
        <field name="Desc" type="string">
                <sql name="Desc" type="char" />
        </field>
    </class>


Could somebody help ?
Thanks,

Alexandre








* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
Confidentiality Notice : 
The information contained in this e-mail message is intended only for the
personal and confidential use of the recipient(s) named above. If the reader
of this message is not the intended recipient or an agent responsible for
delivering it to the intended recipient, you are hereby notified that you
have received this document in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error, please notify [EMAIL PROTECTED]
immediately by e-mail, and delete the original message.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to