[postgis-devel] State of the postgis hibernate union?

[VanIngen, Erik (ESTG)]

Hi Per-Olof Norén,

We had kind of exact the same issues and we did a lot of research. We
investigated 3 paths:
(1) Geoserver/Geotools/Postgis with our own datastore without Hibernate 
This one is still working quite well, but we would like to replace with (3)
(2) Geoserver/Geotools/Postgis with our own datastore with Hibernate 
Did not work because Geotools assumes a database view which does not fit with
the Hibernate approach. 
(3) Geoserver/HibernateSpatial/Postgis
We will starting the investigation on this soon. No results yet. Of course
the nicest and cleanest solution. My idea is that HibernateSpatial is doing a
very good job but it is very recent software and not yet used in many
systems. And I think they might be the first with a proper implementation. 

http://www.foss4g2007.org/presentations/view.php?abstract_id=118
Not investigated, to me seems less clean than HibernateSpatial because they
reverse engineered from the database instead of starting from the domain
model(JTS)

Our architecture is
JPA/Hibernate/Spring/Geoserver/Maven/Tomcat/PostgreSQL/PostGIS.

Kind Regards,
Erik van Ingen




-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Per-Olof
Norén
Sent: 07 October 2007 19:27
To: postgis-users at postgis.refractions.net;
postgis-devel at postgis.refractions.net
Subject: [postgis-devel] State of the postgis hibernate union?


Hi guys,

Sorry for cross posting, I'm new to the lists and not sure on where this 
belongs.

I'm currently involved in a project with GIS functionality. Architecture is
roughly like this:
* Apache Tomcat
* Wicket 1.3 / Geoserver 1.6
* Hibernate
* PostgreSQL 8.2 + PostGIS 1.2.1
We're using maven2 as build system for all this.

Currently I'm looking to set up EJB persistence for domain beans 
containing persistence. Using hibernate annotations.

1. Maven repository for the postgis jar
I found this: 
http://postgis.refractions.net/pipermail/postgis-devel/2006-November/002375.h
tml
And it seems perfect, had it only been updated to latest and greatest 
version.
Are there any plans for an updated driver?

2. EJB and hibernate UserTypes
I found EJB3 code in the postgis driver source, contributed by norman baker.
I found http://www.hibernatespatial.org/ , which seems to fit. I found
http://www.foss4g2007.org/presentations/view.php?abstract_id=118
To bad I missed foss4g...

Seems to me all of the above do the same thing as I want.
I'm interested in the direction / roadmap for the postGIS EJB3 development.
Which should I use, according to the postGIS community?

Any suggestions greatly appreciated

Thanks in advance
Per-Olof Norén





_______________________________________________
postgis-devel mailing list postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel