Geoserver 1.6.4b and Oracle

[springrider]

Hello

I just upgrade my configuration with the last release (geoserver1.6.4b) and i can not visualize anymore my layers stored on my oracle database. The creation of the datastore and the featuretypes are ok but not the visualization.
Everything was working fine with 1.6.2 and 1.6.3.

This is the message i got in geoserver.log:

java.sql.SQLException: ORA-00920: invalid relational operator

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
        at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:905)
        at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:627)
        at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:83)
        at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:241)
        at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:211)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1585)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:641)
        at org.geotools.renderer.shape.ShapefileRenderer.renderWithStreamingRenderer(ShapefileRenderer.java:1461)
        at org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:1331)
        at org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:262)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:310)
        at org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:424)
        at org.geoserver.ows.adapters.ResponseAdapter.getMimeType(ResponseAdapter.java:48)
        at org.geoserver.ows.Dispatcher.response(Dispatcher.java:616)
        at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:192)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:170)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
        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:274)
        at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)
2008-05-28 14:10:53,272 ERROR [geotools.rendering] - Could not aquire feature:org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "GEOMETRY" FROM "EEZ_XCNT" WHERE ((TRUE AND TRUE) AND SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-310.1484375,-129.97943496704102,310.1484375,138.40337753295898)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
java.util.NoSuchElementException: Could not aquire feature:org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "GEOMETRY" FROM "EEZ_XCNT" WHERE ((TRUE AND TRUE) AND SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-310.1484375,-129.97943496704102,310.1484375,138.40337753295898)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
        at org.geotools.data.store.NoContentIterator.next(NoContentIterator.java:53)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1599)
        at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:641)
        at org.geotools.renderer.shape.ShapefileRenderer.renderWithStreamingRenderer(ShapefileRenderer.java:1461)
        at org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:1331)
        at org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:262)
        at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:310)
        at org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:424)
        at org.geoserver.ows.adapters.ResponseAdapter.getMimeType(ResponseAdapter.java:48)
        at org.geoserver.ows.Dispatcher.response(Dispatcher.java:616)
        at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:192)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:170)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
        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:274)
        at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "GEOMETRY" FROM "EEZ_XCNT" WHERE ((TRUE AND TRUE) AND SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-310.1484375,-129.97943496704102,310.1484375,138.40337753295898)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
        at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:916)
        at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:627)
        at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:83)
        at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:241)
        at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:211)
        at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1585)
        ... 60 more
Caused by: java.sql.SQLException: ORA-00920: invalid relational operator

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
        at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:905)
        ... 65 more
2008-05-28 14:10:53,274 DEBUG [geotools.rendering] - Style cache hit ratio: NaN , hits 0, requests 0
2008-05-28 14:10:53,274 DEBUG [renderer.shape] - Style cache hit ratio: NaN , hits 0, requests 0
2008-05-28 14:10:53,275 DEBUG [wms.responses] - asking delegate for write to org.geoserver.ows.DispatcherOutputStream@15214b9
2008-05-28 14:10:53,275 DEBUG [map.png] - Writing png image ...
2008-05-28 14:10:53,284 DEBUG [geotools.image] - Encoded input image for png writer
2008-05-28 14:10:53,284 DEBUG [geotools.image] - Getting a writer
2008-05-28 14:10:53,285 DEBUG [geotools.image] - Setting write parameters for this writer
2008-05-28 14:10:53,287 DEBUG [geotools.image] - Writer is NOT native
2008-05-28 14:10:53,288 DEBUG [geotools.image] - About to write png image
2008-05-28 14:10:53,349 INFO [geoserver.filters] - Not compressing output for mimetype: image/png
2008-05-28 14:10:53,603 DEBUG [map.png] - Writing png image ... done!

Thanks

Sylvain

[aaime]

springrider ha scritto:

> Hello
>
> I just upgrade my configuration with the last release (geoserver1.6.4b) and
> i can not visualize anymore my layers stored on my oracle database. The
> creation of the datastore and the featuretypes are ok but not the
> visualization.
> Everything was working fine with 1.6.2 and 1.6.3.
>
> This is the message i got in geoserver.log:
>
> java.sql.SQLException: ORA-00920: invalid relational operator

...
> 2008-05-28 14:10:53,272 ERROR [geotools.rendering] - Could not aquire
> feature:org.geotools.data.DataSourceException: Error Performing SQL query:
> SELECT "GEOMETRY" FROM "EEZ_XCNT" WHERE ((TRUE AND TRUE) AND
> SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-310.1484375,-129.97943496704102,310.1484375,138.40337753295898)),'mask=anyinteract
> querytype=WINDOW') = 'TRUE' )

Eh yes, this has already been reported as
http://jira.codehaus.org/browse/GEOS-1946

Unfortunately I'm booked solid, have no time to investigate it...
Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[springrider]

Hello

I saw that this bug has been fixed. I don't know if it is related but even if it can dispaly my data, i still have weird SQL queries when i extract geographical data from Oracle through Geoserver 1.6.5-beta such as:
[data.jdbc] - SELECT "GEOMETRY" FROM "UN_CONTINENT" WHERE ((1 = 1 AND 1 = 1) AND SDO_RELATE(

This 1=1 seems very weird to me. Is it not a bug?

Thanks

Sylvain
 

aaime wrote:

springrider ha scritto:
> Hello
>
> I just upgrade my configuration with the last release (geoserver1.6.4b) and
> i can not visualize anymore my layers stored on my oracle database. The
> creation of the datastore and the featuretypes are ok but not the
> visualization.
> Everything was working fine with 1.6.2 and 1.6.3.
>
> This is the message i got in geoserver.log:
>
> java.sql.SQLException: ORA-00920: invalid relational operator
...
> 2008-05-28 14:10:53,272 ERROR [geotools.rendering] - Could not aquire
> feature:org.geotools.data.DataSourceException: Error Performing SQL query:
> SELECT "GEOMETRY" FROM "EEZ_XCNT" WHERE ((TRUE AND TRUE) AND
> SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,999999,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-310.1484375,-129.97943496704102,310.1484375,138.40337753295898)),'mask=anyinteract
> querytype=WINDOW') = 'TRUE' )

Eh yes, this has already been reported as
http://jira.codehaus.org/browse/GEOS-1946

Unfortunately I'm booked solid, have no time to investigate it...
Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[aaime]

springrider ha scritto:
> Hello
>
> I saw that this bug has been fixed. I don't know if it is related but even
> if it can dispaly my data, i still have weird SQL queries when i extract
> geographical data from Oracle through Geoserver 1.6.5-beta such as:
> [data.jdbc] - SELECT "GEOMETRY" FROM "UN_CONTINENT" WHERE ((1 = 1 AND 1 = 1)
> AND SDO_RELATE(
>
> This 1=1 seems very weird to me. Is it not a bug?

No, just and oddness. We end up with OGC filters that here and there
do contain Filter.INCLUDE, which means "TRUE", allow every feature to
be included in the output. There is no way to tell where those
Filter.INCLUDE elements are in the filter tree, so we just encode them
as "TRUE" in databases that do support the concept, and "1 = 1" in the
others.

A better way would be to preprocess the filter tree so that those
elements are removed, but we don't have that code today.
If you're interested in having better looking queries I can give you
directions on how to code such a filter simplifier.

Cheers
Andrea

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users