<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;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
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 style="mso-fareast-language:EN-US">Hi,<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 lang="EN-US" style="mso-fareast-language:EN-US">I wonder if it could be related to which locale Java detects on your computer – Italian (or Finnish) computer -> comma as a separator. Maybe something that deals around the same thing
<a href="https://stackoverflow.com/questions/4713166/decimal-separator-in-numberformat">
https://stackoverflow.com/questions/4713166/decimal-separator-in-numberformat</a>.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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-users <mapserver-users-bounces@lists.osgeo.org>
<b>Puolesta </b>Francesco Martinelli<br>
<b>Lähetetty:</b> keskiviikko 26. tammikuuta 2022 19.00<br>
<b>Vastaanottaja:</b> mapserver-users@lists.osgeo.org<br>
<b>Aihe:</b> [mapserver-users] 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">Hi all,<o:p></o:p></p>
</div>
<p class="MsoNormal">I have a java program calling the method draw() of class edu.umn.gis.mapscript.mapObj<o:p></o:p></p>
<div>
<p class="MsoNormal">after I compiled mapserver 7.6.4 on Ubuntu 20.04<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The result produce the following error:<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)<br>
<br clear="all">
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">In mapfile I set the parameters:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><b>CONFIG</b> "MS_ERRORFILE" "myfile"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><b>DEBUG</b> 6<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><b>LAYER</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <b>CONNECTIONTYPE</b> postgis<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"> <b>DATA</b> "the_geom FROM (SELECT * FROM classi_comuni WHERE tipo_area = 2 ORDER BY tipo_area DESC) AS confini USING UNIQUE gid"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <b>CLASSITEM</b> "my_column"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">...<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal">and in the error file I got the following message:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[Wed Jan 26 17:14:19 2022].558530 msDrawMap(): rendering using outputformat named png24 (AGG/PNG).<br>
[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'))<br>
[Wed Jan 26 17:14:19 2022].569545 msPostGISLayerWhichShapes(): Query error. Error executing query. Check server logs<br>
[Wed Jan 26 17:14:19 2022].569605 msDrawMap(): Image handling error. Failed to draw layer named 'MyLayer'.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I checked the error is caused by decimal separators being commas instead of dots.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">As far as I understand the correct query would be (in <b><span style="color:black;background:red">red</span></b> the changes):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I think I should set something during the compilation of java mapserver library.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Please can someone drive me on how to solve it?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><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>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>