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> Printer:toString:83 - listing e ntities: 09:55:09,975 DEBUG http-8080-Processor5 < 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 erformExecutions:267 - executing flush 09:55:09,991 DEBUG http-8080-Processor5 <http://nh120099:8080/xwiki/bin/view/Main/WebHome 7 - Deleting entity: [com.xpn.xwiki.objects.classes.BooleanClass#component[id,name]{name=multilingual, id=104408758}] 09:55:09,991 DEBUG http-8080-Processor5 <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> AbstractBatcher:getPreparedStat ement:365 - preparing statement 09:55:10,053 DEBUG http-8080-Processor5 < 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> 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> 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> AbstractBatcher:closePreparedSt atement:403 - closing statement 09:55:10,147 ERROR http-8080-Processor5 < 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( BasicEntityPersister.java:2062) at org.hibernate.persister.entity.BasicEntityPersister.delete( BasicEntityPersister.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 ( XWikiHibernateStore.java:1288) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass( XWikiHibernateStore.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( ApplicationFilterChain.java:146) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter( SetCharacterEncodingFilter.java :127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke( StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.StandardContextValve.invoke ( StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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:2358) at org.apache.catalina.core.StandardHostValve.invoke ( StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke( ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke( ErrorReportValve.java :116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) 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.StandardEngineValve.invoke( StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext( 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.processConnection (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,147 DEBUG http-8080-Processor5 < 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( BasicEntityPersister.java:1431) at org.hibernate.persister.entity.BasicEntityPersister.delete ( BasicEntityPersister.java:2062) at org.hibernate.persister.entity.BasicEntityPersister.delete( BasicEntityPersister.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( XWikiHibernateStore.java:1288) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass( XWikiHibernateStore.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( ApplicationFilterChain.java:146) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter( SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke( StandardWrapperValve.java :209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.StandardContextValve.invoke( StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext( 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:2358) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java :596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke( ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java :594) at org.apache.catalina.valves.ErrorReportValve.invoke( ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) 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.StandardEngineValve.invoke ( StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.processConnection (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> 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( XWikiHibernateStore.java:1304) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass( XWikiHibernateStore.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( ApplicationFilterChain.java:146) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter( SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke( StandardWrapperValve.java :209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.StandardContextValve.invoke( StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext( 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:2358) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java :596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke( ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java :594) at org.apache.catalina.valves.ErrorReportValve.invoke( ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) 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.StandardEngineValve.invoke ( StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.processConnection (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( BasicEntityPersister.java:2062) at org.hibernate.persister.entity.BasicEntityPersister.delete( BasicEntityPersister.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 ( XWikiHibernateStore.java:1288) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass( XWikiHibernateStore.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( ApplicationFilterChain.java:146) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter( SetCharacterEncodingFilter.java :127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke( StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.StandardContextValve.invoke ( StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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:2358) at org.apache.catalina.core.StandardHostValve.invoke ( StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke( ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke( ErrorReportValve.java :116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) 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.StandardEngineValve.invoke( StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext( 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.processConnection (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,240 DEBUG http-8080-Processor5 < 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( XWikiHibernateStore.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( 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 ( ApplicationFilterChain.java:146) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter( SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java :166) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke( StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.StandardContextValve.invoke( StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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:2358) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java :596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke( ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java :594) at org.apache.catalina.valves.ErrorReportValve.invoke( ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) 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.StandardEngineValve.invoke ( StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (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.processConnection (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