jboss, spatial data, Postgre vs. Oracle

[hleblanc]

Hi, I'm in the process of building a jboss app for a client of mine. One of the requirements is that we support spatial data and web-based mapping. We were planning to use Oracle, but I just found out that Postgre has the Postgis extensions.
Has anyone used Postgre with jboss? How stable is the jdbc driver? Does the jdbc driver support spatial data?
What about web-enabled (and hopefully java-based) mapping tools that interact with jboss?
Blue-sky questions, I know. But I'd love to have a totally open-source model if Postgre can deliver the functionality and stability I need.
Thanks for your feedback to this jboss newbie.

[pazu]

I've been using PostgreSQL for quite some time now, and it is rock solid.

I don't know about spatial data in PostgreSQL, however. JBoss can be managed over the web using the JMX/HTML interface.

[bezdicek]

hi,

we tried both postgres and oracle for spatial data applications. the advantage of postgres is that it supports geometrical datatypes, where as oracle does a lot of mapping for different coordinate systems which we need to support, so it might depend what your tasks for spatial data are, the jdbc drivers are both stable.