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

3 Mar 2006

John,

Thanks for the quick response.
I am afraid about the seed data.   I wrote a java program to copy each
individual tables with LOBs (before letting hibernate create the
constraints).  I did spend some time comparing mysql tables and oracle
tables after that.  I guess, need to do more of it.

Thanks,
Srini

On 3/2/06, Turner, John &lt;John.Turner3(a)team.telstra.com&gt; wrote:
...

 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:pulugurtha@gmail.com]
 *Sent:* Friday, 3 March 2006 9:52 AM

 *To:* xwiki-users(a)objectweb.org
 *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 &lt;John.Turner3(a)team.telstra.com&gt; 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:pulugurtha@gmail.com]
 *Sent:* Wednesday, 1 March 2006 9:13 AM

 *To:* xwiki-users(a)objectweb.org
 *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
  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 >
 AbstractFlushingEventListener:p
 erformExecutions:267 - executing flush
 09:55:09,991 DEBUG http-8080-Processor5
<http://nh120099:8080/xwiki/bin/view/Main/WebHome >
 BasicEntityPersister:delete:201
 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

 --
 You receive this message as a subscriber of the
 xwiki-users(a)objectweb.org mailing list.
 To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
 For general help: mailto: sympa(a)objectweb.org?subject=help
 ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

 --
 You receive this message as a subscriber of the xwiki-users(a)objectweb.orgmailing list.
 To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
 For general help: mailto:sympa@objectweb.org?subject=help
 ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

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