Hi Thomas, This was created by hibernates auto create table functionality with the dialect to set to MySQL (not InnoDB).
Sadly this means it is not possible for me to change this alter table statement. Cheers, Aaron On Aug 5, 4:47 am, Thomas Mueller <[email protected]> wrote: > Hi, > > Thanks for your mail! I will add a feature request. Was it created > using a tool (MySQL export or something similar)? If not, I'm afraid > it has low priority for me. For H2, this here should work (please tell > me if it doesn't): > > alter table CAMPAIGN_SERVICE_MAPPING add constraint FKB6C55FD57471B2CD > foreign key (CAMPAIGN_TARIFF_MAPPING_ID) references > CAMPAIGN_TARIFF_MAPPING (rec__id); > > Regards, > Thomas > > On Fri, Jul 31, 2009 at 4:50 AM, > > AaronJWhiteside<[email protected]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
