Re: [Geoserver-users] SpatiaLite extension in Windows 2008 R2 64-bit

Rahkonen Jukka (Tike) Sat, 20 Sep 2014 03:03:07 -0700

Hi,

Because I do not program anything I just collect some links which I suppose to 
be relavant

https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite
http://www.sqlite.org/loadext.html and
http://www.sqlite.org/c3ref/load_extension.html

Older way to use Spatialite was probably based on this
http://www.sqlite.org/amalgamation.html

I saw references to PHP
https://groups.google.com/forum/#!topic/spatialite-users/Bks_1cTu6KE, Android
http://nutiteq.com and C#. I am rather sure that it is used also from python.
Load_extension does not guarantee that everything works. Spatialite is
utilizing basic features of sqlite and if mod_spatialite is called from old
sqlite version some functions may not work. Xerial driver is a good example,
release versions do not suffice.

-Jukka Rahkonen-

Justin Deoliveira wrote:

Interesting. Have you tried this out on other platforms? From what I can
remember the issue I had with this approach was that the internal sqlite used
by the xerial driver conflicted with the version of sqlite compiled into
libspatialite. But if I follow this correctly "mod_spatialite" is just the
spatialite component. If so that should work just fine!

On Fri, Sep 19, 2014 at 3:20 PM, Rahkonen Jukka (Tike)
<jukka.rahko...@mmmtike.fi<mailto:jukka.rahko...@mmmtike.fi>> wrote:
Hi,

Spatialite is loaded runtime as sqlite extension. What gets loaded is
mod_spatialite and it must find all the depencies from the bunch of dll files.
Sqlite must be compiled to support loading of extensions and in xerial driver
it is.
-Jukka-
________________________________
Lähettäjä: Justin Deoliveira<mailto:jdeol...@boundlessgeo.com>
Lähetetty: ‎20.‎9.‎2014 0:08
Vastaanottaja: Rahkonen Jukka (Tike)<mailto:jukka.rahko...@mmmtike.fi>
Kopio: Pedro Briones Garcia<mailto:p...@tragsa.es>;
geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>
Aihe: Re: [Geoserver-users] SpatiaLite extension in Windows 2008 R2 64-bit
Hey Jukka,

I am interested to find out more. How is it that spatialite gets loaded when
using the plain sqlite xerial driver?

On Thu, Sep 18, 2014 at 8:22 AM, Rahkonen Jukka (Tike)
<jukka.rahko...@mmmtike.fi<mailto:jukka.rahko...@mmmtike.fi>> wrote:
Hi,

I do not know anything about compiling but if it helps, I have been using with
good success this Win-64 binary package
http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/mod_spatialite-4.2.0-win-amd64.7z
with sqlite-jdbc4-3.8.2-SNAPSHOT.jar from
https://bitbucket.org/xerial/sqlite-jdbc/downloads
on OpenJUMP running on both Oracle and OpenJDK 64-bit jre. . Older jdbc drivers
do not work. I have not tried sqlite-jdbc-3.8.5-pre1.jar.
BTW. Sandro is planning to release Spatialite 4.2.1 soon, perhaps next week.

I do not know if there is any reason to use OpenJDK but an easy way for
getting a 64-bit version for Windows is to download gvSIG-CE from
http://sourceforge.net/projects/gvsigce/files/latest/download.

-Jukka Rahkonen-

Justin Deoliveira wrote:
Unfortunately there is no current solution for Windows 64 bit. I couldn't
figure out how to get a proper working Windows 64 bit compiler so I eventually
gave up on that platform. What is needed is for someone to compile all the
necessary libraries on that platform. The project that builds out everything is
here:

https://bitbucket.org/jdeolive/sqlite-jdbc/

2014-09-18 7:36 GMT-06:00 Pedro Briones Garcia
<p...@tragsa.es<mailto:p...@tragsa.es>>:
Hello everyone.

Can anyone tell me if it is possible to use the SpatiaLite extension in
GeoServer in a Windows Server 2008 R2 64-bit server with TomCat?

When I install this extension, only one option is shown: spatialite (JNDI)
connection

Is there any workaround to make it work?

Thanks in advance.

Un saludo

[http://www.tragsa.es/SiteCollectionImages/Relaciones%20Institucionales%20(Prensa)/FIRMA%20OUTLOOK/Tragsatec.png]

[http://www.tragsa.es/SiteCollectionImages/Relaciones%20Institucionales%20(Prensa)/FIRMA%20OUTLOOK/cenefa.png]

Pedro Briones Garcia
Jefe de Grupo de Actuaciones y Proyectos
Gerencia de Sistemas de Información Geográfica
Grupo Tragsa - SEPI

[http://www.tragsa.es/SiteCollectionImages/Relaciones%20Institucionales%20(Prensa)/FIRMA%20OUTLOOK/Tragsatec_SEPI.png]

Calle Julián Camarillo 6 B - 28037 Madrid
Tel.: 913226489 - 88216 - Fax: 913226005
p...@tragsa.es <mailto:p...@tragsa.es> www.tragsa.es <http://www.tragsa.es/>

En beneficio del medio ambiente, imprime este e-mail sólo si realmente es
necesario
For the benefit of the environment, print this e-mail only if you really need

________________________________
**********************************************************************************************
El consumo de papel es perjudicial para el medio ambiente. Por favor, téngalo
en cuenta antes de imprimir este mensaje. AVISO LEGAL: Este mensaje y sus
anexos pueden contener información confidencial o legalmente protegida. Está
dirigido únicamente a la persona o entidad indicada como destinatarios del
mensaje. Si este mensaje le hubiera llegado por error, por favor elimínelo sin
revisarlo ni reenviarlo y notifíquelo inmediatamente al remitente.
**********************************************************************************************
________________________________

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
VP Engineering | Boundless<http://boundlessgeo.com/>
jdeol...@boundlessgeo.com<mailto:jdeol...@boundlessgeo.com>
@boundlessgeo<http://twitter.com/boundlessgeo/>

[http://boundlessgeo.com/wp-content/uploads/files/boundless_sig.png]

--
Justin Deoliveira
VP Engineering | Boundless<http://boundlessgeo.com/>
jdeol...@boundlessgeo.com<mailto:jdeol...@boundlessgeo.com>
@boundlessgeo<http://twitter.com/boundlessgeo/>

[http://boundlessgeo.com/wp-content/uploads/files/boundless_sig.png]

--
Justin Deoliveira
VP Engineering | Boundless<http://boundlessgeo.com/>
jdeol...@boundlessgeo.com<mailto:jdeol...@boundlessgeo.com>
@boundlessgeo<http://twitter.com/boundlessgeo/>

[http://boundlessgeo.com/wp-content/uploads/files/boundless_sig.png]

------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] SpatiaLite extension in Windows 2008 R2 64-bit

Reply via email to