Hi there,
I'm trying to install a new version of xwiki enterprise manager (4.4).
E set up an emtpy user in my oracle 10g xe with dba role. There the database
user should have no problems to create tables or anyting else.
When I start xwiki I get a long chain of exceptions in the browser and in
the logs.
It seams to me, that xwiki tries to update the Version number in the db
before creating the requiered table for it. (loadXWikiDoc->
initializeEmptyDB-> setDBVersionToDatabase-> "Table or View does not
exist")
I tried with the "xwiki.store.migration" flag in xwiki.cfg on/off with the
same result.
I carefully read the installion documentation but I did not find any hint
how to initialize a new database schema.
Could you please help me out? I would appriciate any help.
Thank you,
Matthias
Here's the root exception.
java.sql.SQLSyntaxErrorException: ORA-00942: Table or View does not exist
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:20
5)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.
java:1008)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1307)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
tement.java:3449)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:3530)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePrepar
edStatementWrapper.java:1350)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:105)
org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:101)
org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.
java:423)
org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.ja
va:283)
org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288)
org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$3.doIn
Hibernate(HibernateDataMigrationManager.java:161)
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.
java:1229)
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseS
tore.java:1315)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBV
ersionToDatabase(HibernateDataMigrationManager.java:156)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(Abst
ractDataMigrationManager.java:365)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initia
lizeEmptyDB(HibernateDataMigrationManager.java:141)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(Abstrac
tDataMigrationManager.java:341)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(Abs
tractDataMigrationManager.java:401)
com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseSt
ore.java:665)
com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateB
aseStore.java:840)
com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateB
aseStore.java:772)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.jav
a:750)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:1404)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:1447)
com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:824)
com.xpn.xwiki.XWiki.initXWiki(XWiki.java:794)
com.xpn.xwiki.XWiki.<init>(XWiki.java:735)
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:394)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:483)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.j
ava:144)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFi
lter(SavedRequestRestorerFilter.java:208)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFi
lter(SetCharacterEncodingFilter.java:111)