avoiding foreign key creation with hbm2ddl

Asked Mar 22 '14 at 12:21

Active Mar 22 '14 at 16:09

Viewed 277 times

I get a lot of errors when (re)deploying my application when hbm2ddl is trying to drop foreign keys:

12:57:19,981 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 52) HHH000389: Unsuccessful: alter table Input_Locators drop constraint FK_arbj5vt6ne4x18pecm2eiiqwr if exists
12:57:19,982 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 52) Tabelle "INPUT_LOCATORS" nicht gefunden
Table "INPUT_LOCATORS" not found; SQL statement:

I'm using jboss wildfly with in memory h2. and my hbm2ddl.auto is set to create-drop.

To avoid all this error spam, my idea was to completely remove foreign keys from schema creation. I don't need them. JPA takes care of my data integrity. And for the production environment, I will write my ddl statements manually anyway. But I could not find any documentation on how to configure hbm2ddl so it only creates/drops tables and not foreign keys. Is there any way to do this?

edited Mar 22 '14 at 16:09

asked Mar 22 '14 at 12:21

EasterBunnyBugSmasher

1,507
2
15
34

If you don't need foreign keys you might want to change dialect. – Bart Mar 22 '14 at 16:25
which Dialect would that be? – EasterBunnyBugSmasher Mar 22 '14 at 16:37
did you find any solution? – SG87 Jul 10 '17 at 11:06

avoiding foreign key creation with hbm2ddl

0 Answers0