[xwiki-notifications] [Issue] Commented: (XWIKI-1993) Database schema update issue when migrating from XE 1.1.2 to 1.2 RC2

[Daniel Guenther (JIRA)]

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

Daniel Guenther commented on XWIKI-1993:
----------------------------------------

Hi Vincent,

from  xwiki/WEB-INF/hibernate.cfg.xml I am using:

...
 <mapping resource="xwiki.oracle.hbm.xml"/>
 <mapping resource="feeds.oracle.hbm.xml"/>
...



> Database schema update issue when migrating from XE 1.1.2 to 1.2 RC2
> --------------------------------------------------------------------
>
>                 Key: XWIKI-1993
>                 URL: http://jira.xwiki.org/jira/browse/XWIKI-1993
>             Project: XWiki Platform
>          Issue Type: Bug
>          Components: Storage
>    Affects Versions: 1.2 RC2
>            Reporter: Martin Vanek
>         Assigned To: Vincent Massol
>             Fix For: 1.2 RC3
>
>
> SW: OracleAS 10.1.3.2 + OracleDB 10.2.0.?
> Steps:
> 1. deploy 1.1.2 war
> 2. import enterprise 1.1.2 xar (works so far)
> 3. deploy 1.2 RC2 war
> 4. exception while accessing first page
> java.sql.SQLException: ORA-00942: table or view does not exist
> 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> 	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
> 	at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
> 	at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
> 	at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
> 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> 	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
> 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
> 	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
> 	at org.hibernate.loader.Loader.doList(Loader.java:2145)
> 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
> 	at org.hibernate.loader.Loader.list(Loader.java:2024)
> 	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
> 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
> 	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
> 	at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
> 	at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64)
> 	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
> 	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
> 	at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
> 	at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
> 	at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
> 	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
> 	at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
> Steps 2:
> 1. deploy 1.1.2 war
> 2. import enterprise 1.1.2 xar (works so far)
> 3. import enterprise 1.2 RC2  xar (works so far)
> 4. deploy 1.2 RC2 war
> 5. same exception while accessing first page

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