This one time, at band camp, Franck Routier said:
FR>Hi,
FR>
FR>I have two tables :
FR>
FR>CREATE TABLE team ( id INTEGER UNIQUE,
FR> name VARCHAR(20)
FR> );
FR>CREATE TABLE match ( id INTEGER UNIQUE,
FR> home INTEGER REFERENCES team,
FR> visitor INTEGER REFERENCES team
FR> );
FR>
FR>What I would like is a team java object with 4 fields : an integer id, a
FR>string name and two collections of matches, one for the matches at home,
FR>one outside.
FR>
FR>But when I do :
FR>
FR>oql = db.getOQLQuery( "SELECT team FROM ldp.data.Team team" );
FR>results = oql.execute();
FR>
FR>I get the following exception :
FR>
FR>java.sql.java.sql.SQLException: ERROR: Table name "matchs" specified
FR>more than once while executing SELECT
FR>"team"."id","team"."name","match".id","match"."id" LEFT OUTER JOIN
FR>"match" ON "team"."id" = "match"."home" LEFT OUTER JOIN "match" ON
FR>"team"."id" = "match"."visitor"
FR>
FR>Am I misconfiguring something, or is it a bad conception of my database,
FR>or is it not handled by Castor ??
Franck,
Please post the mapping descriptor. Without at least that, this is
difficult to comprehend.
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
