Hey Guys, Any chance of supporting the MySQL syntax for alter table statement under the MySQL compatibility mode?
31/07/2009 12:41:47 ERROR create(SchemaExport.java:348) SchemaExport - Unsuccessful: alter table CAMPAIGN_SERVICE_MAPPING add index FKB6C55FD57471B2CD (CAMPAIGN_TARIFF_MAPPING_ID), add constraint FKB6C55FD57471B2CD foreign key (CAMPAIGN_TARIFF_MAPPING_ID) references CAMPAIGN_TARIFF_MAPPING (rec__id) 31/07/2009 12:41:47 ERROR create(SchemaExport.java:349) SchemaExport - Syntax error in SQL statement ALTER TABLE CAMPAIGN_SERVICE_MAPPING ADD INDEX FKB6C55FD57471B2CD (CAMPAIGN_TARIFF_MAPPING_ID),[*] ADD CONSTRAINT FKB6C55FD57471B2CD FOREIGN KEY (CAMPAIGN_TARIFF_MAPPING_ID) REFERENCES CAMPAIGN_TARIFF_MAPPING (REC__ID) ; SQL statement: alter table CAMPAIGN_SERVICE_MAPPING add index FKB6C55FD57471B2CD (CAMPAIGN_TARIFF_MAPPING_ID), add constraint FKB6C55FD57471B2CD foreign key (CAMPAIGN_TARIFF_MAPPING_ID) references CAMPAIGN_TARIFF_MAPPING (rec__id) [42000-116] 31/07/2009 12:41:47 ERROR create(SchemaExport.java:348) SchemaExport - Unsuccessful: alter table CAMPAIGN_SERVICE_MAPPING add index FKB6C55FD51530CD15 (SERVICE_ID), add constraint FKB6C55FD51530CD15 foreign key (SERVICE_ID) references SERVICE (rec__id) 31/07/2009 12:41:47 ERROR create(SchemaExport.java:349) SchemaExport - Syntax error in SQL statement ALTER TABLE CAMPAIGN_SERVICE_MAPPING ADD INDEX FKB6C55FD51530CD15 (SERVICE_ID),[*] ADD CONSTRAINT FKB6C55FD51530CD15 FOREIGN KEY (SERVICE_ID) REFERENCES SERVICE (REC__ID) ; SQL statement: alter table CAMPAIGN_SERVICE_MAPPING add index FKB6C55FD51530CD15 (SERVICE_ID), add constraint FKB6C55FD51530CD15 foreign key (SERVICE_ID) references SERVICE (rec__id) [42000-116] 31/07/2009 12:41:47 ERROR create(SchemaExport.java:348) SchemaExport - Unsuccessful: alter table CAMPAIGN_TARIFF_MAPPING add index FK4F968FA29E82805F (TARIFF_ID), add constraint FK4F968FA29E82805F foreign key (TARIFF_ID) references TARIFF (rec__id) The errors go on but you get the idea... JDBC URL: jdbc:h2:mem:smsgw;TRACE_LEVEL_FILE=4;MODE=MySQL Regards, Aaron --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
