8 Feb
2008
8 Feb
'08
2:22 a.m.
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.
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/