Ede, change into English locale, your envelope has commas as decimal separator.
Jukka ________________________________ Lähettäjä: edgar.sol...@web.de<mailto:edgar.sol...@web.de> Lähetetty: 18.12.2015 12:38 Vastaanottaja: OpenJump develop and use<mailto:jump-pilot-devel@lists.sourceforge.net> Aihe: Re: [JPP-Devel] More success with OJ and Spatialite datastore On 16.12.2015 16:01, edgar.sol...@web.de wrote: > On 16.12.2015 15:57, Rahkonen Jukka (MML) wrote: >> I have still problem with “Run datastore query”. It does work with the >> Spatialite connection for plain SQLite queries “SELECT * from table limit >> 20” but Spatialite functions fail and for example “select >> ST_Centroid(geometry) from my_table” gives >> >> java.lang.Exception: SQL error:null >> >> at >> com.vividsolutions.jump.datastore.spatialite.SpatialiteDSConnection.executeAdhocQuery(SpatialiteDSConnection.java:88) >> > > i had that too. but if you change ST_Centroid to the imaginary non-existing > ST_CentroidX() function the error becomes "non existing function". > so spatialite works. the null error must have some other reason. > put some more effort into this. r4630+ should now work with the dependency jdbc*.jars placed in lib/ext/<folder>/. i checked the build and it seems to work properly for sqlite datastore access but not for oracle. spatialite 4.4.0RC0 is found when placed in lib/native/x86/ on a 32bit windows but when used throws " [SQLITE_ERROR] SQL error or missing database (wrong number of arguments to function st_envIntersects()) Invalid query: SELECT GEOMETRY,OGC_FID,scalerank,featurecla,labelrank,sovereignt,sov_a3,adm0_dif,level,type,admin,adm0_a3,geou_dif,geounit,gu_a3,su_dif,subunit,su_a3,brk_diff,name,name_long,brk_a3,brk_name,brk_group,abbrev,postal,formal_en,formal_fr,note_adm0,note_brk,name_sort,name_alt,mapcolor7,mapcolor8,mapcolor9,mapcolor13,pop_est,gdp_md_est,pop_year,lastcensus,gdp_year,economy,income_grp,wikipedia,fips_10,iso_a2,iso_a3,iso_n3,un_a3,wb_a2,wb_a3,woe_id,adm0_a3_is,adm0_a3_us,adm0_a3_un,adm0_a3_wb,continent,region_un,subregion,region_wb,name_len,long_len,abbrev_len,tiny,homepart FROM ne_110m_admin_0_countries WHERE st_envIntersects(GEOMETRY, -188,004677,-133,064484,188,004677,126,709614) AND (1) " funny enough it worked smoothly in my devel environment w/ spatialite 4.4.0RC0, which somewhat invalidates my first guess "version incompatibility w/ latest spatialite". Jukka, Nico : that's your territory, ideas? ..ede ------------------------------------------------------------------------------ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
