Hi Daniel,
Unfortunately there have been reports of folks having issues on 64 bit
windows with the spatialite libraries. Reason being that they are compiled
for 32 bit. I have been able to make it work on a 64 bit system by running
the jvm in 32 bit mode. You can do this with the -d32 parameter to the jvm.
That said others have reported that they have tried this and still couldn't
make it work.
Also, here is a link to windows binaries that should work:
http://gridlock.opengeo.org/geotools/spatialite-libs-win-x86.zip
We are currently working on improving support for spatialite in
geotools/geoserver and attempting to put out a module that contains only
statically linked upstream libraries so that users won't have to worry
about this issue.
Hope that helps.
-Justin
On Tue, Apr 9, 2013 at 6:18 AM, Daniel Berry <[email protected]>wrote:
> Here is my system specifics:
>
> OS: Server 2008R2 (64bit)
> Java: JRE 1.6.0_35 (64bit)
> Geoserver: 2.3.0
> Application Server: Apache Tomcat 7.0.32
>
> The issue I am having is connecting to a spatialite db. I have reviewed the
> notes and attempted to install the required files:
>
> gt-jdbc-spatialite-8-SNAPSHOT.jar
> sqlite-jdbc-spatialite-3.7.2-2.4.jar
>
> which were added into the WEB-INF/lib directory of geoserver
>
> I also added the spatialite dependencies to the C:\Windows\system32
> directory (libgeos_c-1.dll, libgeos-3-2-2.dll and libproj-0.dll) that I
> downloaded from
> http://www.gaia-gis.it/spatialite-2.4.0-4/dependencies-win-x86.zip. This
> was
> specified in the geoserver spatialite user manual. The link for the
> binaries
> was not working, so I obtained the libraries from the gaia-gis.it site for
> the specified version in the user manual "SQLite (3.7.2) and SpatiaLite
> (2.4.0)".
>
> Well my issue is that it is not working. The only extension that shows up
> is
> the spatialite (JNDI) connection, which the user community has no steps for
> creating a spatialite JNDI connection in Tomcat. Do you know how to
> accomplish this or what binaries I should be using and which ones, it would
> be greatly appreciated.
>
> I am loading osm data using the gdal-osm driver and would like to use a
> file
> based database rather than postgres (the site would rather not have to deal
> with a postgres db).
>
> Thanks in advance!
>
> Respectfully,
> Daniel Berry
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/geoserver-2-3-0-spatialite-extension-tp5045487.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users