New subject: [xwiki-users] New XWiki installation with Oracle

3 Mar 2006

      Srini,

I'm not sure what your problem is.  I'm not using the "news" feature, so
can't offer any suggestions in that area.  The XWiki distribution
contains a seed data set for MySQL, and I understand that this data set
includes some data required by the system.  It's a bit tricky to get the
data into Oracle (MySQL sql client allows direct insertion of text and
LOB columns, but Oracle SQL*Plus doesn't).  I set up a MySQL db with the
seed data and then wrote a program to read it from MySQL and write it to
Oracle.  May be you're missing some of the important seed data?

John

  _____  

From: Srinivasa Pulugurtha [mailto:[email protected]] 
Sent: Friday, 3 March 2006 9:52 AM
To: [email protected]
Subject: Re: [xwiki-users] New XWiki installation with Oracle

Thanks a million, John, I am much further now.  Many features of the
XWiki work fine.  I could even attach a 120K file.   In addition to the
steps below, I had to set 'batch_update' size to 0 in hibernate.cfg.xml
.

There are still problems though.   Under 'News' heading in the front
page, no categories show up.  I can not edit any categories as well.
What might be going on here?  Is it possible that this is just an access
rights issue?  

Another notable problem is that, I cannot edit XWiki preferences.  Which
table/ row should I modify to edit this entry?

Also, there is a ClassNotFound exception for XWiki.XwikiSkins in
xwiki.log.  This file is not included in the distribution.

Thanks in advance,
Srini

On 2/28/06, Turner, John <[email protected]> wrote: 

I've attached a zip archive that contains some files that may help you
get up and running with Oracle.  My stuff does not give a 100% solution
- there are still some issues with attachments.  You'll find these files
in the zip:

* xwiki-db_ora_tab.sql - script to create Oracle schema
* hibernate.cfg.xml - hibernate config (I'm using the Oracle OCI JDBC
driver because the thin driver apparently has some size issues with
LOBS)
* xwiki.hbm.xml - hibernate mapping (I'm using a custom type for
nulls/empty string conversion)
* String2.java - hibernate custom type

I wrote a small program to read the data from the MySQL seed database to
the Oracle schema.

I hope this helps.

Regards, John

  _____  

From: Srinivasa Pulugurtha [mailto:[email protected]] 
Sent: Wednesday, 1 March 2006 9:13 AM

To: [email protected]  <mailto:[email protected]> 

Subject: [xwiki-users] New XWiki installation with Oracle

Hi All.

I have recently downloaded and installed xwiki on mysql. It was so
smooth and impressive, we wanted to use it enterprise wide and need to
get it working with Oracle for that.  So, far I haven't been able to
deploy it properly. 

Our Environment - Oracle 9.0.2 database, with Oracle 10g JDBC Thin
drivers; Running in Tomcat (4.1.31)

Used both the schema from the attachment in the 'oracle' page of
www.xwiki.org/xwiki/bin/view/AdminGuide/Oracle and also generated the
schema using Hibernate hbm2ddl (Oracle Dialect).  I am unable to get
this deployed with Oracle database.

1. Can someone in the list, who has success with Oracle + Xwiki (at
least past where I am at), send a hibernate mapping file (xwiki.hbm.xml)
that worked for Oracle?
2. In addition to the steps outlined in the page above, are there any
other steps needed to get it working on Oracle?  Can this be done with
reasonable config/code/db changes?
Any pointers to debugging this further are much appreciated.
Here is the problem I am currently facing.
When I point my browser to the xwiki main page (out of the box), I get
the StaleObjectStateException exception while saving 'multilingual'
preference.

09:55:09,975 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> > Printer:toString:83
- listing e
ntities: 
09:55:09,975 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> > Printer:toString:90
- com.xpn.x
wiki.objects.classes.BooleanClass{prettyName=Multi-Lingual ,
displayType=yesno, unmodifiable=false, classType=com.xpn.xwi
ki.objects.classes.BooleanClass, number=1}
09:55:09,975 DEBUG http-8080-Processor5 <
<http://nh120099:8080/xwiki/bin/view/Main/WebHome>
http://nh120099:8080/xwiki/bin/view/Main/WebHome >
AbstractFlushingEventListener:p
erformExecutions:267 - executing flush
09:55:09,991 DEBUG http-8080-Processor5 <
<http://nh120099:8080/xwiki/bin/view/Main/WebHome>
http://nh120099:8080/xwiki/bin/view/Main/WebHome >
BasicEntityPersister:delete:201
7 - Deleting entity:
[com.xpn.xwiki.objects.classes.BooleanClass#component[id,name]{name=mult
ilingual, id=104408758}]
09:55:09,991 DEBUG http-8080-Processor5 <
<http://nh120099:8080/xwiki/bin/view/Main/WebHome>
http://nh120099:8080/xwiki/bin/view/Main/WebHome>
AbstractBatcher:logOpenPrepared
Statement:277 - about to open PreparedStatement (open
PreparedStatements: 0, globally: 1)
09:55:09,991 DEBUG http-8080-Processor5 <
http://nh120099:8080/xwiki/bin/view/Main/WebHome> SQL:log:311 - delete
from xwiki
booleanclasses where XWN_ID=? and XWN_NAME=?
Hibernate: delete from xwikibooleanclasses where XWN_ID=? and XWN_NAME=?

