Hi Jukka, I use the library within a web application not a desktop application. At the moment I am developing with NetBeans: I don't find any place where to specify the numeric separator.
However, the faulty code in *mapObj.java:397* is *long cPtr = mapscriptJNI.mapObj_draw(swigCPtr, this);* and *mapscriptJNI* is generated by SWIG, which is a C/C++ wrapper, so the JAVA_OPT is unlikely to be used. Francesco Il giorno gio 27 gen 2022 alle ore 12:13 Rahkonen Jukka (MML) < [email protected]> ha scritto: > 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 <[email protected]> *Puolesta > *Francesco Martinelli > *Lähetetty:* torstai 27. tammikuuta 2022 12.07 > *Vastaanottaja:* MapServer Dev List <[email protected]> > *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 [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-dev
