[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7002) SchemaExport ERROR when using in-memory database (H2) - drop constraint issue HHH000389

[andrea handevidt (JIRA)]

SchemaExport ERROR when using in-memory database (H2) - drop constraint issue HHH000389
---------------------------------------------------------------------------------------

                 Key: HHH-7002
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-7002
             Project: Hibernate ORM
          Issue Type: Bug
          Components: core
    Affects Versions: 4.0.1
         Environment: H2Dialect, Hibernate 4.0
            Reporter: andrea handevidt
            Priority: Minor
         Attachments: HibernateError.zip

HHH-000389 resolved an issue with property name="hibernate.hbm2ddl.auto" value="create". It now performs a drop prior to create. When using an in-memory database this will throw errors on table with foreign key constraints.

ERROR (SchemaExport:426) - HHH000389: Unsuccessful: alter table security_key drop constraint FK3031A4E0BE21E8D7
ERROR (SchemaExport:427) - Table "SECURITY_KEY" not found; SQL statement:alter table security_key drop constraint FK3031A4E0BE21E8D7 

I noticed that the sqlDropString for org.hibernate.mapping.Table appends "if exists". This is missing for org.hibernate.mapping.ForeignKey.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira