[postgis-users] RE: PostGIS - hibernate (new postgis.jar)

[Norman Barker]

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