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. ..ede ------------------------------------------------------------------------------ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel