I have a problem using a FILTER in a wfs getFeature request on an oracle
DB with MS7
When I launch a getFeature request with a Filter on a numeric field it
doesn't work,
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc";><ogc:PropertyIsEqualTo
matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter>
here is the error we get in the browser
<ows:Exception exceptionCode="NoApplicableCode" locator="mapserv">
<ows:ExceptionText>msWFSGetFeature(): WFS server error.
FLTApplyFilterToLayer() failed
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
statement and server logs</ows:ExceptionText>
from mapserver logs
[Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
String: ([LONG_STAT] =*-61)
LONG_STAT is a NUMBER in the DB
DescribefeatureType returns
<element name="NO_STAT_CLIM" minOccurs="0" type="string"/>
<element name="NO_STAT_FADQ" minOccurs="0" type="string"/>
<element name="NOM_STAT" minOccurs="0" type="string"/>
<element name="LATI_STAT" minOccurs="0" type="string"/>
<element name="LONG_STAT" minOccurs="0" type="string"/>
<element name="ALTI_STAT" minOccurs="0" type="string"/>
I tried to add "gml_types" "auto" in the mapfile, but it still returns
string as data type
I tried "gml_LONG_STAT_type" = "Integer" in the mapfile,
describeFeatureType returns "<element name="LONG_STAT" minOccurs="0"
type="double"/> " but I still get an error in getFeature
I'm using CONNECTIONTYPE oraclespatial in the mapfile
I can provide more information....
Is it a known issue or can I do something about that?
Thank you!_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
