On 15.12.2015 07:11, Rahkonen Jukka (MML) wrote: > 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.
this works > 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) i get the error. not getting a "no such funtion" means spatialite works right? > 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; yes. DBQuery seems to insist on having the parameter "spatialite=mod_spatialite". seems like it does not enable the autoloading. Larry: any reason for that? ..ede ------------------------------------------------------------------------------ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel