HI,
I have generated a MySQL database with the maven create-schema command. It worked fine. I added a new entity class and now the entire DDL generation fail. Here is what I get: __ __ | / |__ _Apache__ ___ | |/| / _` V / -_) ' ~ intelligent projects ~ |_| |___,_|_/___|_||_| v. 1.0.2 build:start: create-schema: execute-script: [sql] Executing file: G:SRT-wregistrecoretargetschema-create.sql [sql] [ERROR] Failed to execute: create table CHEVRETTAGE ( ID $identifier.s qlType not null auto_increment, MID $attribute.sqlType not null, MDATE $attribut e.sqlType not null, POIDS $attribute.sqlType not null, MSEXE $attribute.sqlType not null, MMERE $attribute.sqlType not null, primary key (ID) ) [sql] [ERROR] java.sql.SQLException: You have an error in your SQL syntax; c heck the manual that corresponds to your MySQL server version for the right synt ax to use near '$identifier.sqlType not null auto_increment, MID $attribute.sqlT ype not null, MD' at line 1 [sql] [ERROR] Failed to execute: create table AUTHENTIFICATON ( ID $identifi er.sqlType not null auto_increment, USER_NAME $attribute.sqlType not null, PASSW ORD $attribute.sqlType not null, primary key (ID) ) [sql] [ERROR] java.sql.SQLException: You have an error in your SQL syntax; c heck the manual that corresponds to your MySQL server version for the right synt ax to use near '$identifier.sqlType not null auto_increment, USER_NAME $attribut e.sqlType not nu' at line 1 [sql] [ERROR] Failed to execute: create table FICHE_IDENTIFICATION ( ID $ide ntifier.sqlType not null auto_increment, TYPE_ANIMAL $attribute.sqlType not null , RACE $attribute.sqlType not null, NO_IDENTIFICATION $attribute.sqlType not nul l, NO_IDENTIFICATION_PRODUCTEUR1 $attribute.sqlType not null, NO_IDENTIFICATION_ PRODUCTEUR2 $attribute.sqlType not null, NO_IDENTIFICATION_TRACABILITE $attribut e.sqlType not null, DATE_NAISSANCE $attribute.sqlType not null, primary key (ID) ) [sql] [ERROR] java.sql.SQLException: You have an error in your SQL syntax; c heck the manual that corresponds to your MySQL server version for the right synt ax to use near '$identifier.sqlType not null auto_increment, TYPE_ANIMAL $attrib ute.sqlType not ' at line 1 [sql] 0 of 3 SQL statements executed successfully BUILD SUCCESSFUL Total time: 1 seconds Finished at: Sun Jul 10 16:11:04 EDT 2005 Here is the sql file: -- SKIP drop table if exists CHEVRETTAGE; -- SKIP drop table if exists AUTHENTIFICATON; -- SKIP drop table if exists FICHE_IDENTIFICATION; create table CHEVRETTAGE ( ID $identifier.sqlType not null auto_increment, MID $attribute.sqlType not null, MDATE $attribute.sqlType not null, POIDS $attribute.sqlType not null, MSEXE $attribute.sqlType not null, MMERE $attribute.sqlType not null, primary key (ID) ); create table AUTHENTIFICATON ( ID $identifier.sqlType not null auto_increment, USER_NAME $attribute.sqlType not null, PASSWORD $attribute.sqlType not null, primary key (ID) ); create table FICHE_IDENTIFICATION ( ID $identifier.sqlType not null auto_increment, TYPE_ANIMAL $attribute.sqlType not null, RACE $attribute.sqlType not null, NO_IDENTIFICATION $attribute.sqlType not null, NO_IDENTIFICATION_PRODUCTEUR1 $attribute.sqlType not null, NO_IDENTIFICATION_PRODUCTEUR2 $attribute.sqlType not null, NO_IDENTIFICATION_TRACABILITE $attribute.sqlType not null, DATE_NAISSANCE $attribute.sqlType not null, primary key (ID) ); I cannot see what is wrong with it. I manually deleted the tables to make sure there were no conflicts I ran maven clean, etc. Still does not generate the DDL. Any idea? Thanks Alain _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=2306#2306 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user