Hi Ivan,
Thanks for the info. So even though
http://jira.codehaus.org/browse/GEOT-2396 states the same issue I don't
think the patch applied there actually fixes the issue. The filter parser is
not set up to handle two functions in this way. And actually the underlying
geotools api will not allow us to create a PropertyIsLike filter in this way
as far as I can tell. So fixing this would take some changes there as well.
However I think you may be may be able to accomplish the same thing with the
"isLike" function. Something like this:
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:Literal>true</ogc:Literal>
<ogc:Function name="isLike">
<ogc:PropertyName>DISTRICT_NAME</ogc:PropertyName>
<ogc:Literal>(i?)SW*</ogc:Literal>
</ogc:Function>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
Let us know if it works. Also feel free to open a new jira about supporting
two functions in a PropertyIsLike. Although it technically would not be
schema valid.
-Justin
On Tue, Sep 28, 2010 at 8:19 AM, Ivan Price <ivan.pr...@acted.org> wrote:
> 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> 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
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
>
--
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
