On Feb 8, 2008, at 2:22 AM, Sergiu Dumitriu wrote:
sanjayV wrote:
Sorry for that. i was not sure my message was submitted for the first time. thats the reason i tried couple of times I am using xwiki-web-1.1.2. Not sure what do you mean by oracle jdbc connector.
The connector is there, as the stacktrace shows.
I would recommend switching to XWiki 1.2.1, as it fixes several problems with Oracle.
Also make sure to read the release notes since you need to upgrade the Hibernate version if you're using 1.2. This is fixed in 1.3M1. -Vincent
The problem is that the database schema is not correctly created. When you said that you changed xwiki.hbm.xml, what exactly did you change? Were there other errors before this one in the log? If you connect directly to the database, can you see some tables in the xwiki database?
The following is the stack
Wrapped Exception:
com.xpn.xwiki.XWikiException: Error number 3212 in 3: Exception while loading ar chive -237,561,194 Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.XWikiDocumentArc hive#-237561194] at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive (XWikiHibernateVersioningStore.java:118) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArc hive(XWikiHibernateVersioningStore.java:87) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchi ve(XWikiHibernateVersioningStore.java:238) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateSt ore.java:245) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java :97) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java :91) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:957) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:935) at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(Ca lendarPlugin.java:82) at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java :294) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager .java:130) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager. java:69) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager .java:95) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:754) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708) at com.xpn.xwiki.XWiki.<init>(XWiki.java:611) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:238) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 740) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run (ServletStubImpl.java:1006) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:419) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at com.bea.p13n.servlets.PortalServletFilter.doFilter(PortalServletFilte r.java:293) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnc odingFilter.java:117) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:6724) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate dSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java: 121) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe rvletContext.java:3764) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm pl.java:2644) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java: 219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Wrapped Exception:
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java: 305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java: 272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPrepa redStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleState ment.java:894) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPre paredStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:984) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:2885) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:2926) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele gatingPreparedStatement.java:93) 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(Lo ader.java:224) at org.hibernate.loader.Loader.loadEntity(Loader.java:1785) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL oader.java:93) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL oader.java:81) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractE ntityPersister.java:2730) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(D efaultLoadEventListener.java:365) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEv entListener.java:346) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEven tListener.java:123) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultL oadEventListener.java:177) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEv entListener.java:87) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java: 891) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:799) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive (XWikiHibernateVersioningStore.java:108) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArc hive(XWikiHibernateVersioningStore.java:87) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchi ve(XWikiHibernateVersioningStore.java:238) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateSt ore.java:245) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java :97) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java :91) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:957) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:935) at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(Ca lendarPlugin.java:82) at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java :294) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager .java:130) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager. java:69) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager .java:95) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:754) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708) at com.xpn.xwiki.XWiki.<init>(XWiki.java:611) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:238) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 740) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run (ServletStubImpl.java:1006) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:419) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at com.bea.p13n.servlets.PortalServletFilter.doFilter(PortalServletFilte r.java:293) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnc odingFilter.java:117) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:6724) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate dSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java: 121) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe rvletContext.java:3764) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm pl.java:2644) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java: 219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.web, doc.name from XWikiDocument as doc]
Wrapped Exception: ClassNotFoundException: org.hibernate.hql.ast.HqlToken [selec t distinct doc.web, doc.name from com.xpn.xwiki.doc.XWikiDocument as doc] at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal( XWikiHibernateStore.java:1852) at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHib ernateStore.java:1811) at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHib ernateStore.java:2231) at com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheSt ore.java:200) at com.xpn.xwiki.plugin.lucene.IndexRebuilder.indexWiki(IndexRebuilder.j ava:116) at com.xpn.xwiki.plugin.lucene.IndexRebuilder.rebuildIndex(IndexRebuilde r.java:92) at com.xpn.xwiki.plugin.lucene.IndexRebuilder.<init>(IndexRebuilder.java :57) at com.xpn.xwiki.plugin.lucene.LucenePlugin.init(LucenePlugin.java:361) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager .java:130) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager. java:69) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager .java:95) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:754) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708) at com.xpn.xwiki.XWiki.<init>(XWiki.java:611) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:238) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 740) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run (ServletStubImpl.java:1006) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:419) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at com.bea.p13n.servlets.PortalServletFilter.doFilter(PortalServletFilte r.java:293) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnc odingFilter.java:117) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:6724) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate dSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java: 121) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe rvletContext.java:3764) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm pl.java:2644) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java: 219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Sergiu Dumitriu-2 wrote:
sanjayV wrote:
Hi
I downloaded xwiki war file and changed the hbm.cfg.xml , xwiki.hbm.xml I am using weblogic portal and oracle9i. After deploying when i used the following url http://localhost:7788/xwiki/bin/view/Main/WebHome.
I got the following error Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.XWikiDocument#104408758]
Can somebody help me out Hi,
Can you give some more details? - What version of XWiki Enterprise are you using? - Did you also add the oracle jdbc connector? - Can you give a longer stacktrace?
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users