Great research, Jukka. Looks like you are almost ready to submit a
patch :-) . Reading the link you sent, the SQLiteConfig must be used
at the time the connection is first set up, so it will require a bit
more setup in the plugin, but it doesn't look too bad. My time to
work on OJ is limited, but let me see what I can get done in the next
few days.
-lreeder
On Fri, Mar 15, 2013 at 7:45 AM, Rahkonen Jukka
<[email protected]> wrote:
> This is mostly for Larry.
>
> I was reading this document by Alessandro Furieri
> http://www.gaia-gis.it/spatialite-2.4.0-4/splite-jdbc.html
>
> I downloaded fresh Spatialite 4.0 dll files and tried to follow the document
> and finally I managed to compile the sample java program so that it loads and
> uses current Spatialite stuff. All dll files which are tested to suit
> together and java code in in this zip file
> http://latuviitta.org/documents/Spatialite_4.0_test_with_jre_1.6.zip
>
> I also learned that it is enough to have a plain SQLite connection with the
> database first. Spatialite extencion can be loaded afterwards with SQL.
> Theoretically DB Query Plugin could support all Spatialite stuff if user just
> has all the Spatialite binaries, puts them all to a directory where OS finds
> them and loads the extension by sending SQL with DB Query Plugin as
> SELECT load_extension('path_to\spatialite-4.dll')
>
> However, SQLite does not allow loading extensions by default and that is also
> the case with DB Query Plugin. I believe that it would be possible to
> activate this possibility by editing file JumpSpatialiteDbQuery.java.
> The code is now
>
> @Override
> public FeatureCollection getCollection(String query, int maxFeatures)
> throws Exception
> {
> Connection connection = getConnection();
> FeatureCollection featureCollection = null;
>
> It should be possible to load Spatialite extension later with SQL if couple
> of lines were added:
> SQLiteConfig config = new SQLiteConfig();
> config.enableLoadExtension(true);
>
>
> This snippet shows how the Spatialite sample program (included in my dll
> package) creates a connection to allow extension loading.
>
>
> Connection conn = null;
> try
> {
> // enabling dynamic extension loading
> // absolutely required by SpatiaLite
> SQLiteConfig config = new SQLiteConfig();
> config.enableLoadExtension(true);
>
> // create a database connection
> conn = DriverManager.getConnection("jdbc:sqlite:spatialite.sample",
> config.toProperties());
> Statement stmt = conn.createStatement();
> stmt.setQueryTimeout(30); // set timeout to 30 sec.
>
> -Jukka Rahkonen-
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Jump-pilot-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
