Yes I have read but nothing work correctly, maybe you can try the sql script I have post previously, it's the easyer way to found what's wrong. And another question if I made some change manually into the code how can I recompile it without runing the whole process described into the build.xml ?
Thanks for your support. -- Alexandre Jaquet ----- Original Message ----- From: Aslak Helles�y To: alexj ; [EMAIL PROTECTED] Sent: Sunday, January 19, 2003 1:19 PM Subject: RE: [Middlegen-user] Deployement Try fkcmp="false" in the cmp20 plugin. In my last answer I asked you to read http://boss.bekk.no/boss/middlegen/nude.html. Did you read it? Aslak -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of alexj Sent: 19. januar 2003 08:54 To: alexj; [EMAIL PROTECTED] Subject: [Middlegen-user] Deployement Hi all, Rigth now I got an error when I deploy my ear to JBoss 3.0.4 : org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Wrong data type: INT4 in statement [CREATE TABLE RESSOURCE (id_ressource INT4 NOT NULL, nom TEXT, id_type_fk INT4, id_type_fk INT4, CONSTRAINT PK_RESSOURCE PRIMARY KEY (id_ressource))]) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand .java:175) I can see it's a trouble based on duplication of the id_type_fk but I didn't find where to modify this. I have see if it's an error on the jboss.xml, jbosscmp-jdbc or ejb files but didn't find where I have to fix it. Thanks for your help. -- Alexandre Jaquet ----- Original Message ----- From: alexj To: [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 3:36 PM Subject: [Middlegen-user] What's the difference ???? Hi I'm a bit confused when I want to see why the code generation failed. After reducing my db schema to be very simple I can't have a good code generation. For exemple I just made three table like that : /*************************************************************/ CREATE TABLE personne ( I just add more attributs the persons table in airline) /*************************************************************/ personne_id INT NOT NULL, nom VARCHAR (60) NOT NULL, prenom VARCHAR (60) NOT NULL, date_de_naissance DATE, adresse VARCHAR (100), npa INT, ville VARCHAR (60), telephone VARCHAR (20), email VARCHAR (20), PRIMARY KEY (personne_id) ); /*************************************************************/ CREATE TABLE groupe (just like the fligths table) /*************************************************************/ groupe_id INT NOT NULL, nom VARCHAR (50) NOT NULL, PRIMARY KEY (groupe_id) ); /*************************************************************/ CREATE TABLE fait_partie ( and here just like the reservations table /*************************************************************/ fait_partie_id INT NOT NULL, date_inscription DATE NOT NULL, groupe_id_fk INT NOT NULL, personne_id_fk INT NOT NULL, PRIMARY KEY (fait_partie_id, groupe_id_fk,personne_id_fk), FOREIGN KEY (groupe_id_fk) REFERENCES groupe (groupe_id), FOREIGN KEY (personne_id_fk)REFERENCES personne (personne_id) ); insert into personne values (1, 'jaquet','alexandre','01-05-1980','rte des Noisetiers 17',1782,'Belfaux', '0264755353','alexj'); insert into personne values (2, 'jaquet','alexandre','01-05-1980','rte des Noisetiers 17',1782,'Belfaux', '0264755353','alexj'); insert into personne values (3, 'jaquet','alexandre','01-05-1980','rte des Noisetiers 17',1782,'Belfaux', '0264755353','alexj'); Just as simple as the airline sample is. Why the airline work and not my simple db script ?????? I have exactly the same cardinality between my test and the airline sample. I can't understand.... ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
