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
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
