Hi Andrea,
Some comments inline.
On Wed, Oct 10, 2012 at 3:28 PM, andrea antonello <
[email protected]> wrote:
> Hi Justin,
> I am trying to investigate enablement of spatialite support for uDig
> and am having some issues with sqlite's native libraries even before I
> get to the whole spatialite native dependencies hell.
>
> So what happens is that the extracted native library from the jar on a
> 64 bit windows is a 32bit lib.
>
> It took me some time to understand, since I didn't realize the
> sqlite-jdbc-spatialite-3.7.2-2.4.jar is a tweaked one and the doc page
> tells: "At this time Windows 64-bit libraries are not available but
> the 32-bit libraries should work on 64-bit systems."
>
> Right. So, the story was that i wasn't able to figure out how to compile
for windows 64 bit. I didn't want to buy vistual studio professional and i
couldn't for the life of me get mingw-64 to work so i more or less gave up.
Adding to that I couldn't find a 64 bit windows build of spatialite.
Although I think my research in this area is out of date... doing a quick
search looks like 64 bit builds for windows are now available.
That said, i was able to use the 32 bit libs on a 64 bit windows 7 machine
and it worked ok. I can't remember if i had to run the jvm in 32 bit
mode... (-d32 flag). If so we should update that doc.
Hope that helps. I am eager to have someone verify this work :)
I am a bit confused, because I am not sure if you talk about the
> spatialite or the sqlite ones.
>
> What I am sure about it that the 32 bit nativs do not work in a 64 bit
> environment.
>
> Can you shed me some light please?
>
> Thanks!
> Andrea
>
>
>
> On Tue, Jul 17, 2012 at 6:30 AM, Justin Deoliveira <[email protected]>
> wrote:
> > 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
> >
>
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> GeoTools-Devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