09:55:09,991 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
AbstractBatcher:getPreparedStat
ement:365 - preparing statement 
09:55:10,053 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
IntegerType:nullSafeSet:59 - bi
nding '104408758' to parameter: 1 
09:55:10,053 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
StringType:nullSafeSet:59 - bin
ding 'multilingual' to parameter: 2 
09:55:10,116 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
AbstractBatcher:logClosePrepare
dStatement:285 - about to close PreparedStatement (open
PreparedStatements: 1, globally: 2) 
09:55:10,131 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
AbstractBatcher:closePreparedSt
atement:403 - closing statement 
09:55:10,147 ERROR http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
AbstractFlushingEventListener:p
erformExecutions:277 - Could not synchronize database state with session

org.hibernate.StaleObjectStateException: Row was updated or deleted by
another transaction (or unsaved-value mapping was
incorrect): [com.xpn.xwiki.objects.classes.BooleanClass#<?xml
version="1.0" encoding="UTF-8"?> 
        <multilingual>
        <name>multilingual</name>
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType> 
        <number>1</number>

<classType>com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        at org.hibernate.persister.entity.BasicEntityPersister.check
(BasicEntityPersister.java:1431)
        at
org.hibernate.persister.entity.BasicEntityPersister.delete(BasicEntityPe
rsister.java:2062)
        at
org.hibernate.persister.entity.BasicEntityPersister.delete(BasicEntityPe
rsister.java :2203)
        at
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:
59)
        at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
        at org.hibernate.engine.ActionQueue.executeActions
(ActionQueue.java:223)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java :27
        4)
        at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv
entListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty
(XWikiHibernateStore.java:1288)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateSto
re.java:1165)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java :517)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:557)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77
)
        at com.xpn.xwiki.XWiki.saveDocument (XWiki.java:556)
        at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
        at com.xpn.xwiki.XWiki.getMainXWiki (XWiki.java:134)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
        at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
        at
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:421)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at org.apache.struts.action.ActionServlet.doGet
(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:200)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java :127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:166)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146) 
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:209)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596) 
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:144)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:235
8)
        at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:133)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke (
ErrorDispatcherValve.java:118)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:127)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext (StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service
(CoyoteAdapter.java:152)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79
9)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java :705)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57
7)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
        at java.lang.Thread.run (Thread.java:534)
        09:55:10,147 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
XWikiException:<init>:175 - Err 
        or number 3222 in 3: Exception while saving class
