Re: [JPP-Devel] More success with OJ and Spatialite datastore

2015-12-18 Thread edgar . soldin
: 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> &g

Re: [JPP-Devel] More success with OJ and Spatialite datastore

2015-12-18 Thread edgar . soldin
: 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 O

Re: [JPP-Devel] More success with OJ and Spatialite datastore

2015-12-18 Thread Rahkonen Jukka (MML)
forge.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 connecti

Re: [JPP-Devel] More success with OJ and Spatialite datastore

2015-12-18 Thread edgar . soldin
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 ex

[JPP-Devel] More success with OJ and Spatialite datastore

2015-12-16 Thread Rahkonen Jukka (MML)
Hi, This time I placed all the dll files into \lib and now connection seems to use mod_spatialite (Windows 7, Java 1.8.0_60 32-bit). I can verify that Spatialite is used by adding a WHERE filter like "ST_Area(geometry)>1000". OJ log also shows that every request is made with ST_EnvIntersect

Re: [JPP-Devel] More success with OJ and Spatialite datastore

2015-12-16 Thread edgar . soldin
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”