XWiki & Oracle

Dear All, Has anybody got XWiki working properly with an Oracle database? I am having problems with delete and update actions on attachments. All other functionality seems to be OK. I am using XWiki version 0.9.840 running on Sun Java System Application Server Enterprise Edition 8.1. I get the problem with Oracle 9iR2 and Oracle 10g. The stack trace is given below - the error seems to be coming from JRCS. I have the attachment content and archive columns implemented as BLOBs. If you have attachment delete/update working against an Oracle database I would be interested to hear what your configuration is. Thanks, John Turner A problem occured while trying to service your request. Please contact the support if this happens again. Detailed information: Error number 3233 in 3: Exception while deleting attachment SampleImage.png of document ScratchSpace.Home Wrapped Exception: Error number 3231 in 3: Exception while loading attachment SampleImage.png of document ScratchSpace.Home Wrapped Exception: Exception occurred inside setter of com.xpn.xwiki.doc.XWikiAttachmentArchive.archive com.xpn.xwiki.XWikiException: Error number 3233 in 3: Exception while deleting attachment SampleImage.png of document ScratchSpace.Home Wrapped Exception: Error number 3231 in 3: Exception while loading attachment SampleImage.png of document ScratchSpace.Home Wrapped Exception: Exception occurred inside setter of com.xpn.xwiki.doc.XWikiAttachmentArchive.archive at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHiber nateStore.java:1647) at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHiber nateStore.java:1525) at com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514 ) at com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198) 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:747) at javax.servlet.http.HttpServlet.service(HttpServlet.java:860) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.jav a:165) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:257) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi lterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC hain.java:161) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:210) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi lterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC hain.java:161) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:263) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon textValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:173) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :161) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:132) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:185) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(Processor Task.java:653) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(Processor Task.java:534) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask(ProcessorT ask.java:403) at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.j ava:55) Wrapped Exception: com.xpn.xwiki.XWikiException: Error number 3231 in 3: Exception while loading attachment SampleImage.png of document ScratchSpace.Home Wrapped Exception: Exception occurred inside setter of com.xpn.xwiki.doc.XWikiAttachmentArchive.archive at com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentArchive(XWikiHiber nateStore.java:1514) at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHiber nateStore.java:1626) at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHiber nateStore.java:1525) at com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514 ) at com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198) 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:747) at javax.servlet.http.HttpServlet.service(HttpServlet.java:860) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.jav a:165) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:257) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi lterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC hain.java:161) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:210) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi lterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC hain.java:161) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:263) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon textValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:173) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :161) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:132) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:185) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(Processor Task.java:653) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(Processor Task.java:534) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask(ProcessorT ask.java:403) at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.j ava:55) Wrapped Exception: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.xpn.xwiki.doc.XWikiAttachmentArchive.archive at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicProper tyAccessor.java:51) at org.hibernate.tuple.AbstractTuplizer.setPropertyValues(AbstractTuplizer. java:207) at org.hibernate.tuple.PojoTuplizer.setPropertyValues(PojoTuplizer.java:176 ) at org.hibernate.persister.entity.BasicEntityPersister.setPropertyValues(Ba sicEntityPersister.java:2900) at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113 ) at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java :510) at org.hibernate.loader.Loader.doQuery(Loader.java:419) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade r.java:210) at org.hibernate.loader.Loader.loadEntity(Loader.java:1312) at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116) at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101) at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPers ister.java:2461) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(Defa ultLoadEventListener.java:350) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEvent Listener.java:331) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventLi stener.java:113) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoad EventListener.java:167) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEvent Listener.java:79) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588) at com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentArchive(XWikiHiber nateStore.java:1507) at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHiber nateStore.java:1626) at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHiber nateStore.java:1525) at com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514 ) at com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198) 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:747) at javax.servlet.http.HttpServlet.service(HttpServlet.java:860) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.jav a:165) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:257) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi lterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC hain.java:161) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:210) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi lterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC hain.java:161) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:263) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon textValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:173) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :161) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:132) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 51) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:185) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(Processor Task.java:653) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(Processor Task.java:534) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask(ProcessorT ask.java:403) at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.j ava:55) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicProper tyAccessor.java:40) ... 64 more Caused by: org.apache.commons.jrcs.rcs.TokenMgrError: Lexical error at line 1, column 1. Encountered: "" (0), after : "" at org.apache.commons.jrcs.rcs.ArchiveParserTokenManager.getNextToken(Archi veParserTokenManager.java:800) at org.apache.commons.jrcs.rcs.ArchiveParser.(ArchiveParser.java:519) at org.apache.commons.jrcs.rcs.ArchiveParser.load(ArchiveParser.java:54) at org.apache.commons.jrcs.rcs.Archive.(Archive.java:230) at com.xpn.xwiki.doc.XWikiAttachmentArchive.setArchive(XWikiAttachmentArchi ve.java:126) ... 69 more --- John Turner NDSD Development (Dialog IT) Email: John.Turner.2(a)team.telstra.com Ph: (07) 3887 4351