[hibernate-issues] [Hibernate-JIRA] Resolved: (HBX-974) Unable to recreate tables using Hibernate

[Diego Plentz (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Diego Plentz resolved HBX-974.
------------------------------

      Assignee: Diego Plentz
    Resolution: Won't Fix

Closing as won't fix since is a Hibernate 2 bug. Give a try with hib3.

> Unable to recreate tables using Hibernate 
> ------------------------------------------
>
>                 Key: HBX-974
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-974
>             Project: Hibernate Tools
>          Issue Type: Task
>         Environment: Oracle 9i.
>            Reporter: sridhar negi
>            Assignee: Diego Plentz
>
> i m using SchemaUpdate tool of Hibernate.The problem which i m facing is that i had some tables in the database ,now i needed to delete some of the columns from some of the tables. Since UpdateSchema does not allow to delete columns ,i decided to manually drop the those tables from oracle database and recreate those tables. But i m not able to do the same. It tries to fire alter table command, even when there is no such table present in the database..The error whcih i m getting is some thing like this..
>  [java] alter table POOL_DETAILS add POOL_WEIGHT DOUBLE PRECISION
>  [java] 52085 DEBUG [main] hbm2ddl.SchemaUpdate - execute alter table POOL_DETAILS add POOL_WEIGHT DOUBLE PRECISION
>  [java] 52147 ERROR [main] hbm2ddl.SchemaUpdate - execute Unsuccessful: alter table POOL_DETAILS add POOL_WEIGHT DOUBLE PRECISION
>  [java] 52147 ERROR [main] hbm2ddl.SchemaUpdate - execute ORA-00942: table or view does not exist     

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira