Hi all,
Over the weekend I decided to spent some time on long outstanding todo
item, improving our spatialite support. I just pushed some changes which I
hope will allow the driver to be more easily used and on more platforms.
Basically to sum up the work:
* I updated the sqlitejdbc driver to include spatialite on all of its
supported platforms which are 32/64 bit on windows, linux, and osx (intel
macs). With the caveat that the windows 64 bit DLL's are not actually
compiled for 64 bit. But tested the 32-bit DLL's and they seem to work
fine.
Unfortunately my changes to the sqlitejdbc are pretty custom and i have had
a few problems getting the changes in to the core. I am currently hosting
the changes in a forked repo on bitbucket.
https://bitbucket.org/jdeolive/sqlite-jdbc
I hope to try again soon with the sqlitejdbc maintainer to see how i can
clean up the changes to get them more supported in the core. But for now
though I may just maintain my fork and track the major versions of the
driver.
* I updated the user docs to better explain how to configure the system and
java to properly load all the libs.
http://docs.geotools.org/latest/userguide/library/jdbc/spatiallite.html
* I have posted pre-compiled proj and geos libs for all the supported
platforms containing the same versions that spatialite/sqlite
was compiled against.
http://gridlock.opengeo.org/geotools/spatialite-libs-linux-x86.zip
http://gridlock.opengeo.org/geotools/spatialite-libs-linux-x86_64.zip
http://gridlock.opengeo.org/geotools/spatialite-libs-osx-intel.zip
http://gridlock.opengeo.org/geotools/spatialite-libs-win-x86.zip
Just hosting them on opengeo servers for now but eventually we should move
them to sourceforge or something. It would be good to get a sanity check on
them though before that.
* Some minor improvements to the spatialite dialect itself, such as WKB
support, etc...
It would be great if other devs could take it for a test drive and attempt
to run the unit tests. I added a readme to the module that describes how to
run the tests:
https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-spatialite/README.txt#L31
Once I can get confirmation of others having some success i hope to
backport the changes to the stable branch as well.
-Justin
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
