<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.Shkpostityyli18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 70.85pt 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FI" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Have you considered to change the locale with your own code as first aid? I do not know how to do that but some desktop application seems to do that with Java options<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">rem --- uncomment and change your language/country here to overwrite OS locale setting ---<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">set JAVA_OPTS=%JAVA_OPTS% -Duser.language=en -Duser.country=EN<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Lähettäjä:</b> MapServer-dev <mapserver-dev-bounces@lists.osgeo.org>
<b>Puolesta </b>Francesco Martinelli<br>
<b>Lähetetty:</b> torstai 27. tammikuuta 2022 12.07<br>
<b>Vastaanottaja:</b> MapServer Dev List <mapserver-dev@lists.osgeo.org><br>
<b>Aihe:</b> [mapserver-dev] msPostGISLayerWhichShapes() Error : java library set wrong query<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Dear developers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I have an issue with the java library on the call to <b>mapObj.draw()</b>, of
<b>mapserver 7.6.4</b>, compiled and running on Ubuntu 20.04<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Apparently it is "sensible" to the locale which is:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">$ localectl<br>
System Locale: LANG=it_IT.UTF-8<br>
VC Keymap: n/a<br>
X11 Layout: it<br>
X11 Model: pc105<br>
$ locale -c decimal_point<br>
LC_NUMERIC<br>
,<br>
$<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I already asked the mapserver-users list, but without success.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><b>Here is the code</b>:<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"> mapObj myMap = new mapObj("myMapFile.map");<br>
rectObj originalMapView = myMap.getExtent();<br>
<br>
rectObj maxView = new rectObj(-1, -1, -1, -1, myMap.getUnits().swigValue());<br>
maxView.setMinx(originalMapView.getMinx());<br>
maxView.setMaxx(originalMapView.getMaxx());<br>
maxView.setMiny(originalMapView.getMiny());<br>
maxView.setMaxy(originalMapView.getMaxy());<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"> rectObj myView = new rectObj(-1, -1, -1, -1, 3);<br>
myView.setMinx(<b>774076.75</b>);<br>
myView.setMaxx(<b>1014076.75</b>);<br>
myView.setMiny(<b>4875124.5</b>);<br>
myView.setMaxy(<b>5115124.5</b>);<o:p></o:p></p>
</div>
<p class="MsoNormal"> myMap.setExtent(myView);<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"> myMap.setSize(600, 600);<br>
<br>
pointObj mousePosition = new pointObj(300, 300, 0);<br>
myMap.zoomPoint(1, mousePosition, 600, 600, myView, maxView);<o:p></o:p></p>
</div>
<p class="MsoNormal"> myMap.draw();<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><b>resulting in the error</b>:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><b>java.lang.UnknownError: msDrawMap():</b> Image handling error. Failed to draw layer named 'MyLayer'.;<b>msPostGISLayerWhichShapes(): Query error</b>. Error executing query. Check server logs<br>
edu.umn.gis.mapscript.mapscriptJNI.mapObj_draw(Native Method)<br>
edu.umn.gis.mapscript.mapObj.draw(mapObj.java:397)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><b>and in the ERROR file</b>:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[Wed Jan 26 17:14:19 2022].569532 msPostGISLayerWhichShapes(): Error (ERROR: parse error - invalid geometry<br>
HINT: "POLYGON((774076,75" <-- parse error at position 18 within geometry<br>
) executing query: select "my_column"::text,ST_AsBinary(("the_geom"),'NDR') as geom,"gid"::text from (SELECT * FROM classi_comuni WHERE tipo_area = 2 ORDER BY tipo_area DESC) AS confini where "the_geom" && ST_GeomFromText('<b>POLYGON((774076,75 4875124,5,774076,75
5115124,5,1014076,75 5115124,5,1014076,75 4875124,5,774076,75 4875124,5))</b>',find_srid('','classi_comuni','the_geom'))<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">As far as I understand the correct query should be (in
<b><span style="color:black;background:red">red</span></b> the changes):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">select "my_column"::text,ST_AsBinary(("the_geom"),'NDR') as geom,"gid"::text from (SELECT * FROM classi_comuni WHERE tipo_area = 2 ORDER BY tipo_area DESC) AS confini where "the_geom"
&& ST_GeomFromText('<b>POLYGON((774076<span style="color:black;background:red">.</span>75 4875124<span style="color:black;background:red">.</span>5,774076<span style="color:black;background:red">.</span>75 5115124<span style="color:black;background:red">.</span>5,1014076<span style="color:black;background:red">.</span>75
5115124<span style="color:black;background:red">.</span>5,1014076<span style="color:black;background:red">.</span>75 4875124.5,774076<span style="color:black;background:red">.</span>75 4875124<span style="color:black;background:red">.</span>5</b>))',find_srid('','classi_comuni','the_geom'))<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal">I think the following parameters in mapfile could be of interest to you:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> CONFIG "MS_ERRORFILE" "myfile"<br>
DEBUG 6<br>
...<br>
LAYER<br>
CONNECTIONTYPE postgis<br>
DATA "the_geom FROM (SELECT * FROM classi_comuni WHERE tipo_area = 2 ORDER BY tipo_area DESC) AS confini USING UNIQUE gid"<br>
CLASSITEM "my_column"<br>
...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Please could you help?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Francesco<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>