sweet. how do you manage the native libs? are they installed automatically to
somewhere appropriate by some installer and found by the jre?
..ede
On 07.04.2013 19:22, Larry Reeder wrote:
> I added the ability to load spatialite DLLs, and thus use Spatialite
> functions, to the Jump DB Query plugin . Instead of calling SELECT
> load_extension('path_to\
> spatialite-4.dll'), you need to append "?spatialite=/path/to/spatialite.dll"
> to the JDBC URL path in the dbquery properties file. Its written up in
> slightly more detail here:
>
> https://sourceforge.net/p/jumpdbqplugin/wiki/Documentation/
>
> If you don't append the Spatialite DLL path to the JDBC url, or loading the
> Spatialite library fails, the plugin will behave as before. You'll be able
> to load features from the database, but won't be able to use Spatialite
> functions.
>
> I recommend installing SQLite first and making sure you can load spatialite
> DLLs from SQLite before trying it in the plugin. Tested on Windows and
> LInux, but not Mac.
>
> -lreeder
>
>
> On Sun, Mar 17, 2013 at 11:44 AM, Rahkonen Jukka <jukka.rahko...@mmmtike.fi
> <mailto:jukka.rahko...@mmmtike.fi>> wrote:
>
> 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 <mailto: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
> <mailto: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
> <mailto: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
> <mailto:Jump-pilot-devel@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
>
>
> ------------------------------------------------------------------------------
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
>
>
>
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
