I am using Castor 0.9.3 (0.9 has the same effects) and i do have
following problems
on a Win2000 Machine with JDK1.3 with the Castor generated SQL
Statements.
Taking following mapping
....
<description>Auftrag</description>
<map-to table="auftrag" />
<field name="id" type="integer" >
<sql name="id" type="integer"/>
</field>
<field name="wert" type="double">
<sql name="wert" type="float" dirty="check" />
</field>
<field name="datum" type="date">
<sql name="datum" type="date" dirty="check" />
</field>
<field name="kunde" type="model.Kunde">
<sql name="id_kunde" />
</field>
</class>
<!-- Mapping for Kunde -->
<class name="model.Kunde"
identity="id">
<description>Kunde</description>
<map-to table="kunde" />
<field name="id" type="integer" >
<sql name="id" type="integer"/>
</field>
<field name="name" type="string">
<sql name="name" type="varchar" dirty="check" />
</field>
<field name="adresse1" type="model.Adresse" >
<sql name="id_adresse1" />
</field>
<field name="adresse2" type="model.Adresse" >
<sql name="id_adresse2" />
</field>
<field name="auftraege" type="model.Auftrag" required="false"
collection="arraylist" lazy="true"/>
</class>
...
i get the generated SQL:
[test] SQL for loading model.Kunde:
SELECT kunde.name,
kunde.id_adresse1,
kunde.id_adresse2,
auftrag.id
FROM kunde LEFT OUTER JOIN auftrag
ON kunde.id=auftrag.id WHERE kunde.id=?
but i would expect
SELECT kunde.name,
kunde.id_adresse1,
kunde.id_adresse2,
auftrag.id_kunde
FROM kunde LEFT OUTER JOIN auftrag
ON kunde.id=auftrag.id_kunde WHERE kunde.id=?
Has anyone the same problems?
Hint: Choosing different names for identities like id_kunde and
id_auftrag solves the problem,
but not for me, becaus i have to use the columnnames id in each table
:-(
i hope someone can help me
bya Mathias
