Hi, Whatever you do, as a user I would absolutely like to keep also the current mode which is perhaps limited but robust. The libspatialite-4.dll seems to be dependent on 9 other dlls and from my experience it feels sure that some day there will be some odd dll version missmatch in the system.
-Jukka- ________________________________________ Larry Reeder wrote: > 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 > <jukka.rahko...@mmmtike.fi> 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 > Jump-pilot-devel@lists.sourceforge.net > 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 Jump-pilot-devel@lists.sourceforge.net 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 Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
