[
http://opensource.atlassian.com/projects/hibernate/browse/HBX-974?page=co...
]
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira