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> 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 <jdeol...@boundlessgeo.com>
> Lähetetty: 20.9.2014 0:08
> Vastaanottaja: Rahkonen Jukka (Tike) <jukka.rahko...@mmmtike.fi>
> Kopio: Pedro Briones Garcia <p...@tragsa.es>;
> 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> 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>:
>>
>> 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
>>
>>
>>
>> *Pedro Briones Garcia *
>> Jefe de Grupo de Actuaciones y Proyectos
>>
>> Gerencia de Sistemas de Información Geográfica
>>
>> Grupo Tragsa - SEPI
>>
>> Calle Julián Camarillo 6 B - 28037 Madrid
>> Tel.: 913226489 - 88216 - Fax: 913226005
>> 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
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>
>>
>>
>>
>> --
>>
>> Justin Deoliveira
>> VP Engineering | Boundless <http://boundlessgeo.com/>
>> jdeol...@boundlessgeo.com
>> @boundlessgeo <http://twitter.com/boundlessgeo/>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>
>
>
> --
> Justin Deoliveira
> VP Engineering | Boundless <http://boundlessgeo.com/>
> jdeol...@boundlessgeo.com
> @boundlessgeo <http://twitter.com/boundlessgeo/>
>
>
>
--
Justin Deoliveira
VP Engineering | Boundless <http://boundlessgeo.com/>
jdeol...@boundlessgeo.com
@boundlessgeo <http://twitter.com/boundlessgeo/>
------------------------------------------------------------------------------
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
