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
