Hi, Windows binaries for Spatialite v. 4.2.1-RC0 were published a couple of days ago with many new features http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.1.html. I made a quick test with new version and it appeared to be rather easy to use the fresh version with DB Query plugin. Steps which are needed are:
1) Updata sqlite jdbc driver to sqlite-jdbc4-3.8.2-SNAPSHOT.jar or sqlite-jdbc-3.8.5-pre1.jar from https://bitbucket.org/xerial/sqlite-jdbc/downloads 2) Download 32-bit or 64-bit Spatialite binaries from http://www.gaia-gis.it/gaia-sins/windows-bin-x86-test/ or http://www.gaia-gis.it/gaia-sins/windows-bin-amd64-test/ and unzip everything into lib\ext 3) Connect Spatialite database as jdbc:sqlite:/path/to/db/spatialite_database.sqlite?spatialite=mod_spatialite. Congratulations for Larry, it was a good solution to use the SQL method for loading Spatialite extension. String loadSql = "SELECT load_extension('" + extension + "');"; Spatialite binaries are nowadays created in somehow differently than before https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite. The SELECT load_extension() works fine with the new extension module system (mod_spatialite). The alternative method that is used in the Spatialite reader plugin does not work because mod_spatiatile.dll does not behave in the same way than libspatialite.dll used to. This method looks like this in the code. ((JdbcConnection)dbcon).enableLoadExtention(); errmsg = SQLite3.new_p_p_char(); ((JdbcConnection)dbcon).loadExtention("libspatialite-1.dll", null, errmsg); This means that Spatialite v. 4.0 is the latest that can be used with Spatialite reader plugin if Spatialite project will not build also the old style .dll (.so, .dylib) binaries. Another possibility is to fix the plugin to use the SELECT load_extension method. But if someone gets interested in having a look at that, there were some other troubles in the latest available version http://sourceforge.net/projects/jump-pilot/files/OpenJUMP_plugins/Database%20Plugins/SpatialLite_reader_plugin/1.3/spatialliteplugin1.3.zip/download. Michaël made some fixes for that into on unpublished 1.4alpha version and that would be better codebase to start making the fix. -Jukka Rahkonen- ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
