> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Eric
> Lacroix
> Sent: 11. juli 2002 14:47
> To: [EMAIL PROTECTED]
> Subject: RE: [Middlegen-user] middlegen cmp2 Postgresql and JBoss
>
>
> Le jeu 11/07/2002 � 11:53, Aslak Helles�y a �crit :
> > Well, the PostgreSQL driver has been buggy, but I have managed to get a
> > working one from the author, Chris Shaw. It's in CVS.
> > Try again with that driver, and everything should be OK.
>
> Yeah, thanks, it seems to work. The deployment is OK. We'll have to test
> the EJB now.
> It still remains a problem : when the tables are not created before the
> deployment, when deploying the .jar, this error appens :
> org.jboss.deployment.DeploymentException: Error while creating table; -
> nested throwable: (java.sql.SQLException: ERROR: CREATE TABLE:
> attribute "fk_gen_id" duplicated
>
I ran Middlegen on your tables. Since you didn't mention it, I assume your
cardinality/directionality is:
Gen <-1---*-> Genadresse <-*---1-> Adresse
The JBoss verifier didn't complain. I suggest you ask in the JBoss forum
what's wrong. If you can trace the error back to XDoclet or Middlegen,
please post a bug report for either of them.
Bonne chance!
Aslak
> Regards,
> Eric.
>
> Here's the definition of the original tables (for testing) :
> CREATE TABLE "gen" (
> "id" int4 NOT NULL,
> "nom" text NOT NULL ,
> PRIMARY KEY ("id"), UNIQUE ("id"));
> CREATE INDEX "gen_id_key" ON "gen"("id");
>
> CREATE TABLE "adresse" (
> "id" int4 NOT NULL,
> "rue" text NOT NULL ,
> PRIMARY KEY ("id"), UNIQUE ("id"));
> CREATE INDEX "adresse_id_key" ON "adresse"("id");
>
>
> CREATE TABLE "genadresse" (
> "id" int4 NOT NULL,
> "fk_gen_id" int4 REFERENCES "gen"("id") ,
> "fk_adresse_id" int4 REFERENCES "adresse"("id") ,
> PRIMARY KEY ("id"), UNIQUE ("id"));
> CREATE INDEX "genadresse_id_key" ON "genadresse"("id");
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> PC Mods, Computing goodies, cases & more
> http://thinkgeek.com/sf
> _______________________________________________
> middlegen-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/middlegen-user
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
PC Mods, Computing goodies, cases & more
http://thinkgeek.com/sf
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user
