XWiki & Oracle

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

XWiki & Oracle

Turner, John
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: [hidden email]
Ph: (07) 3887 4351



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