Jukka, would you mind to verify the latest PLUS snapshot works properly wrt. spatialite in lib/native/<x86|x64> ?
thanks.. ede On 18.12.2015 11:54, Rahkonen Jukka (MML) wrote: > 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 > ------------------------------------------------------------------------------ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
