Re: [Geoserver-users] case insensitive LIKE filter..

Tue, 28 Sep 2010 07:23:18 -0700

Hey Justin, certainly.. the layer is an oracle (XE) table, the store being a normal oracle store (NG). I notice my stack trace says '65 more' which may be useful to you, but i'm not sure how to get the rest outputted. 

let me know if theres anything further i can provide.

cheers,

-i
java.lang.RuntimeException: Parsing failed for PropertyIsLike: java.lang.NullPointerException 
    at org.geotools.xml.impl.ParseExecutor.visit(ParseExecutor.java:158)
at org.geotools.xml.impl.BindingWalker$BindingExecutionChain.execute(BindingWalker.java:215) 
    at org.geotools.xml.impl.BindingWalker.walk(BindingWalker.java:181)
at org.geotools.xml.impl.ElementHandlerImpl.endElement(ElementHandlerImpl.java:222) at org.geotools.xml.impl.ParserHandler.endElement(ParserHandler.java:607) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) 
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
    at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    at org.geotools.xml.Parser.parse(Parser.java:223)
    at org.geoserver.wfs.xml.v1_1_0.WfsXmlReader.read(WfsXmlReader.java:91)
    at org.geoserver.ows.Dispatcher.parseRequestXML(Dispatcher.java:1180)
    at org.geoserver.ows.Dispatcher.dispatch(Dispatcher.java:466)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:227) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) 
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
    at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
    at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
    at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.geotools.filter.v1_0.OGCPropertyIsLikeTypeBinding.parse(OGCPropertyIsLikeTypeBinding.java:107) 
    at org.geotools.xml.impl.ParseExecutor.visit(ParseExecutor.java:149)
    ... 65 more




On 28/09/10 3:58 PM, Justin Deoliveira wrote:

Hi ivan,
Can you include the full stack trace? Also what type of layer is this being used against? Shapefile or database or ... ? Thanks. 

-Justin
On Mon, Sep 27, 2010 at 9:30 AM, Ivan Price <ivan.pr...@acted.org <mailto:ivan.pr...@acted.org>> wrote: 


    Hi there,

    I'm trying to implement a case insenstive LIKE filter by applying the
    "strToUpperCase" function to my Literal like this:

    <wfs:GetFeature service="WFS" version="1.1.0"
    xsi:schemaLocation="http://www.opengis.net/wfs
    http://schemas.opengis.net/wfs/1.1.0/wfs.xsd";>
    <wfs:Query typeName=store:VILLAGES">
    <ogc:Filter>
    <ogc:PropertyIsLike wildCard="*" singleChar="." escape="!">
    <ogc:Function name="strToUpperCase">
    <ogc:PropertyName>DISTRICT_NAME</ogc:PropertyName>
    </ogc:Function>
    <ogc:Function name="strToUpperCase">
    <ogc:Literal>SW*</ogc:Literal>
    </ogc:Function>
    </ogc:PropertyIsLike>
    </ogc:Filter>
    </wfs:Query>
    </wfs:GetFeature>

    but am getting a null pointer exception:

    java.lang.RuntimeException: Parsing failed for PropertyIsLike:
    java.lang.NullPointerException
    Parsing failed for PropertyIsLike: java.lang.NullPointerException
    null

    i'm guessing as described here:
    http://jira.codehaus.org/browse/GEOT-2396

    i note that the above bug was reported as being fixed in geotools a
    while ago, but the problem seems to still exist for me in
    geoserver.  am
    i doing something wrong here, or is it coming in future geoserver
    releases ?

    i'm using geoserver 2.0.2.

    thanks very much for everything as always,

    -ivan

    ACTED.org







    
------------------------------------------------------------------------------
    Start uncovering the many advantages of virtual appliances
    and start using them to simplify application deployment and
    accelerate your shift to cloud computing.
    http://p.sf.net/sfu/novell-sfdev2dev
    _______________________________________________
    Geoserver-users mailing list
    Geoserver-users@lists.sourceforge.net
    <mailto:Geoserver-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/geoserver-users




--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.


------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to