> -----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 suppose all your relationships are bidirectional since you didn't say
anything about it.
Ask for help in the JBoss forum. If there is something wrong with the
deployment descriptor, try to figure out whether this is an XDoclet or
Middlegen problem.
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