XWiki.XWikiPreferences
        Wrapped Exception: Row was updated or deleted by another
transaction (or unsaved-value mapping was incorrect): [com.xpn.
        xwiki.objects.classes.BooleanClass#<?xml version="1.0"
encoding="UTF-8"?>
        <multilingual>
        <name>multilingual</name> 
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType>
        <number>1</number>
        <classType>
com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        org.hibernate.StaleObjectStateException: Row was updated or
deleted by another transaction (or unsaved-value mapping was 
        incorrect): [com.xpn.xwiki.objects.classes.BooleanClass#<?xml
version="1.0" encoding="UTF-8"?>
        <multilingual>
        <name>multilingual</name>
        <prettyName>Multi-Lingual</prettyName> 
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType>
        <number>1</number>
        <classType>com.xpn.xwiki.objects.classes.BooleanClass
</classType>
        </multilingual>
        ]
        at
org.hibernate.persister.entity.BasicEntityPersister.check(BasicEntityPer
sister.java:1431)
        at org.hibernate.persister.entity.BasicEntityPersister.delete
(BasicEntityPersister.java:2062)
        at
org.hibernate.persister.entity.BasicEntityPersister.delete(BasicEntityPe
rsister.java:2203)
        at
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java
:59)
        at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
        at org.hibernate.engine.ActionQueue.executeActions
(ActionQueue.java:141)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java:27
        4)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush
(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibe
rnateStore.java:1288)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateSto
re.java:1165)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:517)
        at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc
(XWikiHibernateStore.java:557)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77
)
        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
        at com.xpn.xwiki.XWiki.getPrefsClass (XWiki.java:1418)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
        at com.xpn.xwiki.XWiki.getXWiki (XWiki.java:202)
        at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
        at org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service (HttpServlet.java:696)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:200)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:166)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java :209)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:144)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext (StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2358)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:133)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :596)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :594)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594) 
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:127)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:705)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
        at java.lang.Thread.run(Thread.java:534)
        09:55:10,162 DEBUG http-8080-Processor5 <
<http://nh120099:8080/xwiki/bin/view/Main/WebHome>
http://nh120099:8080/xwiki/bin/view/Main/WebHome>
XWikiException:<init>:175 - Err
        or number 3221 in 3: Exception while saving class
XWiki.XWikiPreferences
        Wrapped Exception: Error number 3222 in 3: Exception while
saving class XWiki.XWikiPreferences
        Wrapped Exception: Row was updated or deleted by another
transaction (or unsaved-value mapping was incorrect): [com.xpn.
        xwiki.objects.classes.BooleanClass#<?xml version="1.0"
encoding="UTF-8"?>
        <multilingual>
        <name>multilingual</name> 
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType>
        <number>1</number>
        <classType>
com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        com.xpn.xwiki.XWikiException: Error number 3222 in 3: Exception
while saving class XWiki.XWikiPreferences
        Wrapped Exception: Row was updated or deleted by another
transaction (or unsaved-value mapping was incorrect): [com.xpn.
        xwiki.objects.classes.BooleanClass#<?xml version="1.0"
encoding="UTF-8"?>
        <multilingual>
        <name>multilingual</name> 
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType>
        <number>1</number>
        <classType>
com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibe
rnateStore.java:1304)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateSto
re.java:1165)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:517)
        at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc
(XWikiHibernateStore.java:557)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77
)
        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
        at com.xpn.xwiki.XWiki.getPrefsClass (XWiki.java:1418)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
        at com.xpn.xwiki.XWiki.getXWiki (XWiki.java:202)
        at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
        at org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service (HttpServlet.java:696)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:200)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:166)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java :209)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:144)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext (StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2358)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:133)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :596)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :594)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594) 
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:127)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:705)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
        at java.lang.Thread.run(Thread.java:534)

        Wrapped Exception:

        org.hibernate.StaleObjectStateException : Row was updated or
