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

[Max Rydahl Andersen (JIRA)]

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

Max Rydahl Andersen commented on HBX-974:
-----------------------------------------

what version of hibernate are you referring to ?

somehow schemaupdate found a POOL_DETAILS table in your database and is now trying to update it.

Either hibernate is configured to look in another schema than yours or you are not using a version of hibernate that has an old schemaupdate bug about it looking up tables in other schemas.

> 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
>
> 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