Hi, we use geoserver 2.14.0 with oracle and postgis. A postgis getfeature request with filter works: http://xxx:8080/geoserver/wfs?&REQUEST=getFeature&Typename=xxx:xxxxx_postgis&Version=1.0.0&service=WFS&PROPERTYNAME=name&filter=<ogc:Filter xmlns:ogc="http://ogc.org"; xmlns:gml="http://www.opengis.net/gml";><And><ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'><ogc:PropertyName>name</ogc:PropertyName><ogc:Literal>**</ogc:Literal></ogc:PropertyIsLike></And></ogc:Filter>
Whereas a similar request to an oracle store doesn't work: http://xxx:8080/geoserver_read/wfs?&REQUEST=getFeature&Typename=xxx:xxxx_oracle&Version=1.0.0&service=WFS&filter=<ogc:Filter xmlns:ogc="http://ogc.org"; xmlns:gml="http://www.opengis.net/gml";><And><ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'><ogc:PropertyName>NAME</ogc:PropertyName><ogc:Literal>Wien*</ogc:Literal></ogc:PropertyIsLike></And></ogc:Filter> This request results in an exception: java.io.IOException: Error occured calculating bounds for xxxx_oracle ORA-00907: missing right parenthesis Excerpt from the log file: Please note the problem in the resulting sql statement: ...FROM gisdb.xxxx_oracleWHERE... What's the problem? Thanks Martin -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
