[ 
http://jira.xwiki.org/jira/browse/XWIKI-2009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_21323
 ] 

Vincent Massol commented on XWIKI-2009:
---------------------------------------

Indeed, importing works perfectly well so at least we have a workaround for 
Oracle.

Now we need to be sure that all the other DBs work fine with Hibernate 
3.2.5ga...

We need to decide whether to upgrade to it now or postpone that to 1.3 and 
instead document the Oracle workaround for 1.2 in the release notes...


> Error occurs during Oracle database initialization
> --------------------------------------------------
>
>                 Key: XWIKI-2009
>                 URL: http://jira.xwiki.org/jira/browse/XWIKI-2009
>             Project: XWiki Platform
>          Issue Type: Bug
>          Components: Storage
>    Affects Versions: 1.2 RC3
>         Environment: Xwiki: xwiki-enterprise-web-1.2-rc-3.war
> DB: Oracle Express 10g
> JDBC driver: Oracle JDBC Driver version - "10.2.0.1.0XE"
> OS: Windows XP
>            Reporter: marek knaze
>         Assigned To: Vincent Massol
>            Priority: Critical
>         Attachments: xwiki.log
>
>
> Oracle error occurs during first time initialization. 
> Failed updating schema while executing query "create sequence 
> xwiki.hibernate_sequence" 
> java.sql.SQLException: ORA-00955: name is already used by an existing object
>       at 
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
>       at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
>       at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
>       at 
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
>       at 
> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1615)
>       at 
> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1580)
>       at 
> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
>       at 
> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
>       at 
> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:410)
> please, see attached log file for more details.
> Steps to reproduce:
> 1)create brand new db schema (xwiki)
> 2)copy xwiki-enterprise-web-1.2-rc-3.war into tomcat container
> 3)edit hibernate.cfg.xml (uncomment Oracle DB connection)
> 4)go to http://localhost:8080/xwiki web page
> 5) see xwiki.log file for more error details

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

        
_______________________________________________
notifications mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications

Reply via email to