Thanks for the response
No tables are created in my database.
I am attaching xwiki.hbm.xml
Below is hbm.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property
name="connection.url">jdbc:oracle:thin:@xxx</property>
<property name="connection.username">xxx</property>
<property name="connection.password">xxx</property>
<property
name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property
name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">8</property>
<property name="statement_cache.size">8</property>
<property
name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hibernate.query.substitutions">true=1,
false=0</property>
<!-- Mapping files -->
<mapping resource="xwiki.hbm.xml"/>
</session-factory>
</hibernate-configuration>
vmassol wrote:
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users