[postgis-users] SpatialEJB3: (PostGIS and Hibernate)

[Norman Barker]

Hi,

 

Glad you like the idea!  PostGIS does all the work though :-), and there
have been some good bug reports and questions from users as well.

 

In conclusion;

 

There have been quite a few users of the EJB3 Geometry annotations, but
they are split between JBoss users, and pure Hibernate/Spring users - it
works well in either environment.  Since it is possible to mark a
property of an entity as @Geometry and then have it persist and retrieve
from PostGIS then the investigation was a success, and I am using it in
more projects (and once my current deadlines are out of the way, I want
to do some more to the codebase).

 

The incorporation of spatial functions into hql and ejb-ql is I believe
the next step, but quite a major undertaking.  Certainly at the moment
you could achieve the same functionality with
entitymanager.createNativeQuery for example (which I use to run vacuum
analyze).

 

Let me know if you have any questions, and do post more details about
your project, there have been some interesting use cases.

 

Thanks,

 

Norman

 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Andrew Hughes
Sent: 12 December 2006 04:39
To: PostGIS Users Discussion
Subject: [postgis-users] SpatialEJB3: (PostGIS and Hibernate)

 

Hello All,

I would like to use the SpatialEJB3 JBoss container for my JBoss Web
Service.

The SpatialEJB3 [
http://postgis.refractions.net/support/wiki/index.php?SpatialEJB3 ]
seems to be exactly what I want, but I do have some concerns before I
invest some time in this.....

*	Was there a conclusion to the SpatialEJB3 Investigation:
"Spatial EJB3 is a quick investigation to see if it is possible to
integrate the Java 5 annotation approach to mark a property of an object
as spatial and to delegate to the EJB3 persistence model to store and
retrieve this data."?
*	I require the PostGIS functions [such as
intersects(geometry,geometry)] to extract the data I am looking for in
my spatial database. I am unable to find a reference to any java code
that shows someone running anything [like select
intersection(my_geom,geometry) from locations_table where
intersects(my_geom,geomtery); ] ?


For the people who are involved in the Spatial EJB3, I really like the
idea... well-done!!!


--AH



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061212/fcb17cf4/attachment.html>