[ http://issues.apache.org/jira/browse/DDLUTILS-122?page=comments#action_12428570 ] Mike Perham commented on DDLUTILS-122: --------------------------------------
Wow, I feel idiotic. Ok, you put them at the end so you don't have to worry about ordering. You can close this. :) > Foreign keys not generated in SQL > --------------------------------- > > Key: DDLUTILS-122 > URL: http://issues.apache.org/jira/browse/DDLUTILS-122 > Project: DdlUtils > Issue Type: Bug > Components: Core - DB2 > Affects Versions: 1.0 > Reporter: Mike Perham > Assigned To: Thomas Dudziak > Priority: Critical > Attachments: fabric-schema.sql, fabric-schema.xml > > > I'm using writeSchemaSqlToFile to generate the SQL from my schema file: > {code:xml} > <target name="schema-to-sql"> > <taskdef name="ddl2Database" > classname="org.apache.ddlutils.task.DdlToDatabaseTask" > classpathref="runtime-classpath"/> > <ddl2Database databaseType="db2" schemaFile="fabric-schema.xml"> > <writeSchemaSqlToFile alterDatabase="false" doDrops="false" > failOnError="true" outputFile="fabric-schema.sql" /> > </ddl2Database> > </target> > {code} > See attached schema xml and sql. The schema was generated from mysql 5.0.19 > using the 5.0.3 JDBC driver. The SQL is being generated for DB2. Note that > the schema includes plenty of foreign key references but the generated SQL > includes none of them. This is a blocker for us to use DdlUtils. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira