This discussion is archived
4 Replies Latest reply: Nov 14, 2012 3:29 AM by alexalves RSS

ISSUE WITH XMLQUERY

972323 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points