>
Exception in thread "SpringOsgiExtenderThread-126" org.springframework.beans.Fat
alBeanException: Error in context lifecycle initialization; nested exception is
com.bea.wlevs.ede.api.ConfigurationException:
Invalid statement: "alter query >>RiteRouteDetailsQuery<< start"
Description: specified predicate requires full scan of external source which is
not supported
Cause: specified predicate requires full scan of external source which is not su
pported
Action: please modify the join predicate
at com.bea.wlevs.spring.ApplicationContextLifecycle.onApplicationEvent(A
pplicationContextLifecycle.java:146)
at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:97)
at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:324)
at org.springframework.context.support.AbstractApplicationContext.finish
Refresh(AbstractApplicationContext.java:929)
at org.springframework.osgi.context.support.AbstractOsgiBundleApplicatio
nContext.finishRefresh(AbstractOsgiBundleApplicationContext.java:235)
at org.springframework.osgi.context.support.AbstractDelegatedExecutionAp
plicationContext$4.run(AbstractDelegatedExecutionApplicationContext.java:358)
at org.springframework.osgi.util.internal.PrivilegedUtils.executeWithCus
tomTCCL(PrivilegedUtils.java:85)
at org.springframework.osgi.context.support.AbstractDelegatedExecutionAp
plicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext.ja
va:320)
at org.springframework.osgi.extender.internal.dependencies.startup.Depen
dencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaiterAp
plicationContextExecutor.java:136)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.bea.wlevs.ede.api.ConfigurationException:
Invalid statement: "alter query >>RiteRouteDetailsQuery<< start"
Description: specified predicate requires full scan of external source which is
not supported
Cause: specified predicate requires full scan of external source which is not su
pported
Action: please modify the join predicate
at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.activateRules(CQLP
rocessorImpl.java:1041)
at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.activate(CQLProces
sorImpl.java:1084)
at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.afterConfiguration
Active(CQLProcessorImpl.java:2790)
at com.bea.wlevs.spring.ActivationBeanPostProcessor.postProcessAfterCont
extInitialization(ActivationBeanPostProcessor.java:20)
at com.bea.wlevs.spring.DeferredBeanPostProcessor.afterConfigurationActi
ve(DeferredBeanPostProcessor.java:27)
at com.bea.wlevs.spring.ApplicationContextLifecycle.onApplicationEvent(A
pplicationContextLifecycle.java:113)
... 9 more
My Processor code:
<?xml version="1.0" encoding="UTF-8"?>
<wlevs:config xmlns:wlevs="http://www.bea.com/ns/wlevs/config/application">
<processor>
<name>Routematcher</name>
<rules>
<view id="CabDetailsView"><![CDATA[
ISTREAM(SELECT cabNumber, routeName, latitude, longitude, emailId, com.oracle.cep.cartridge.spatial.Geometry.createPoint(8307, latitude, longitude) as geom FROM Cabdetails_Channel )
]]></view>
<query id="RiteRouteDetailsQuery"><![CDATA[
SELECT p.routeName as routeName, p.cabNumber as cabNumber, p.emailId as emailId, com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom) as distance
FROM CabDetailsView [now] as p, RouteCache as s WHERE com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom)<300 ]]></query>
<query id="WrongRouteDetailsQuery"><![CDATA[
SELECT p.routeName as routeName, p.cabNumber as cabNumber, p.emailId as emailId, com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom) as distance
FROM CabDetailsView [now] as p, RouteCache as s WHERE com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom)>300 ]]></query>
</rules>
</processor>
<channel>
<name>RiteRoute_channel</name>
<selector>RiteRouteDetailsQuery</selector>
</channel>
<channel>
<name>WrongRoute_channel</name>
<selector>WrongRouteDetailsQuery</selector>
</channel>
</wlevs:config>