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

[Andrew Hughes]

Thanks for the reply....

I have checked out the EJB3Spatial source from SVN: 
http://svn.refractions.net/postgis/trunk/java/ejb3/

Now, I am presuming that this requires the JBoss IDE? since it doesn't 
build with Eclipse.... and I can't see this anywhere in the tutorial.

The JBoss plugins are in total 119Mb.... which is rather painful and 
slow... it would be rather helpful if the binaries where available for 
direct download.


When I finally get this downloaded I'll hopefully make some good progress :)




Norman Barker wrote:
>
> Hi,
>
> Glad you like the idea! PostGIS does all the work though J, 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


-- 

Regards,

*Andrew Hughes*
Software Engineer
LISAsoft Pty. Ltd. (Adelaide)

------------------------------------------------------------------------


      LISAsoft Pty. Ltd.

<http://www.lisasoft.com>
*ADELAIDE Office*
<http://terrapages.net/mapbutton/RetrieveButtonServlet?buttonID=4>
38 Greenhill Road
Wayville SA 5034
Australia
*Telephone +61 8 8272 1555*
*Facsimile +61 8 8271 1199* 	
	*SYDNEY Office*
<http://terrapages.net/mapbutton/RetrieveButtonServlet?buttonID=1>
Suite 112 The Lower Deck
Jones Bay Wharf
19-21 Pirrama Road
Pyrmont NSW 2009 AUS
*Telephone +61 2 8570 5060*
*Facsimile +61 2 8570 5099* 	
	*MELBOURNE Office*
<http://terrapages.net/mapbutton/RetrieveButtonServlet?buttonID=3>
Level 7 520 Collins Street
Melbourne VIC 3000
Australia
*Telephone +61 3 9629 1799*
*Facsimile +61 3 9629 4955*

------------------------------------------------------------------------