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

Mon Dec 18 18:05:17 PST 2006

Hi Norman,

Thanks very much for the reply. Originally I noticed that this was an 
eclipse project, so I tried to get it to compile in Eclipse.... however 
this failed (and I made the wrong assumption that I needed the JBoss IDE 
plugins installed).

Anyway, I have tried this with Ant directly and I now have this 
compiling.. and building the injest.jar.

I don't want to use the message driven beans as in the tutorial... or 
SOAP,  I am using stateless session beans, currently with PostgreSQL... 
but I obviously want to add the Geometry Type to the hibernate actions.

I am correct in assuming that I simply need to add the GeometryType.java 
class to my project to enable this? I would then use annotations to 
specify the GeometryType such as:

@Type(type = "org.postgis.hibernate.GeometryType")

Is there anything that I am missing?

Thanks in advance

--AH

Norman Barker wrote:
> Hi Andrew,
>
> Hopefully this gets to you before you start downloading the JBoss IDE!
>
> The project uses Ant, and the Java 1.5 JDK.
>
> (http://ant.apache.org)
> (http://svn.refractions.net/postgis/trunk/java/ejb3/build.xml)
>
> If you edit the paths in build.xml to point to your installation,
> running 'ant deploy' will build and deploy everything to JBoss for you.
> I used to use the JBoss IDE in the XDoclet for EJB2.x days, but with
> annotations I have dumped it for plain eclipse - but perhaps I should
> give it a go.
>
> Norman
>
>   
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Andrew Hughes
> Sent: 18 December 2006 05:48
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] SpatialEJB3: (PostGIS and Hibernate)
>
> 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*

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