[postgis-users] RE: RE: RE: PostGIS - hibernate (new postgis.jar)
Norman Barker
nbarker at ittvis.com
Fri Apr 13 08:02:58 PDT 2007
Hi,
Yes you should change the dialect type in persistence.xml to
PostGISDialect and include the java class in your archive.
It should then be possible to make spatial object queries e.g.
Query intersects = entityManager.createQuery("Select
spatial.Intersects(p.location, person.location) from PersonEntity p,
PersonEntity as person where person = :person");
intersects.setParameter("person", p);
then executing this query will return populated people objects who are
within the same area.
Norman
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
rabbiaqaswar
Sent: 13 April 2007 02:36
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] RE: RE: RE: PostGIS - hibernate (new
postgis.jar)
Thanks a lot for your help. Earlier i just had the postgresql jdbc
driver &
postgis.jar in my class path. In my entity bean POJO i did what was
mentioned in the ejb3spatial.pdf and included the package containing
your
GeometryType.java (user type) in my project. In the persistence.xml file
i
set the hibernate.dialect as org.hibernate.dialect.PostgreSQLDialect and
my
program was able to retrieve the data from the tables containing
geographical information.
So far things are good :) now should i add PostGISDialect in my
persistence.xml instead of org.hibernate.dialect.PostgreSQLDialect and
do i
have to include its java file with the GeometryType in my project? I am
a
complete newbie with geographical information related work so please
don't
mind my questions.
Many Thanks
Norman Barker-3 wrote:
>
> Hi,
>
> I appreciate your confusion it took me a while to work out what was
> going on (I don't have commit access :-( )
>
> The dialect has been put in its own folder called hibernate at
> http://svn.refractions.net/postgis/trunk/java/
>
> you will also need the user type from the ejb3 folder. Really they
> should be together, my fault I should have communicated this better to
> Markus.
>
> Let me know I can be of help.
>
> Thanks,
>
> Norman
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> rabbiaqaswar
> Sent: 11 April 2007 23:38
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] RE: RE: PostGIS - hibernate (new postgis.jar)
>
>
> Hello
>
> Thanks for your reply. I found this
> http://svn.refractions.net/postgis/trunk/java/ejb3/ svn link from
your
> earlier posts in this topic, which has that ejb3spatial.pdf file. Can
> you
> please tell me which svn link has the latest information.
>
> Many Thanks
>
>
>
> Norman Barker-3 wrote:
>>
>> Hi,
>>
>> There has been a lot of activity with the hibernate postgis driver,
> just
>> everyone thinks it isn't of interest to the list and mail me
> directly!!
>> (I have no problem with this).
>>
>> The major update is the spatial dialect for ejb3 (hibernate) allowing
>> you to make spatial queries in object space, e.g. select obj from
>> mytable where spatial.within(obj.box, ...)
>>
>> The code is in SVN, but I don't believe it is in postgis.jar, it is
>> heavily dependent on the JDBC driver and hibernate for its
>> functionality.
>>
>> Thanks,
>>
>> Norman
>>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>> rabbiaqaswar
>> Sent: 10 April 2007 13:29
>> To: postgis-users at postgis.refractions.net
>> Subject: [postgis-users] RE: PostGIS - hibernate (new postgis.jar)
>>
>>
>> Thankyou all for the support.
>>
>> I am using EJB3 with PostgreSQL & JBoss. Read through the tutorial
on
>> svn
>> by Norman Barker. I compiled the GeometryType java file in
>> org.postgis.hibernate and included the org.postgis.hibernate package
> in
>> my
>> classpath and the whole thing worked.
>>
>> Since the last post on this forum was in November 2006, i wanted to
> know
>> that is there any change in the method to handle gis data from
>> postgresql
>> tables using ejb3 architecture? Is the GeometryType class by Norman
>> included
>> in the latest release of postgis.jar or should it be included
> seperately
>> like i mentioned above?
>>
>> Thanks again
>>
>>
>> Norman Barker-3 wrote:
>>>
>>>
>>> I think I missed the start of this thread (and I can't find it in
the
>>> archives), can you summarize the problem, and the server you are
>> using?
>>>
>>>
>>> The GeometryUserType class doesn't do very much but call out to the
>>> utility functions provided in the postgis jar, so it does sound like
> a
>>> classpath issue.
>>>
>>> If you can send me a summary I will try to recreate the problem. (I
>>> have both tomcat and jboss set up here).
>>>
>>> If the attachment is large please send it to
>> norman.barker<at>gmail.com
>>>
>>> Thanks,
>>>
>>> Norman
>>>
>>> -----Original Message-----
>>> From: postgis-users-bounces at postgis.refractions.net
>>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>> Jan
>>> Syryn
>>> Sent: 27 November 2006 16:39
>>> To: 'PostGIS Users Discussion'
>>> Subject: RE: [postgis-users] PostGIS - hibernate (new postgis.jar)
>>>
>>> ***********************
>>> Warning: Your file, postgis2.jar, contains more than 32 files after
>>> decompression and cannot be scanned.
>>> ***********-***********
>>>
>>>
>>> Hi Markus,
>>>
>>> The thing I did to be able to continue is I have created a
>>> postgis_addon.jar
>>> lib that contained only new stuff like BinaryWriter.class and
>>> GeometryUserType.
>>> And that works. It does not solve the problem, though I can use the
>>> latest
>>> version of postgis.
>>>
>>> I tried to use the tip I found in my previous posting by changing
the
>>> name
>>> of the postgresql-jdbc.jar drvier to pg-jdbc.jar driver with my new
>>> build
>>> postgis2.jar (version 1.1.5)
>>> I did not help.
>>> If I remove the 2 stub files (PGConnection and Connection) from
>>> postgis2.jar
>>> : same result.
>>> It stucks again on "No suitable driver".
>>> If I replace the postgis2.jar by postgis.jar(1.1.0) and
>>> postgis_addon.jar by
>>> changing the settings on the classpath, everything works again.
>>>
>>> So, I assume there is a thing in postgis2.jar.
>>> And to create my postgis2.jar, I made a separate project in Eclipse,
>>> created
>>> a jar file of almost all java files(exl examples). This should do
it,
>> no
>>> ?
>>>
>>> Anyway, I included my postgis2.jar so maybe one can replace his one
>> with
>>> mine and see what that does.
>>> Or maybe one sees what I am doing wrong elsewhere...
>>>
>>> TIA,
>>> Jan
>>>
>>> -----Original Message-----
>>> From: postgis-users-bounces at postgis.refractions.net
>>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>>> Markus
>>> Schaber
>>> Sent: samedi 25 novembre 2006 10:16
>>> To: PostGIS Users Discussion
>>> Subject: Re: [postgis-users] RE: RE: RE: PostGIS - hibernate - EJB3
>>>
>>> Hi,
>>>
>>> Norman Barker wrote:
>>>
>>>> 2. In the thread here, people are using:
>>>> <driver-class>org.postgis.DriverWrapper</driver-class>
>>>> When I do the same, I get a "No suitable driver" exception.
>>>
>>> [...]
>>>> 3. I wanted to use the GeometryType that is packed in PostGIS
1.1.5.
>>>> After generating the new JAR and replacing the old one by this one,
> I
>>
>>>> start getting new exceptions:
>>>> The class org.postgis.PGbox3d does not implement
>>>> org.postgresql.util.PGobject.
>>>
>>> Those 2 things look like a classpath/classloader problem.
>>>
>>> You have to make sure that the postgis.jar and the
> postgresql-jdbc.jar
>>> are
>>> available via the same classloader (and that you don't have two
>>> incarnations
>>> of them in your classpath)
>>>
>>>
>>> HTH,
>>> Markus
>>>
>>>
>>> --
>>> Markus Schaber | Logical Tracking&Tracing International AG
>>> Dipl. Inf. | Software Development GIS
>>>
>>> Fight against software patents in Europe! www.ffii.org
>>> www.nosoftwarepatents.org
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>
>> --
>> View this message in context:
>>
>
http://www.nabble.com/PostGIS---hibernate---EJB3-tf2064211.html#a9926716
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> --
> View this message in context:
>
http://www.nabble.com/PostGIS---hibernate---EJB3-tf2064211.html#a9953356
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
--
View this message in context:
http://www.nabble.com/PostGIS---hibernate---EJB3-tf2064211.html#a9974998
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list