SpatiaLite and Java/JDBC

[a.furieri]

Hi List,

from time to time some Java/JDBC related
question bounces on this mailing list.

I've just verified how the Xerial JDBC
connector can fully support SpatiaLite;
so I quickly posted a short report about
my first-hand experiences:
http://www.gaia-gis.it/spatialite-2.4.0-4/splite-jdbc.html
[sample/demo code included]

I suppose this can help several Java fans
finding their way to SpatiaLite in the
easiest and painless way :-)

Enjoy,
Sandro

[andrea antonello]

Hi Alessandro,
thanks for this.
Allow me to throw in this question.
Is there any way that also the rasterlite will get drivers supported
outside the C world? (maybe it is already, if yes, s/outside the C/in
the java/).
I saw your presentation at the GFOSS about rasterlite and found it really cool.

I assume this is the mailinglist that will handle also rasterlite?

Thanks,
Ciao
Andrea

> --
> You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
> To post to this group, send email to spatiali...@googlegroups.com.
> To unsubscribe from this group, send email to spatialite-use...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/spatialite-users?hl=en.
>
>

[a.furieri]

Ciao Andrea,

RasterLite-2 development isn't going
as fast as I expected: other tasks are
taking me quite busy on different fronts
for now.
so I suppose the final release will be
postponed somewhere during Spring 2011

Anyway, supporting RL-2 in Java doesn't
seems an impossible goal: we'll see better
after initial C release and consolidation :-)

saluti
Sandro

[andrea antonello]

Hi Alessandro,
I just gave your example a spin, but wanted it to try on windows,
since things on linux are always too easy :)

In fact I failed, getting the following error message as soon as I try
to load the spatialite extention:
[SQLITE_ERROR] SQL error or missing database (%1 non è un'applicazione
di Win32 valida.
)

The error is right. I am on a 64 bit system. So I went back to get the
64 bit library.... and... :)

Is there any chance that there will be a 64 bit version available soon?

Thanks,
Ciao
Andrea

On Sat, Jan 8, 2011 at 9:15 PM, a.furieri <a.fu...@lqt.it> wrote:

[a.furieri]

Carissimo Andrea,

this one surely is a "big problem" for now:
building 64 bit software on Linux and MacOsX
is a piece of cake since many years ago.

But for Windows this still looks very
difficult. We actually have several
compilers supporting Windows, so I have
to get you a distinct explanation for
each one of them.

a) MinGW / MSYS
==========================
a worderfull port of GCC: unhappily
only supporting 32 bit

b) mingw64
==========================
a fork supporting 64 bit: quite immature
and very experimental; IMHO not yet ready
to be used for standard deployment

c) MSVC (Visual Studio Express and so on)
==========================
The latest Visual Studio Express 2010
apparently supports 64 bit in a reasonably
painless way.
unhappily porting packages such as PROJ.4
and GEOS to MSVC is really painfull.
and porting the critical LIBICONV
simply seems impossible at all.

Please note: OSGeo4W supports a wide
collection of GIS-related DLLs for
MSVC; but all them simply are 32 bit

conclusion: MISSION IMPOSSIBLE (so
standing things)

ciao
Sandro

[andrea antonello]

Hi Alessandro,
thank you very much for your (as usual) very complete answer.

<heretic=on>
Sorry, I can't keep back the itch that overcomes me: so C isn't all
that portable after all? :)
</heretic=off>

Jokes apart, that missing 64bit thing a blocker. I am using an
embedded database since ever both in JGrass and BeeGIS and I would
live to step over to spatialite, but apart of the missing 64bit right
now it seems a bit too tricky to get there from the java world (and I
repeat: from the java world).

Thanks for the discussion,
Andrea