I have the following CQL in my processor
<query id="q1"><![CDATA[
SELECT
xmlquery(
'for $i in /PDRecord where $i/PDName="hello" return $i/PDName'
PASSING BY VALUE
c2 as "."
RETURNING CONTENT
) XMLData as c1
FROM
channel
]]></query>
The input data is : <PDRecord><PDName>hello</PDName></PDRecord>
where c1 and c2 are of type xmltype defined in event type .
The adapter used here is pubsub . When the event get published , I get the following error message
<Nov 3, 2012 7:02:03 PM GMT+05:30> <Warning> <Ede> <BEA-000000> <Exception for 'eventType=myEvent object=channel kind=PLUS time=5252630450455 c1=<PDRecord><PDName>hello</PDName></PDRecord>, c2=<PDRecord><PDName>hello</PDName></PDRecord> isTotalOrderGuarantee=true' raised by listener = com.oracle.cep.processor.cql.impl.CQLEventReceiver@47881e1
com.bea.wlevs.ede.api.EventProcessingException: Internal error processing event [eventType=myEvent object=channel kind=PLUS time=5252630450455 c1=<PDRecord><PDName>hello</PDName></PDRecord>, c2=<PDRecord><PDName>hello</PDName></PDRecord> isTotalOrderGuarantee=true] = oracle/i18n/text/OraCollator
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.sendToEngine(CQLEventReceiver.java:523)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.onInsertEvent(CQLEventReceiver.java:257)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:133)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:477)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:161)
at com.bea.wlevs.channel.impl.ChannelImpl.onInsertEvent(ChannelImpl.java:443)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
at com.bea.wlevs.ede.impl.EventSourceEventSenderImpl.sendInsertEvent(EventSourceEventSenderImpl.java:86)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:133)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:477)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:161)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.deliverEvents(HttpSubAdapter.java:166)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.run(HttpSubAdapter.java:92)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$FastClassByCGLIB$$d6027a4e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.wlevs.ede.impl.EventManagerAccessorProxy.invoke(EventManagerAccessorProxy.java:30)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.wlevs.ede.impl.EventBeanProxy.invoke(EventBeanProxy.java:38)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$EnhancerByCGLIB$$3a01ee82.run(<generated>)
at com.bea.wlevs.spring.RunnableBeanPostProcessor$RunnableWrapper.run(RunnableBeanPostProcessor.java:118)
at weblogic.work.commonj.CommonjWorkManagerImpl$WorkWithListener.run(CommonjWorkManagerImpl.java:204)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: java.lang.NoClassDefFoundError: oracle/i18n/text/OraCollator
at oracle.xml.xqxp.functions.builtIns.FNUtil.getCollator(FNUtil.java:355)
at oracle.xml.xqxp.datamodel.OXMLItem.compareValue(OXMLItem.java:989)
at oracle.xquery.exec.XQueryUtils.compareValue(XQueryUtils.java:663)
at oracle.xquery.exec.GeneralComparison.compareItem(GeneralComparison.java:266)
at oracle.xquery.exec.GeneralComparison.compareItemLists(GeneralComparison.java:210)
at oracle.xquery.exec.GeneralComparison.Evaluate(GeneralComparison.java:177)
at oracle.xquery.exec.NodeSource.EvaluateFilter(NodeSource.java:265)
at oracle.xquery.exec.FilterProject$FilterProjectIterator.Fetch(FilterProject.java:113)
at oracle.xquery.exec.FLWR$FLWRIterator.Fetch(FLWR.java:151)
at oracle.xquery.exec.ExprSequence$ExprSequenceIterator.Fetch(ExprSequence.java:103)
at oracle.xquery.exec.OXQuerySequence.next(OXQuerySequence.java:259)
at oracle.cep.execution.xml.XMLSequence.next(XMLSequence.java:60)
at oracle.cep.execution.internals.memory.AEval.invokeXQryFunction(AEval.java:1925)
at oracle.cep.execution.internals.memory.AEval.eval(AEval.java:487)
at oracle.cep.execution.internals.memory.AEval.eval(AEval.java:337)
at oracle.cep.execution.operators.Project.run(Project.java:295)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:999)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:981)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1059)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInteropQueue.java:549)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQueue.java:451)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQueue.java:78)
at oracle.cep.execution.operators.StreamSource.run(StreamSource.java:708)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1120)
at oracle.cep.execution.ExecManager.runOperator(ExecManager.java:326)
at oracle.cep.execution.operators.ExecOptTask.run(ExecOptTask.java:73)
at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:371)
at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:296)
at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:243)
at oracle.cep.execution.ExecManager.insertBase(ExecManager.java:978)
at oracle.cep.execution.ExecManager.insertFastBase(ExecManager.java:1088)
at oracle.cep.execution.ExecManager.insertFast(ExecManager.java:1031)
at oracle.cep.server.CEPServer.executeDMLBase(CEPServer.java:318)
at oracle.cep.server.CEPServer.executeDML(CEPServer.java:224)
at oracle.cep.jdbc.CEPPreparedStatement.executeDMLBase(CEPPreparedStatement.java:972)
at oracle.cep.jdbc.CEPPreparedStatement.executeDML(CEPPreparedStatement.java:913)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.executeDMLBase(CQLEventReceiver.java:548)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.sendToEngine(CQLEventReceiver.java:513)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.onInsertEvent(CQLEventReceiver.java:257)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:132)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:476)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:160)
at com.bea.wlevs.channel.impl.ChannelImpl.onInsertEvent(ChannelImpl.java:443)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
at com.bea.wlevs.ede.impl.EventSourceEventSenderImpl.sendInsertEvent(EventSourceEventSenderImpl.java:85)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:132)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:476)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:160)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.deliverEvents(HttpSubAdapter.java:167)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.run(HttpSubAdapter.java:92)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$FastClassByCGLIB$$d6027a4e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.wlevs.ede.impl.EventManagerAccessorProxy.invoke(EventManagerAccessorProxy.java:30)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.wlevs.ede.impl.EventBeanProxy.invoke(EventBeanProxy.java:38)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$EnhancerByCGLIB$$3a01ee82.run(<generated>)
at com.bea.wlevs.spring.RunnableBeanPostProcessor$RunnableWrapper.run(RunnableBeanPostProcessor.java:117)
at weblogic.work.commonj.CommonjWorkManagerImpl$WorkWithListener.run(CommonjWorkManagerImpl.java:204)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
>
I have downloaded the orai18n-collation.jar and put in the classpath . but still the error comes