Message:
The following issue has been closed.
Resolver: Gavin King
Date: Mon, 8 Dec 2003 5:14 PM
Thanks, I added this implementation to Oracle9Dialect
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-317
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-317
Summary: attempt to recreate sequence on schema update
Type: Improvement
Status: Closed
Priority: Major
Resolution: FIXED
Project: Hibernate2
Fix Fors:
2.1 final
Versions:
2.1 beta 3
Assignee:
Reporter: Zeehond
Created: Mon, 8 Sep 2003 3:23 PM
Updated: Mon, 8 Dec 2003 5:14 PM
Environment: jboss 3.2.2, oracle 9i, sun jdk 1.4.2
Description:
this is my code I run in application init routine:
ds = new Configuration();
ds.configure(this.getClass().getClassLoader().getResource("hibernate.cfg.xml"));
SchemaUpdate su = new SchemaUpdate(ds);
su.execute(false);
all tables are updated OK, but the following error happens:
2003-09-08 22:13:00,000 ERROR [net.sf.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create sequence hibernate_sequence
java.sql.SQLException: ORA-00955: name is already used by an existing object
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1741)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:233)
at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:120)
seems like Hibernate can't define whether the sequence already exists
---------------------------------------------------------------------
JIRA INFORMATION:
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
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
