Hi,
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
rem --- uncomment and change your language/country here to overwrite OS locale
setting ---
set JAVA_OPTS=%JAVA_OPTS% -Duser.language=en -Duser.country=EN
-Jukka Rahkonen-
Lähettäjä: MapServer-dev <mapserver-dev-boun...@lists.osgeo.org> Puolesta
Francesco Martinelli
Lähetetty: torstai 27. tammikuuta 2022 12.07
Vastaanottaja: MapServer Dev List <mapserver-dev@lists.osgeo.org>
Aihe: [mapserver-dev] msPostGISLayerWhichShapes() Error : java library set
wrong query
Dear developers,
I have an issue with the java library on the call to mapObj.draw(), of
mapserver 7.6.4, compiled and running on Ubuntu 20.04
Apparently it is "sensible" to the locale which is:
$ localectl
System Locale: LANG=it_IT.UTF-8
VC Keymap: n/a
X11 Layout: it
X11 Model: pc105
$ locale -c decimal_point
LC_NUMERIC
,
$
I already asked the mapserver-users list, but without success.
Here is the code:
mapObj myMap = new mapObj("myMapFile.map");
rectObj originalMapView = myMap.getExtent();
rectObj maxView = new rectObj(-1, -1, -1, -1, myMap.getUnits().swigValue());
maxView.setMinx(originalMapView.getMinx());
maxView.setMaxx(originalMapView.getMaxx());
maxView.setMiny(originalMapView.getMiny());
maxView.setMaxy(originalMapView.getMaxy());
rectObj myView = new rectObj(-1, -1, -1, -1, 3);
myView.setMinx(774076.75);
myView.setMaxx(1014076.75);
myView.setMiny(4875124.5);
myView.setMaxy(5115124.5);
myMap.setExtent(myView);
myMap.setSize(600, 600);
pointObj mousePosition = new pointObj(300, 300, 0);
myMap.zoomPoint(1, mousePosition, 600, 600, myView, maxView);
myMap.draw();
resulting in the error:
java.lang.UnknownError: msDrawMap(): Image handling error. Failed to draw layer
named 'MyLayer'.;msPostGISLayerWhichShapes(): Query error. Error executing
query. Check server logs
edu.umn.gis.mapscript.mapscriptJNI.mapObj_draw(Native Method)
edu.umn.gis.mapscript.mapObj.draw(mapObj.java:397)
and in the ERROR file:
[Wed Jan 26 17:14:19 2022].569532 msPostGISLayerWhichShapes(): Error (ERROR:
parse error - invalid geometry
HINT: "POLYGON((774076,75" <-- parse error at position 18 within geometry
) 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('POLYGON((774076,75 4875124,5,774076,75 5115124,5,1014076,75
5115124,5,1014076,75 4875124,5,774076,75
4875124,5))',find_srid('','classi_comuni','the_geom'))
As far as I understand the correct query should be (in red the changes):
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('POLYGON((774076.75
4875124.5,774076.75 5115124.5,1014076.75 5115124.5,1014076.75
4875124.5,774076.75 4875124.5))',find_srid('','classi_comuni','the_geom'))
I think the following parameters in mapfile could be of interest to you:
CONFIG "MS_ERRORFILE" "myfile"
DEBUG 6
...
LAYER
CONNECTIONTYPE postgis
DATA "the_geom FROM (SELECT * FROM classi_comuni WHERE tipo_area = 2
ORDER BY tipo_area DESC) AS confini USING UNIQUE gid"
CLASSITEM "my_column"
...
Please could you help?
Thank you,
Francesco
_______________________________________________
MapServer-dev mailing list
MapServer-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-dev
