[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6384) hibernate.hbm2ddl.auto=create does not drop tables

[Jeff Yu (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=43956#comment-43956 ] 

Jeff Yu commented on HHH-6384:
------------------------------

Hi,

Firstly, sorry to make a comment on a "CLOSED" jira, however, due to this fix, I am having an ERROR message shows those tables were not existed on running drop scripts. (the drop table is fine, as they mostly will include the 'if exists', but before dropping the table, it will drop those foreign key constraints), detailed please see my thread in Hibernate forum. https://forum.hibernate.org/viewtopic.php?f=1&t=1012898

Thanks
Jeff

> hibernate.hbm2ddl.auto=create does not drop tables
> --------------------------------------------------
>
>                 Key: HHH-6384
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6384
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.0.0.Beta2
>            Reporter: Alexandre Gattiker
>            Assignee: Steve Ebersole
>             Fix For: 4.0.0.CR2
>
>         Attachments: hibtest.zip
>
>          Time Spent: 35m
>
> Setting <property name="hibernate.hbm2ddl.auto" value="create" /> does not drop tables previous to creating them. That was the behavior up to at least 3.6.0 and was extremely useful for test cases.
> To reproduce, run attached test case twice.
> 08:27:44,503 [main] DEBUG SqlStatementLogger - create table Customer (id int8 not null, primary key (id))
> 08:27:44,504 [main] ERROR SchemaExport - HHH00389:Unsuccessful: create table Customer (id int8 not null, primary key (id))
> 08:27:44,504 [main] ERROR SchemaExport - ERROR: relation "customer" already exists
> 08:27:44,505 [main] INFO  SchemaExport - HHH00230:Schema export complete

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