deleted by another transaction (or unsaved-value mapping was
        incorrect): [com.xpn.xwiki.objects.classes.BooleanClass#<?xml
version="1.0" encoding="UTF-8"?>
        <multilingual> 
        <name>multilingual</name>
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType> 
        <number>1</number>

<classType>com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        at org.hibernate.persister.entity.BasicEntityPersister.check
(BasicEntityPersister.java:1431)
        at
org.hibernate.persister.entity.BasicEntityPersister.delete(BasicEntityPe
rsister.java:2062)
        at
org.hibernate.persister.entity.BasicEntityPersister.delete(BasicEntityPe
rsister.java :2203)
        at
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:
59)
        at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
        at org.hibernate.engine.ActionQueue.executeActions
(ActionQueue.java:223)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java :27
        4)
        at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv
entListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty
(XWikiHibernateStore.java:1288)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateSto
re.java:1165)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java :517)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:557)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77
)
        at com.xpn.xwiki.XWiki.saveDocument (XWiki.java:556)
        at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
        at com.xpn.xwiki.XWiki.getMainXWiki (XWiki.java:134)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
        at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
        at
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:421)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at org.apache.struts.action.ActionServlet.doGet
(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:200)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java :127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:166)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146) 
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:209)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596) 
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:144)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:235
8)
        at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:133)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke (
ErrorDispatcherValve.java:118)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:127)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext (StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service
(CoyoteAdapter.java:152)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79
9)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java :705)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57
7)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
        at java.lang.Thread.run (Thread.java:534)
        09:55:10,240 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome
<http://nh120099:8080/xwiki/bin/view/Main/WebHome> >
XWikiException:<init>:175 - Err 
        or number 3201 in 3: Exception while saving document
XWiki.XWikiPreferences
        Wrapped Exception: Error number 3221 in 3: Exception while
saving class XWiki.XWikiPreferences
        Wrapped Exception: Error number 3222 in 3: Exception while
saving class XWiki.XWikiPreferences
        Wrapped Exception: Row was updated or deleted by another
transaction (or unsaved-value mapping was incorrect): [com.xpn.
        xwiki.objects.classes.BooleanClass#<?xml version="1.0"
encoding="UTF-8"?>
        <multilingual>
        <name>multilingual</name> 
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType>
        <number>1</number>
        <classType>
com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        com.xpn.xwiki.XWikiException: Error number 3221 in 3: Exception
while saving class XWiki.XWikiPreferences
        Wrapped Exception: Error number 3222 in 3: Exception while
saving class XWiki.XWikiPreferences
        Wrapped Exception: Row was updated or deleted by another
transaction (or unsaved-value mapping was incorrect): [com.xpn.
        xwiki.objects.classes.BooleanClass#<?xml version="1.0"
encoding="UTF-8"?>
        <multilingual>
        <name>multilingual</name> 
        <prettyName>Multi-Lingual</prettyName>
        <unmodifiable>0</unmodifiable>
        <displayType>yesno</displayType>
        <number>1</number>
        <classType>
com.xpn.xwiki.objects.classes.BooleanClass</classType>
        </multilingual>
        ]
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateSto
re.java:1173)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:517)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:557)
        at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc
(XWikiCacheStore.java:77)
        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
        at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
        at com.xpn.xwiki.web.ViewEditAction.execute
(ViewEditAction.java:117)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226) 
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java :696)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:200)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:146)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java :166)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:146)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:209)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:948)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:144)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2358)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:133)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :596)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java :594)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594) 
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
33)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:127)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:705)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
        at java.lang.Thread.run(Thread.java:534)
        ======================

        Please let me know if you need further information. 
        Thanks in advance,
        Srini

--
You receive this message as a subscriber of the
[email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:  <mailto:[email protected]>
[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
<http://www.objectweb.org/wws>

RE: [xwiki-users] New XWiki installation with Oracle

Turner, John

Srinivasa Pulugurtha

tags

participants (2)