Hi,
I am using a cartesian context with this content :
<spatial:context id="Lambert1NORD" anyinteract-tolerance="0.01" cartesian="true" srid="41013" tolerance="0.01"/>
I want to detect if a point is anyinteracting a rectangle. Here are my two queries :
<![CDATA[
istream(
select a.*, com.oracle.cep.cartridge.spatial.Geometry.createPoint@Lambert1NORD(a.x, a.y) as geometry ,com.oracle.cep.cartridge.spatial.Geometry.createRectangle@Lambert1NORD( 613000.0d, 146000.0d,618000.0d, 148000.0d) as rectangle
from inputchannel[now] as a
where a.x is not null and a.y is not null
)
]]>
</view>
<query id="QueryInput"><![CDATA[
istream(
select i.nom, i.refSource, i.dateCurrentPos, i.x, i.y, 0d as distance
from ViewVehicule[now] as i
WHERE ANYINTERACT@Lambert1NORD(i.geometry, i.rectangle, 5.0d)=true
)
]]></query>
It seems to give my the first answer, but after I receive a big stack with this :
ontext for "ApplicationFormation1.Project3" was started successfully>
VÚhicule: Acquisition Radar(S4) - CDG / ENV 7 : 04/09/2014 17:09:37 [0,000000]--
> X=614373,500000 Y=146004,500000
<Sep 4, 2014 5:05:38 PM CEST> <Warning> <CQLServerTrace> <BEA-000000> <External
fault handler failed: oracle.cep.execution.ExecException: >
<Sep 4, 2014 5:05:38 PM CEST> <Warning> <CQLServerTrace> <BEA-000000> <
oracle.cep.execution.ExecException:
at oracle.cep.execution.operators.Select.run(Select.java:468)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.RangeWindow.run(RangeWindow.java:537)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.ViewStrmSrc.run(ViewStrmSrc.java:341)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.IStream.run(IStream.java:304)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.Project.run(Project.java:459)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.Select.run(Select.java:553)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.RangeWindow.run(RangeWindow.java:537)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
at oracle.cep.execution.operators.StreamSource.run(StreamSource.java:903
)
at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1216)
at oracle.cep.execution.ExecManager.runOperator(ExecManager.java:357)
at oracle.cep.execution.operators.ExecOptTask.run(ExecOptTask.java:82)
at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:423)
at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:320)
at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:267)
at oracle.cep.execution.ExecManager.insertBase(ExecManager.java:1282)
at oracle.cep.execution.ExecManager.insertFastBase(ExecManager.java:1392
)
at oracle.cep.execution.ExecManager.insertFast(ExecManager.java:1335)
at oracle.cep.server.CEPServer.executeDMLBase(CEPServer.java:327)
at oracle.cep.server.CEPServer.executeDML(CEPServer.java:233)
at oracle.cep.jdbc.CEPPreparedStatement.executeDMLBase(CEPPreparedStatem
ent.java:978)
at oracle.cep.jdbc.CEPPreparedStatement.executeDML(CEPPreparedStatement.
java:919)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.executeDMLBase(CQL
EventReceiver.java:562)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.sendToEngine(CQLEv
entReceiver.java:523)
at com.oracle.cep.processor.cql.impl.CQLEventReceiver.onInsertEvent(CQLE
ventReceiver.java:259)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListene
r(EventSenderImpl.java:583)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSen
derImpl.java:291)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendI
nsertEvent(RecordPlaySendEventInterceptor.java:160)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(
EventInspectInterceptor.java:131)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsert
Event(MonitorSendEventInterceptor.java:476)
at com.bea.wlevs.channel.impl.ChannelImpl.onInsertEvent(ChannelImpl.java
:459)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListene
r(EventSenderImpl.java:583)
at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSen
derImpl.java:291)
at com.bea.wlevs.ede.impl.EventSourceEventSenderImpl.sendInsertEvent(Eve
ntSourceEventSenderImpl.java:85)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendI
nsertEvent(RecordPlaySendEventInterceptor.java:160)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(
EventInspectInterceptor.java:131)
at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsert
Event(MonitorSendEventInterceptor.java:476)
at fr.adp.oep.formation3.DatabaseAdapter.readDatabase(DatabaseAdapter.ja
va:164)
at fr.adp.oep.formation3.DatabaseAdapter.run(DatabaseAdapter.java:90)
at fr.adp.oep.formation3.DatabaseAdapter$$FastClassByCGLIB$$7b8987bf.inv
oke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
at com.bea.wlevs.ede.impl.EventManagerAccessorProxy.invoke(EventManagerA
ccessorProxy.java:30)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
at com.bea.wlevs.ede.impl.EventBeanProxy.invoke(EventBeanProxy.java:38)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:622)
at fr.adp.oep.formation3.DatabaseAdapter$$EnhancerByCGLIB$$553045ce.run(
<generated>)
at com.bea.wlevs.spring.RunnableBeanPostProcessor$RunnableWrapper.run(Ru
nnableBeanPostProcessor.java:117)
at weblogic.work.commonj.CommonjWorkManagerImpl$WorkWithListener.run(Com
monjWorkManagerImpl.java:204)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTunin
gWorkManagerImpl.java:548)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
What is wrong with this ?
Olivier