On 25.10.2018 08:55, Martin Zeller wrote:
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...
Same problem with geoserver 2.13.3
_______________________________________________
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
