<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>Steve,</div>
<div><br>
</div>
<div>Rerun this with DEBUG 3 on the LAYER and the generated SQL will show up in your error logs. Then it should show why the generated sql is not valid.</div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
<div>
<div>
<div>
<div>-- </div>
<div>Michael Smith</div>
</div>
<div>Remote Sensing/GIS Center</div>
<div>US Army Corps of Engineers</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, May 19, 2015 at 9:37 AM<br>
<span style="font-weight:bold">To: </span>"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<span style="font-weight:bold">Cc: </span>MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>>, Michael Smith <<a href="mailto:michael.smith@erdc.dren.mil">michael.smith@erdc.dren.mil</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<br>
</div>
<div><br>
</div>
<div>
<div><font size="2" face="sans-serif">Thank you all for this discussion.</font> <br>
<font size="2" face="sans-serif">We had different problems in our use case coming from gdal, mapserv, oracle, ......</font><br>
<font size="2" face="sans-serif">I don't know how gdal should manage this comma issue, but I would like to clarify our problem with mapserv and see if something must be done.</font><br>
<br>
<font size="2" face="sans-serif">Resume</font> <br>
<font size="2" face="sans-serif">- We use MS7.1 with oraclespatial connection</font><br>
<font size="2" face="sans-serif">- gml_type = auto, which returns </font><font size="3" color="#004080" face="sans-serif"><element name="LONG_STAT" minOccurs="0" type="double"/></font><br>
<font size="2" face="sans-serif">- matchCase =true</font> <br>
<font size="2" face="sans-serif">- </font><font size="3" color="#004080" face="sans-serif">LONG_STAT</font><font size="2" face="sans-serif"> = -61,8031</font><br>
<br>
<font size="2" face="sans-serif">The problem is </font><br>
<font size="2" face="sans-serif"><ogc:PropertyIsEqualTo matchCase="true"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61,8031</ogc:Literal></ogc:PropertyIsEqualTo>,
<b>crash with this error</b></font> <br>
<font size="3" color="#004080" face="Calibri"> <ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"></font><br>
<font size="3" color="#004080" face="Calibri"> <ows:ExceptionText>msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed</font><br>
<font size="3" color="#004080" face="Calibri">msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data statement and server logs</ows:ExceptionText></font><br>
<font size="3" color="#004080" face="Calibri"> </ows:Exception></font> <br>
<br>
<font size="2" face="sans-serif">But, using LIKE it Works ...Probably because it "convert" the value as a string</font><br>
<font size="2" face="sans-serif"><ogc:PropertyIsLike matchCase="true" wildCard="*" singleChar="." escapeChar="!"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>*-61,8031*</ogc:Literal></ogc:PropertyIsLike></font><br>
<br>
<font size="2" face="sans-serif">But why ogc:PropertyIsEqualTo is crashing?</font><br>
<br>
<p><br>
<br>
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="40%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="1" face="sans-serif"><b>"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>></b></font>
<p><font size="1" face="sans-serif">2015-05-15 10:05</font> </p>
</td>
<td width="59%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="1" face="sans-serif">"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>>, "Smith, Michael ERDC-RDE-CRREL-NH" <<a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a>></font></td>
</tr>
<tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="1" face="sans-serif">MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>></font></td>
</tr>
<tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="1" face="sans-serif">Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</font></td>
</tr>
</tbody>
</table>
<br>
<table width="393" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
<td width="336" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
</tr>
</tbody>
</table>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<br>
<br>
<font size="3" color="#004080" face="sans-serif">Hi,</font> <br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" color="#004080" face="sans-serif">I think that the real trouble is that with certain database and client settings the numerical data that is stored into Oracle is not interpreted correctly and correct place to fix the issue is somewhere very
close to Oracle. Not in making GML parser to accept commas or to make WFS string comparisons to work correctly with numerical data in Oracle.</font><br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" color="#004080" face="sans-serif">GDAL had similar troubles for sure with Finnish, Italian and French locales and probably with all the other locales using comma as decimal separator as well. In practice it meant for me that GDAL truncated decimal
numbers “1234,56” at comma “1234”. For many years I used some workarounds but after this GDAL fix it has not been necessary any more:</font><br>
<a href="http://trac.osgeo.org/gdal/ticket/5709"><font size="3" color="#004080" face="sans-serif">http://trac.osgeo.org/gdal/ticket/5709</font></a><br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" color="#004080" face="sans-serif">I suggest to study the patch “'OCI: force NLS_NUMERIC_CHARACTERS to ". " (patch by giorgiomugnaini, #5709)'” and consider if it could be applied to the native Oracle driver in Mapserver. I guess and hope that
Mapserver would recognize the datatype correctly if the Oracle layer is configured to read Oracle through OGR and GDAL 2.0 is in use.</font><br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" color="#004080" face="sans-serif">Perhaps setting environment "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. '" locally before starting Mapserver would be enough but I do not know how and where to set it.</font><br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" color="#004080" face="sans-serif">-Jukka Rahkonen-</font> <br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" color="#004080" face="sans-serif"> </font> <br>
<font size="3" face="Tahoma">Steve.Toutant wrote:</font> <br>
<font size="3" face="Times New Roman"> </font> <br>
<font size="3" face="Arial">Is there a documentation that says that it is not?</font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
Folks from gdal list also think that it is not supported...I guess you are right. But as I said on the gdal list, many countries are using a comma as a decimal separator....what other people on the planet do?</font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
Anyway the comma is another problem that I try to manage later......</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
For now, We have an application that generate and launch spatial queries on WFS, matchCase=false by default. Before modifying the code I want to understand what is going on....</font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
It seems,when using numeric value, that matchCase as no impact in PostGIS, but it is important in oracle to be set to true</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
gml_type = auto, returns double in postgis and oracle, so that is fine</font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=<b>false</b></font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
using this value -64<b>.</b>225</font><font size="3" face="Times New Roman"> </font>
<font size="3" face="Arial"><br>
PostGis: it works</font><font size="3" face="Times New Roman"> </font><font size="3" face="Arial"><br>
Oracle (from mike's test): it fails...matchCase must be set to true</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=<b>false</b></font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
using this value -64<b>,</b>225</font><font size="3" face="Times New Roman"> </font>
<font size="3" face="Arial"><br>
PotsGis: not tested <br>
Oracle: it fails...matchCase must be set to true</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
Is there a reason why, with oracle, matchCase should be set to true when using numeric value, or that could be fixed?</font><font size="3" face="Times New Roman"></font><font size="3" face="Arial"><br>
Regards</font><font size="3" face="Times New Roman"> </font><font size="3" face="Arial"><br>
Steve</font><font size="3" face="Times New Roman"> </font></p>
<p><font size="3" face="Times New Roman"><br>
</font></p>
<p>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="36%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial"><b>"Smith, Michael ERDC-RDE-CRREL-NH" <<a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a>></b></font>
<p><font size="3" face="Arial">2015-05-14 09:17</font><font size="3" face="Times New Roman"></font></p>
</td>
<td width="63%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="7%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">A</font></div>
</td>
<td width="92%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>></font><font size="3" face="Times New Roman"></font></td>
</tr>
<tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">cc</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>>, thomas bonfort <<a href="mailto:thomas.bonfort@gmail.com">thomas.bonfort@gmail.com</a>></font><font size="3" face="Times New Roman"></font></td>
</tr>
<tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">Objet</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field</font></td>
</tr>
</tbody>
</table>
<br>
<font size="3" face="Times New Roman"> </font>
<p><br>
<table width="393" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
<td width="336" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
</tr>
</tbody>
</table>
<br>
</p>
</td>
</tr>
</tbody>
</table>
</p>
<p><font size="3" face="Times New Roman"><br>
<br>
<br>
<br>
</font><font size="3" face="sans-serif"><br>
Its not clear to me that commas as the decimal separator is supported in XML/GML. I can't find any documentation to indicate that it is. Can you point some out to me?</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="sans-serif"><br>
In any event, I didn't test with comma decimal separators. </font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="sans-serif"><br>
Mike</font><font size="3" face="Times New Roman"> <br>
</font><font size="3" face="sans-serif"><br>
</font><font size="3" face="Times New Roman"> </font><font size="3" face="sans-serif"><br>
----</font><font size="3" face="Times New Roman"> </font><font size="3" face="sans-serif"><br>
Michael Smith</font><font size="3" face="Times New Roman"> </font><font size="3" face="sans-serif"><br>
US Army Corps</font><font size="3" face="Times New Roman"> </font><font size="3" face="sans-serif"><br>
Remote Sensing GIS/Center</font><font size="3" face="Times New Roman"> </font><font size="3" face="sans-serif"><br>
<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a></font><font size="3" face="Times New Roman">
<br>
<br>
</font><font size="3" face="sans-serif"><b><br>
From: </b>"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="sans-serif">" <</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="sans-serif">><b><br>
Date: </b>Thursday, May 14, 2015 at 8:54 AM<b><br>
To: </b>Michael Smith <</font><a href="mailto:michael.smith@erdc.dren.mil"><font size="3" color="blue" face="sans-serif"><u>michael.smith@erdc.dren.mil</u></font></a><font size="3" face="sans-serif">><b><br>
Cc: </b>MapserverList OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="3" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" face="sans-serif">>, thomas bonfort <</font><a href="mailto:thomas.bonfort@gmail.com"><font size="3" color="blue" face="sans-serif"><u>thomas.bonfort@gmail.com</u></font></a><font size="3" face="sans-serif">><b><br>
Subject: </b>Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
Thanks Mike for having a look at it.</font><font size="3" face="sans-serif"> </font>
<font size="3" face="Arial"><br>
Your decimals are separated by a comma or a dot?</font> </p>
<p><font size="3" face="Times New Roman"> </font> </p>
<p>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="42%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial"><b>"Smith, Michael ERDC-RDE-CRREL-NH" <</b></font><a href="mailto:Michael.Smith@erdc.dren.mil"><font size="3" color="blue" face="Arial"><b><u>Michael.Smith@erdc.dren.mil</u></b></font></a><font size="3" face="Arial"><b>></b></font><font size="3" face="sans-serif"></font>
<p><font size="3" face="Arial">2015-05-13 18:53</font><font size="3" face="sans-serif"></font></p>
</td>
<td width="57%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Times New Roman"> </font>
<p><br>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="6%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">A</font></div>
</td>
<td width="93%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="Arial"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="Arial">" <</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="Arial"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="Arial">>,
thomas bonfort <</font><a href="mailto:thomas.bonfort@gmail.com"><font size="3" color="blue" face="Arial"><u>thomas.bonfort@gmail.com</u></font></a><font size="3" face="Arial">></font><font size="3" face="Times New Roman"></font></td>
</tr>
<tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">cc</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">MapserverList OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="3" color="blue" face="Arial"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" face="Arial">></font><font size="3" face="Times New Roman"></font></td>
</tr>
<tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">Objet</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field</font></td>
</tr>
</tbody>
</table>
<br>
<font size="3" face="Times New Roman"> </font> </p>
<p><br>
<table width="392" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
<td width="336" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
</tr>
</tbody>
</table>
<br>
</p>
</td>
</tr>
</tbody>
</table>
</p>
<p><font size="3" face="sans-serif"><br>
<br>
<br>
<br>
</font><font size="3" face="Arial"><br>
<br>
Steve,</font><font size="3" face="sans-serif"> </font><font size="3" face="Arial"><br>
<br>
I tested this out with 7.1 with numeric type fields and it works for me as long as I don't use matchCase="false". That seems to kick it in to a string comparison. matchCase="true" and just PropertyIsEqualTo work fine.<br>
<br>
In our metadata we use "gml_types" "auto" when the database knows the types and explicit declarations (eg "gml_attributename_type" "integer") when it doesn't work.<br>
<br>
The key is that the field type has to report as a numeric type or the backend treats it as a string comparison.<br>
<br>
Mike</font><font size="3" face="sans-serif"> </font><font size="3" face="Arial"><br>
----</font><font size="3" face="sans-serif"> </font><font size="3" face="Arial"><br>
Michael Smith</font><font size="3" face="sans-serif"> </font><font size="3" face="Arial"><br>
US Army Corps</font><font size="3" face="sans-serif"> </font><font size="3" face="Arial"><br>
Remote Sensing GIS/Center</font><font size="3" face="sans-serif"> </font><font size="3" color="blue" face="Times New Roman"><u><br>
</u></font><a href="mailto:michael.smith@usace.army.mil"><font size="3" color="blue" face="Arial"><u>michael.smith@usace.army.mil</u></font></a><font size="3" face="sans-serif"><br>
<b><br>
<br>
From: </b>"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="sans-serif">" <</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="sans-serif">><b><br>
Date: </b>Wednesday, May 13, 2015 at 10:35 AM<b><br>
To: </b>thomas bonfort <</font><a href="mailto:thomas.bonfort@gmail.com"><font size="3" color="blue" face="sans-serif"><u>thomas.bonfort@gmail.com</u></font></a><font size="3" face="sans-serif">><b><br>
Cc: </b>MapserverList OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="3" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" face="sans-serif">><b><br>
Subject: </b>[EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field<b><br>
Resent-From: </b>Michael Smith <</font><a href="mailto:michael.smith@usace.army.mil"><font size="3" color="blue" face="sans-serif"><u>michael.smith@usace.army.mil</u></font></a><font size="3" face="sans-serif">></font><font size="3" face="Arial"><br>
<br>
Precision: we are using MS7.1<br>
Removing matchcase part makes oracle, and postgis, crash.<br>
I have this error: </font><font size="3" color="#2f2f2f" face="Arial"><br>
<br>
<ows:ExceptionReport xmlns:xsi="</font><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance&sa=D&sntz=1&usg=AFQjCNFERp6A_kcvqihMCKJ7EHX8O14vIA" target="_blank"><font size="3" color="blue" face="Arial"><u>http://www.w3.org/2001/XMLSchema-instance</u></font></a><font size="3" color="#2f2f2f" face="Arial">"
xmlns:ows="</font><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fows&sa=D&sntz=1&usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDow" target="_blank"><font size="3" color="blue" face="Arial"><u>http://www.opengis.net/ows</u></font></a><font size="3" color="#2f2f2f" face="Arial">"
version="1.1.0" language="en-US"xsi:schemaLocation="</font><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fows&sa=D&sntz=1&usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDow" target="_blank"><font size="3" color="blue" face="Arial"><u>http://www.opengis.net/ows<
/a></u></font></a><a href="http://www.google.com/url?q=http%3A%2F%2Fschemas.opengis.net%2Fows%2F1.0.0%2FowsExceptionReport.xsd&sa=D&sntz=1&usg=AFQjCNGmnK6iSrh-cSWEtM2VV17uuSbVNA" target="_blank"><font size="3" color="blue" face="Arial"><u>http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd</u></font></a><font size="3" color="#2f2f2f" face="Arial">"><br>
<ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"><br>
<ows:ExceptionText><br>
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data statement and server logs<br>
</ows:ExceptionText></font><font size="3" face="Arial"> <br>
<br>
<br>
The problem might be the decimals? <br>
Here is the request <br>
<wfs:Query typeName="feature:SMDVDP_STAT_METE" srsName="EPSG:32198"><br>
<ogc:Filter xmlns:ogc="</font><a href="http://www.opengis.net/ogc"><font size="3" color="blue" face="Arial"><u>http://www.opengis.net/ogc</u></font></a><font size="3" face="Arial">"><br>
<ogc:PropertyIsEqualTo> <br>
<ogc:PropertyName>LONG_STAT</ogc:PropertyName><br>
<ogc:Literal><b>-61,8031</b></ogc:Literal><br>
</ogc:PropertyIsEqualTo> <br>
</ogc:Filter> <br>
</wfs:Query> <br>
</wfs:GetFeature> </font></p>
<p><font size="3" face="Times New Roman"> </font> </p>
<p>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="36%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial"><b>thomas bonfort <</b></font><a href="mailto:thomas.bonfort@gmail.com"><font size="3" color="blue" face="Arial"><b><u>thomas.bonfort@gmail.com</u></b></font></a><font size="3" face="Arial"><b>></b></font><font size="3" face="sans-serif"></font>
<p><font size="3" face="Arial">2015-05-13 05:40</font><font size="3" face="Times New Roman"></font></p>
</td>
<td width="63%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Times New Roman"> </font>
<p><br>
<table width="100%" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="5%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">A</font></div>
</td>
<td width="94%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="Arial"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="Times New Roman"></font></td>
</tr>
<tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">cc</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">MapserverList OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="3" color="blue" face="Arial"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" face="Arial">></font><font size="3" face="Times New Roman"></font></td>
</tr>
<tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="3" face="Arial">Objet</font></div>
</td>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<font size="3" face="Arial">Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field</font></td>
</tr>
</tbody>
</table>
<br>
<font size="3" face="Times New Roman"><br>
</font></p>
<p><br>
<table width="391" style="border-collapse:collapse;">
<tbody>
<tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
<td width="335" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td>
</tr>
</tbody>
</table>
<br>
</p>
</td>
</tr>
</tbody>
</table>
</p>
<p><font size="3" face="Arial"><br>
<br>
<br>
<br>
<br>
<br>
<br>
can you try the same request without the "matchCase" part and report<br>
back please?<br>
<br>
On 12 May 2015 at 18:11, <</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue" face="Arial"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3" face="Arial">> wrote:<br>
> I have a problem using a FILTER in a wfs getFeature request on an oracle DB<br>
> with MS7<br>
> When I launch a getFeature request with a Filter on a numeric field it<br>
> doesn't work,<br>
> <ogc:Filter xmlns:ogc="</font><a href="http://www.opengis.net/ogc"><font size="3" color="blue" face="Arial"><u>http://www.opengis.net/ogc</u></font></a><font size="3" face="Arial">"><ogc:PropertyIsEqualTo<br>
> matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter><br>
> here is the error we get in the browser<br>
> <ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"><br>
> <ows:ExceptionText>msWFSGetFeature(): WFS server error.<br>
> FLTApplyFilterToLayer() failed<br>
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data<br>
> statement and server logs</ows:ExceptionText><br>
><br>
> from mapserver logs<br>
> [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.<br>
> String: ([LONG_STAT] =*-61)<br>
><br>
> LONG_STAT is a NUMBER in the DB<br>
> DescribefeatureType returns<br>
> <element name="NO_STAT_CLIM" minOccurs="0" type="string"/><br>
> <element name="NO_STAT_FADQ" minOccurs="0" type="string"/><br>
> <element name="NOM_STAT" minOccurs="0" type="string"/><br>
> <element name="LATI_STAT" minOccurs="0" type="string"/><br>
> <element name="LONG_STAT" minOccurs="0" type="string"/><br>
> <element name="ALTI_STAT" minOccurs="0" type="string"/><br>
><br>
> I tried to add "gml_types" "auto" in the mapfile, but it still returns<br>
> string as data type<br>
> I tried "gml_LONG_STAT_type" = "Integer" in the mapfile, describeFeatureType<br>
> returns "<element name="LONG_STAT" minOccurs="0" type="double"/> " but I<br>
> still get an error in getFeature<br>
><br>
> I'm using CONNECTIONTYPE oraclespatial in the mapfile<br>
><br>
> I can provide more information....<br>
><br>
> Is it a known issue or can I do something about that?<br>
><br>
> Thank you!<br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> </font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="3" color="blue" face="Arial"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" face="Arial"><br>
> </font><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><font size="3" color="blue" face="Arial"><u>http://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></a><font size="3" face="Arial"><br>
</font><font size="3" face="sans-serif"><br>
<br>
<br>
</font><font size="3" face="Times New Roman"><br>
<br>
</font><br>
<br>
<br>
</p>
</div>
</div>
</span>
</body>
</html>