Use the cvs, please.
Thomas
-----Original Message-----
>From: Klaus Pittig [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, September 20, 2001 5:22 AM
>To: [EMAIL PROTECTED]
>Subject: [castor-dev] 1-n mapping => bad results
>
>Hi.
>
>I have the following problem with a 1-n mapping:
>
>These two classes mentioned below (we use Castor Doclet to generate
>the mapping files, the generated mapping.xml is also attached!)
>are mapped 1-n, akey is foreign key in table B.
>
>When reading via oql ("SELECT u from A u") the Arraylist in EVERY A
>contains EVERY B found in the database regardless of its foreign key.
>
>What could be wrong here?
>
>
>
>The value classes:
>------------------
>/**
> * @table A
> * @xml a
> */
>class A
>{
> /**
> * @primary-key
> * @required
> * @not-null
> * @sql-type numeric
> * @sql-size 10
> */
> public int akey;
>
>
> /**
> * @field-type B
> * @required
> * @many-key contactID
> */
> public Arraylist bs;
>}
>
>/**
> * @table B
> * @xml b
> */
>class B
>{
> /**
> * @primary-key
> * @required
> * @not-null
> * @sql-type numeric
> * @sql-size 10
> */
> public int bkey;
>
> /**
> * @field-type A
> * @sql-name akey
> * @required
> */
> public int akey;
>
>
> /**
> * @sql-type varchar
> * @sql-size 250
> */
> public string something;
>}
>
>------------------------------------------------
>The generated mapping.xml:
>--------------------------
><mapping>
> <class name="A" identity="akey">
> <map-to table="A" xml="a"/>
> <field name="akey" type="integer" direct="true"
required="true">
> <sql type="numeric" name="akey"/>
> <bind-xml name="akey"/>
> </field>
> <field name="bs" collection="arraylist" direct="true"
type="B"
>required="true">
> <sql many-key="akey"/>
> <bind-xml name="bs"/>
> </field>
> </class>
> <class name="B" identity="bkey">
> <map-to table="B" xml="b"/>
> <field name="bkey" type="integer" direct="true"
required="true">
> <sql type="numeric" name="bkey"/>
> <bind-xml name="bkey"/>
> </field>
> <field name="akey" type="A" direct="true" required="true">
> <sql name="akey"/>
> <bind-xml name="akey"/>
> </field>
> <field name="somethin" type="string" direct="true">
> <sql type="varchar" name="something"/>
> <bind-xml name="something"/>
> </field>
> </class>
></mapping>
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
