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

Reply via email to