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.
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 <mr.daniel.berry@anonymised.com> 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
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.