hi,
i'm a newbie to castor and do have problems mapping a simple one to many
relationship.
A person has many accounts (kontos in the sample). The problem is when
reading all persons, they all get the same Accounts !!
although in the database only two Persons have Accounts (persin with id 1
and 5).
what am i doing wrong here ??
this is the mySQL definition:
CREATE TABLE tabperson (
id int(4) NOT NULL auto_increment,
vorname varchar(20) NOT NULL DEFAULT '' ,
name varchar(30) NOT NULL DEFAULT '' ,
adresse varchar(50) ,
isBoss char(1) DEFAULT '0' ,
gebDat datetime ,
test tinyint(4) ,
entryDate timestamp(14) ,
PRIMARY KEY (id)
);
CREATE TABLE tabkonto (
id int(4) NOT NULL auto_increment,
idPerson int(10) ,
nummer varchar(20) ,
saldo decimal(10,2) ,
PRIMARY KEY (id)
);
INSERT INTO tabkonto VALUES("1","1","BRJ-1","123.50");
INSERT INTO tabkonto VALUES("2","1","BRJ-2","345678.90");
INSERT INTO tabkonto VALUES("6","5","RETO-1","250.60");
INSERT INTO tabperson VALUES("1","Jakob","Br�uchi","Bottigenstrasse 102,
3018 Bern","0","1959-12-11 00:00:00","11","20011005134655");
INSERT INTO tabperson
VALUES("2","Christof","Schnyder",NULL,"1",NULL,"12","20011005124625");
INSERT INTO tabperson VALUES("3","Andres","Feuz","Bern","1","1976-03-26
00:00:00","127","20011005134838");
INSERT INTO tabperson
VALUES("4","Marc","Zesiger",NULL,"0",NULL,"2","20011005124637");
INSERT INTO tabperson
VALUES("5","Reto","Hofstetter",NULL,"0",NULL,"89","20011005124650");
INSERT INTO tabperson VALUES("11","Testy","Tester","BOSS Test
Adresse","1","2001-10-05 00:00:00","0","20011005155827");
INSERT INTO tabperson VALUES("10","Testy","Tester","BOSS Test
Adresse","1","2001-10-05 00:00:00","0","20011005153558");
the mapping.xml is as follows.
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
"<http://castor.exolab.org/mapping.dtd>">
<mapping>
<class name="brj.Person" identity="id" key-generator="MAX">
<map-to table="tabPerson" />
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="vorname" type="string">
<sql name="vorname" type="varchar"/>
</field>
<field name="name" type="string">
<sql name="name" type="varchar"/>
</field>
<field name="adresse" type="string">
<sql name="adresse" type="varchar"/>
</field>
<field name="boss" type="boolean" get-method="isBoss" set-method="setBoss">
<sql name="isBoss" type="char[01]"/>
</field>
<field name="geburtsDatum" type="date">
<sql name="gebDat" type="date"/>
</field>
<field name="test" type="integer">
<sql name="test" type="integer"/>
</field>
<field name="kontos" type="brj.Konto" required="true"
collection="vector">
<sql many-key="idPerson"/>
</field>
</class>
<class name="brj.Konto" identity="id" key-generator="MAX">
<map-to table="tabKonto" />
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="nummer" type="string">
<sql name="nummer" type="varchar"/>
</field>
<field name="saldo" type="big-decimal">
<sql name="saldo" type="decimal"/>
</field>
<field name="inhaber" type="brj.Person">
<sql name="idPerson" />
</field>
</class>
</mapping>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
