On Tue, Nov 20, 2012 at 7:40 AM, Andrea Aime
<andrea.a...@geo-solutions.it>wrote:
> On Tue, Nov 20, 2012 at 3:34 PM, Justin Deoliveira
> <jdeol...@opengeo.org>wrote:
>
>> The sqlitejdbc project.
>>
>> http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
>>
>> A while back i submitted a patch but it was pretty rough, again lacking
>> any support for 64 bit windows.
>>
>> http://code.google.com/p/xerial/issues/detail?id=86
>>
>> Since then i have improved upon this but haven't updated the patch as of
>> yet.
>>
>
> I believe the project was moved to bitbucket in the meantime and gained
> back some activity
> with new people working on it:
> https://bitbucket.org/xerial/sqlite-jdbc
>
> I guess in order to get anything merged into it a pull request has to be
> made there
>
Right. I did fork the repo and commit all my work there.
https://bitbucket.org/jdeolive/sqlite-jdbc
Never got around to submitting the pull request... really i will probably
need to work with the author(s) to figure out the best way to merge in
support for spatialite. C build systems aren't exactly my specialty.
>
> There are also a few pure JNI bindings around that are not providing any
> JDBC interface
> which are rather interesting in that they prove raw, high performance
> access to the
> underlying sqlite, of course to use them one would have to write the store
> from scratch
> instead of using the infrastructure and testing framework provided by
> gt-jdbc... which is
> quite annoying.
>
Do you have any one in particular you like? Indeed having it be a jdbc
datastore is quite nice to inherit the tests. But if there is another lib
that makes it easier to integrate with spatialite it just might be worth
it. The pain with sqlitejdbc is that it includes its own copy of sqlite
which will conflict with one that the user builds or already has spatialite
support.
Originally the experiment used this driver.
http://www.ch-werner.de/javasqlite/
Which looks to be remaining somewhat active with a release this year. Might
be worth considering switching back to it.
> Cheers
> Andrea
>
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel