On 02.10.2014 10:39, Rahkonen Jukka (Tike) wrote: > 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. >
does this concern Oj packaging? do you suggest to add/update libs? ..ede ------------------------------------------------------------------------------ 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
