edgar soldin wrote:
> just assumed because of
> https://sourceforge.net/p/jump-pilot/code/HEAD/tree/core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDataStoreDriver.java#l69
> "new SQLiteConfig().enableLoadExtension(true);"
> but obviously this just autoloads the sqlite nativ
Yes, that's a good idea, Ede. I'll try out the newer SQLite jars.
-lreeder
On Wed, Dec 16, 2015 at 4:28 AM, wrote:
> hey Larry,
>
> when you fix up DBQuery would it make sense to update the libs? i see
> there is at least a new
>
> sqlite-jdbc-3.8.11.2.jar
>
> out there.
>
> ..ede
>
>
---
I think you guys have figured this out, more details if not:
DBQuery requires "spatialite=mod_spatialite" because this tells the SQLite
drivers to load the spatialite extensions. I didn't want to hardcode the
string "mod_spatialite" in case the Spatialite author changed the name of
the shared lib
On 16.12.2015 16:44, Rahkonen Jukka (MML) wrote:
> Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de]
>
>
>> issue with the sqlite extension libs seems to be that they are loaded by
>> sqlite itself. all _we've_ got is the
>> sqlite jdbc that seems to have a config switch to turn on
Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de]
> issue with the sqlite extension libs seems to be that they are loaded by
> sqlite itself. all _we've_ got is the
> sqlite jdbc that seems to have a config switch to turn on autoloading *OR*
> the SELECT load_extension(...);
> *OR
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
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”
Revision: 4629
http://sourceforge.net/p/jump-pilot/code/4629
Author: edso
Date: 2015-12-16 12:15:55 + (Wed, 16 Dec 2015)
Log Message:
---
some reformatting
fix datastore connection copy for sqlite
Modified Paths:
--
core/trunk/src/com/vividsolutions/jum
hey Jukka,
On 16.12.2015 09:34, Rahkonen Jukka (MML) wrote:
> Hi,
>
> I have nothing at all to complain and I think that you managed to add the
> SQLite/Spatialite datastore very quickly. It just appears that in my Windows
> environment the mod_spatialite extension is not found if I put all the
hey Larry,
when you fix up DBQuery would it make sense to update the libs? i see there is
at least a new
sqlite-jdbc-3.8.11.2.jar
out there.
..ede
--
___
Jump-pilot-devel
On 15.12.2015 18:54, Alberto De Luca wrote:
> Hi there.
>
> I've added today the capability to save the raster symbology in the OpenJUMP
> project file. I'd like to ask you a couple of things though:
> - is it too late to add it now? I'm not sure, but I might have read in some
> posts that the f
Hi,
I have nothing at all to complain and I think that you managed to add the
SQLite/Spatialite datastore very quickly. It just appears that in my Windows
environment the mod_spatialite extension is not found if I put all the dll
files into lib\ext which was the only place where I could make th
12 matches
Mail list logo
