You can test if Spatialite is available by using some Spatialite function in
the "where" box of the connection, for example
[where] ST_Area(geometry)>2
The ne_110m_admin_0_countries layer should have 153 rows now. For me the count
is 0 but log file does not report any error.
Another way to test if to use Run datastore query.
select ST_Centroid(geometry) from ne_110m_admin_0_countries;
gives
ava.lang.Exception: SQL error:null
at
com.vividsolutions.jump.datastore.spatialite.SpatialiteDSConnection.executeAdhocQuery(SpatialiteDSConnection.java:88)
at
com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection.execute(SpatialDatabasesDSConnection.java:63)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayer(RunDatastoreQueryPlugIn.java:77)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayerable(RunDatastoreQueryPlugIn.java:41)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLayerPlugIn.run(AbstractAddDatastoreLayerPlugIn.java:33)
at
com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:152)
at java.lang.Thread.run(Unknown Source)
You can compare with DB Query by using connection string like
jdbc:sqlite:/c:\data\ne_countries.sqlite?spatialite=mod_spatialite
and running the same
select ST_Centroid(geometry) from ne_110m_admin_0_countries;
-Jukka-
-----Alkuperäinen viesti-----
Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de]
Lähetetty: 15. joulukuuta 2015 0:53
Vastaanottaja: OpenJump develop and use
Kopio: Nicolas Ribot
Aihe: Re: [JPP-Devel] Adding other spatial databases support in OJ core
ok, loading the dataset works.
Nico: why can't i modify my request via 'layer name context menu/Database/Edit
Query'?
Jukka&Nico: how can i check if spatialite is working?
..ede
On 14.12.2015 22:59, Rahkonen Jukka (MML) wrote:
> Hi,
>
> The latest ones are these:
> http://www.gaia-gis.it/gaia-sins/windows-bin-x86-test/mod_spatialite-4
> .4.0-RC0-win-x86.7z
> http://www.gaia-gis.it/gaia-sins/windows-bin-amd64-test/mod_spatialite
> -4.4.0-RC0-win-amd64.7z
>
> The list of the SQL functions of this version is at
> http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.4.0.html
>
> Linux users are supposed to build from sources. These Windows binaries
> are very, very fresh because Sandro announced those fixed packages
> about 40 minutes ago. I tested both packages with DB Query plugin and
> they are OK. Unzip everything from either 32-bit or 64-bit package
> into lib/ext and give connection string as
> jdbc:sqlite:/c:/path/to/some_db.sqlite?spatialite=mod_spatialite
>
> You will see an error if mod_spatialite can't be loaded. Further test
> is to make some query which requires Spatialite like SELECT
> ST_Centroid(geometry) from...
>
> I guess you will try to move the dll files into some special directory,
> perhaps under lib/native/...
> Good luck with it. I have spent sometimes quite many hours with that with
> poor success but I do not remember how it failed. Probably I managed to make
> OJ to load the right mod_spatialite (32-bit from 32-bit jre and 64-bit from
> 64-bit jre) but mod_spatialite did not find right versions of the dll files.
> May be that the error was in some other place. You are for sure better than
> me in that play. Anyway, it will work if mod_spatialite and all the other dll
> files are in \lib\ext.
>
> If you plan to test with the datastore plugin it requires that SQLite jdbc
> driver is in /lib. I saw from the source code that it really tries to execute
> SELECT load_extension('mod_spatialite') but I can't find any traces of that
> from the OJ log.
>
> -Jukka-
>
>
> edgar soldin wrote:
>
> On 14.12.2015 14:33, Rahkonen Jukka (MML) wrote:
>> I will give a better example once I have managed to make the brand new
>> SpatiaLite v. 4.4.0 version to work with OpenJUMP. The RC0 was published
>> today but it seems to miss some dependencies.
>
> Jukka,
>
> what is the latest libspatialite version and where can i download it?
> http://www.gaia-gis.it/gaia-sins/windows-bin-x86/ gives me a 403 error.
>
> if you have it you might just attach the windows x86 version to the reply for
> me please.
>
> ..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
------------------------------------------------------------------------------
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
