Re: Can't convert object of type org.postgresql.util.PGobject

8 messages Options
Embed this post
Permalink
Luca Giandoso

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
Hi.
I've experienced the same problem, but I cannot solve it.
I've tried the same example posted previously using a JDBC connection
directly and it works.

Have you already solved it?

Luca Giandoso

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
Hi Luca,

What is your platform (OS, postgresql, postgis, postgis version)?  
Where did you get the software from?

The problem discussed under this heading is due to the postgis.jar  
library not registering its spatial types in the postgresql JDBC  
driver.  In recent releases this should happen automatically, but for  
some obscure reason it fails on some platforms. I have not been able  
to determine when or why?

Does any one else on the list is familiar with this?

Regards,

Karel Maesen


On 24 Mar 2008, at 12:18, Luca Giandoso wrote:

> Hi.
> I've experienced the same problem, but I cannot solve it.
> I've tried the same example posted previously using a JDBC connection
> directly and it works.
>
> Have you already solved it?
>
> Luca Giandoso
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Luca Giandoso

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
Thank you for your answer.

I'm using:
Ubuntu linux 7.10
PostgreSQL 8.3 (I've also tried with 8.2)
Postgis 1.3.2 compiled from source
postgis.jar compiled from source (I've also tried with snapshot release
from the site)
hibernatespatial 1.0-M1

Luca Giandoso

On Mon, 2008-03-31 at 20:56 +0200, Karel Maesen wrote:

> Hi Luca,
>
> What is your platform (OS, postgresql, postgis, postgis version)?  
> Where did you get the software from?
>
> The problem discussed under this heading is due to the postgis.jar  
> library not registering its spatial types in the postgresql JDBC  
> driver.  In recent releases this should happen automatically, but for  
> some obscure reason it fails on some platforms. I have not been able  
> to determine when or why?
>
> Does any one else on the list is familiar with this?
>
> Regards,
>
> Karel Maesen
>
>
> On 24 Mar 2008, at 12:18, Luca Giandoso wrote:
> > Hi.
> > I've experienced the same problem, but I cannot solve it.
> > I've tried the same example posted previously using a JDBC connection
> > directly and it works.
> >
> > Have you already solved it?
> >
> > Luca Giandoso
> >
> > _______________________________________________
> > hibernatespatial-users mailing list
> > [hidden email]
> > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> > hibernatespatial-users
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
I'm moving to a new Ubuntu workstation with Postgresql 8.3 and  
postgis compiled from source. I'll quickly find out if I run into the  
same problems. I'll keep you posted...

Karel

On 31 Mar 2008, at 21:32, Luca Giandoso wrote:

> Thank you for your answer.
>
> I'm using:
> Ubuntu linux 7.10
> PostgreSQL 8.3 (I've also tried with 8.2)
> Postgis 1.3.2 compiled from source
> postgis.jar compiled from source (I've also tried with snapshot  
> release
> from the site)
> hibernatespatial 1.0-M1
>
> Luca Giandoso
>
> On Mon, 2008-03-31 at 20:56 +0200, Karel Maesen wrote:
>> Hi Luca,
>>
>> What is your platform (OS, postgresql, postgis, postgis version)?
>> Where did you get the software from?
>>
>> The problem discussed under this heading is due to the postgis.jar
>> library not registering its spatial types in the postgresql JDBC
>> driver.  In recent releases this should happen automatically, but for
>> some obscure reason it fails on some platforms. I have not been able
>> to determine when or why?
>>
>> Does any one else on the list is familiar with this?
>>
>> Regards,
>>
>> Karel Maesen
>>
>>
>> On 24 Mar 2008, at 12:18, Luca Giandoso wrote:
>>> Hi.
>>> I've experienced the same problem, but I cannot solve it.
>>> I've tried the same example posted previously using a JDBC  
>>> connection
>>> directly and it works.
>>>
>>> Have you already solved it?
>>>
>>> Luca Giandoso
>>>
>>> _______________________________________________
>>> hibernatespatial-users mailing list
>>> [hidden email]
>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
>>> hibernatespatial-users
>>
>> _______________________________________________
>> hibernatespatial-users mailing list
>> [hidden email]
>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
>> hibernatespatial-users
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Luca Giandoso

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
Karel, have you run into the same problems?
I'm very interested about that.

Thank you

Luca

On Tue, 2008-04-01 at 23:02 +0200, Karel Maesen wrote:

> I'm moving to a new Ubuntu workstation with Postgresql 8.3 and  
> postgis compiled from source. I'll quickly find out if I run into the  
> same problems. I'll keep you posted...
>
> Karel
>
> On 31 Mar 2008, at 21:32, Luca Giandoso wrote:
> > Thank you for your answer.
> >
> > I'm using:
> > Ubuntu linux 7.10
> > PostgreSQL 8.3 (I've also tried with 8.2)
> > Postgis 1.3.2 compiled from source
> > postgis.jar compiled from source (I've also tried with snapshot  
> > release
> > from the site)
> > hibernatespatial 1.0-M1
> >
> > Luca Giandoso
> >
> > On Mon, 2008-03-31 at 20:56 +0200, Karel Maesen wrote:
> >> Hi Luca,
> >>
> >> What is your platform (OS, postgresql, postgis, postgis version)?
> >> Where did you get the software from?
> >>
> >> The problem discussed under this heading is due to the postgis.jar
> >> library not registering its spatial types in the postgresql JDBC
> >> driver.  In recent releases this should happen automatically, but for
> >> some obscure reason it fails on some platforms. I have not been able
> >> to determine when or why?
> >>
> >> Does any one else on the list is familiar with this?
> >>
> >> Regards,
> >>
> >> Karel Maesen
> >>
> >>
> >> On 24 Mar 2008, at 12:18, Luca Giandoso wrote:
> >>> Hi.
> >>> I've experienced the same problem, but I cannot solve it.
> >>> I've tried the same example posted previously using a JDBC  
> >>> connection
> >>> directly and it works.
> >>>
> >>> Have you already solved it?
> >>>
> >>> Luca Giandoso
> >>>
> >>> _______________________________________________
> >>> hibernatespatial-users mailing list
> >>> [hidden email]
> >>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>> hibernatespatial-users
> >>
> >> _______________________________________________
> >> hibernatespatial-users mailing list
> >> [hidden email]
> >> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> >> hibernatespatial-users
> >
> > _______________________________________________
> > hibernatespatial-users mailing list
> > [hidden email]
> > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> > hibernatespatial-users
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
Hi Luca,

I didn't experience any problems.

I'm using Ubuntu 8.04, with the postgresql-8.3, geos and proj  
installed from Synaptic, together with the corresponding -dev  
packages. I also installed the postgis JDBC drivers with Synaptic  
from package libpostgis-java .  The postgresql JDBC driver came from  
the libpg-java package. The default JVM is the java-6-sun.

Since there is no postgis package for postgresql-8.3 (yet), I  
dowloaded the sources from the postgis website and built it from  
source. The build process is simple and well-documented in the  
PostGis manual. I only had to run configure with one additional  
parameter : --datarootdir=/usr/share/postgresql/8.3/contrib.  
Otherwise the 'make install' could install some items directly under /
usr/share/.

After that I ran the tutorial code for Hibernate Spatial for Postgis  
without problems.

My advice is to follow the same route, but with the 7.10 packages (I  
haven't checked, but I think they exist for 7.10 also).

Hope this helps.

Regards,


Karel Maesen



On 16 Apr 2008, at 17:33, Luca Giandoso wrote:

> Karel, have you run into the same problems?
> I'm very interested about that.
>
> Thank you
>
> Luca
>
> On Tue, 2008-04-01 at 23:02 +0200, Karel Maesen wrote:
>> I'm moving to a new Ubuntu workstation with Postgresql 8.3 and
>> postgis compiled from source. I'll quickly find out if I run into the
>> same problems. I'll keep you posted...
>>
>> Karel
>>
>> On 31 Mar 2008, at 21:32, Luca Giandoso wrote:
>>> Thank you for your answer.
>>>
>>> I'm using:
>>> Ubuntu linux 7.10
>>> PostgreSQL 8.3 (I've also tried with 8.2)
>>> Postgis 1.3.2 compiled from source
>>> postgis.jar compiled from source (I've also tried with snapshot
>>> release
>>> from the site)
>>> hibernatespatial 1.0-M1
>>>
>>> Luca Giandoso
>>>
>>> On Mon, 2008-03-31 at 20:56 +0200, Karel Maesen wrote:
>>>> Hi Luca,
>>>>
>>>> What is your platform (OS, postgresql, postgis, postgis version)?
>>>> Where did you get the software from?
>>>>
>>>> The problem discussed under this heading is due to the postgis.jar
>>>> library not registering its spatial types in the postgresql JDBC
>>>> driver.  In recent releases this should happen automatically,  
>>>> but for
>>>> some obscure reason it fails on some platforms. I have not been  
>>>> able
>>>> to determine when or why?
>>>>
>>>> Does any one else on the list is familiar with this?
>>>>
>>>> Regards,
>>>>
>>>> Karel Maesen
>>>>
>>>>
>>>> On 24 Mar 2008, at 12:18, Luca Giandoso wrote:
>>>>> Hi.
>>>>> I've experienced the same problem, but I cannot solve it.
>>>>> I've tried the same example posted previously using a JDBC
>>>>> connection
>>>>> directly and it works.
>>>>>
>>>>> Have you already solved it?
>>>>>
>>>>> Luca Giandoso
>>>>>
>>>>> _______________________________________________
>>>>> hibernatespatial-users mailing list
>>>>> [hidden email]
>>>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
>>>>> hibernatespatial-users
>>>>
>>>> _______________________________________________
>>>> hibernatespatial-users mailing list
>>>> [hidden email]
>>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
>>>> hibernatespatial-users
>>>
>>> _______________________________________________
>>> hibernatespatial-users mailing list
>>> [hidden email]
>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
>>> hibernatespatial-users
>>
>> _______________________________________________
>> hibernatespatial-users mailing list
>> [hidden email]
>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
>> hibernatespatial-users
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Luca Giandoso

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
Thank you very much Karel. Now I'm sure that it is not a
hibernatespatial bug.

Luca


On Wed, 2008-04-16 at 23:30 +0200, Karel Maesen wrote:

> Hi Luca,
>
> I didn't experience any problems.
>
> I'm using Ubuntu 8.04, with the postgresql-8.3, geos and proj  
> installed from Synaptic, together with the corresponding -dev  
> packages. I also installed the postgis JDBC drivers with Synaptic  
> from package libpostgis-java .  The postgresql JDBC driver came from  
> the libpg-java package. The default JVM is the java-6-sun.
>
> Since there is no postgis package for postgresql-8.3 (yet), I  
> dowloaded the sources from the postgis website and built it from  
> source. The build process is simple and well-documented in the  
> PostGis manual. I only had to run configure with one additional  
> parameter : --datarootdir=/usr/share/postgresql/8.3/contrib.  
> Otherwise the 'make install' could install some items directly under /
> usr/share/.
>
> After that I ran the tutorial code for Hibernate Spatial for Postgis  
> without problems.
>
> My advice is to follow the same route, but with the 7.10 packages (I  
> haven't checked, but I think they exist for 7.10 also).
>
> Hope this helps.
>
> Regards,
>
>
> Karel Maesen
>
>
>
> On 16 Apr 2008, at 17:33, Luca Giandoso wrote:
> > Karel, have you run into the same problems?
> > I'm very interested about that.
> >
> > Thank you
> >
> > Luca
> >
> > On Tue, 2008-04-01 at 23:02 +0200, Karel Maesen wrote:
> >> I'm moving to a new Ubuntu workstation with Postgresql 8.3 and
> >> postgis compiled from source. I'll quickly find out if I run into the
> >> same problems. I'll keep you posted...
> >>
> >> Karel
> >>
> >> On 31 Mar 2008, at 21:32, Luca Giandoso wrote:
> >>> Thank you for your answer.
> >>>
> >>> I'm using:
> >>> Ubuntu linux 7.10
> >>> PostgreSQL 8.3 (I've also tried with 8.2)
> >>> Postgis 1.3.2 compiled from source
> >>> postgis.jar compiled from source (I've also tried with snapshot
> >>> release
> >>> from the site)
> >>> hibernatespatial 1.0-M1
> >>>
> >>> Luca Giandoso
> >>>
> >>> On Mon, 2008-03-31 at 20:56 +0200, Karel Maesen wrote:
> >>>> Hi Luca,
> >>>>
> >>>> What is your platform (OS, postgresql, postgis, postgis version)?
> >>>> Where did you get the software from?
> >>>>
> >>>> The problem discussed under this heading is due to the postgis.jar
> >>>> library not registering its spatial types in the postgresql JDBC
> >>>> driver.  In recent releases this should happen automatically,  
> >>>> but for
> >>>> some obscure reason it fails on some platforms. I have not been  
> >>>> able
> >>>> to determine when or why?
> >>>>
> >>>> Does any one else on the list is familiar with this?
> >>>>
> >>>> Regards,
> >>>>
> >>>> Karel Maesen
> >>>>
> >>>>
> >>>> On 24 Mar 2008, at 12:18, Luca Giandoso wrote:
> >>>>> Hi.
> >>>>> I've experienced the same problem, but I cannot solve it.
> >>>>> I've tried the same example posted previously using a JDBC
> >>>>> connection
> >>>>> directly and it works.
> >>>>>
> >>>>> Have you already solved it?
> >>>>>
> >>>>> Luca Giandoso
> >>>>>
> >>>>> _______________________________________________
> >>>>> hibernatespatial-users mailing list
> >>>>> [hidden email]
> >>>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>>>> hibernatespatial-users
> >>>>
> >>>> _______________________________________________
> >>>> hibernatespatial-users mailing list
> >>>> [hidden email]
> >>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>>> hibernatespatial-users
> >>>
> >>> _______________________________________________
> >>> hibernatespatial-users mailing list
> >>> [hidden email]
> >>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>> hibernatespatial-users
> >>
> >> _______________________________________________
> >> hibernatespatial-users mailing list
> >> [hidden email]
> >> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> >> hibernatespatial-users
> >
> > _______________________________________________
> > hibernatespatial-users mailing list
> > [hidden email]
> > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> > hibernatespatial-users
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
JimLee

Re: Can't convert object of type org.postgresql.util.PGobject

Reply Threaded More More options
Print post
Permalink
I'm experiencing the same issue.  I understand this isn't a hibernate spatial bug, but has any solution been found?  

I'm running postgres 8.3 on OS X, installed from the Kyng Chaos site, and also postgis 1.3.  I have the postgres jdbc3 jar from the postgres download site, and the postgis jdbc jar from the postgis nightly snapshot.  Both jars on my classpath, and I can insert postgis geometry objects fine.  Only when retrieving rows, do I see an error.  

Luca Giandoso wrote:
Thank you very much Karel. Now I'm sure that it is not a
hibernatespatial bug.

Luca


On Wed, 2008-04-16 at 23:30 +0200, Karel Maesen wrote:
> Hi Luca,
>
> I didn't experience any problems.
>
> I'm using Ubuntu 8.04, with the postgresql-8.3, geos and proj  
> installed from Synaptic, together with the corresponding -dev  
> packages. I also installed the postgis JDBC drivers with Synaptic  
> from package libpostgis-java .  The postgresql JDBC driver came from  
> the libpg-java package. The default JVM is the java-6-sun.
>
> Since there is no postgis package for postgresql-8.3 (yet), I  
> dowloaded the sources from the postgis website and built it from  
> source. The build process is simple and well-documented in the  
> PostGis manual. I only had to run configure with one additional  
> parameter : --datarootdir=/usr/share/postgresql/8.3/contrib.  
> Otherwise the 'make install' could install some items directly under /
> usr/share/.
>
> After that I ran the tutorial code for Hibernate Spatial for Postgis  
> without problems.
>
> My advice is to follow the same route, but with the 7.10 packages (I  
> haven't checked, but I think they exist for 7.10 also).
>
> Hope this helps.
>
> Regards,
>
>
> Karel Maesen
>
>
>
> On 16 Apr 2008, at 17:33, Luca Giandoso wrote:
> > Karel, have you run into the same problems?
> > I'm very interested about that.
> >
> > Thank you
> >
> > Luca
> >
> > On Tue, 2008-04-01 at 23:02 +0200, Karel Maesen wrote:
> >> I'm moving to a new Ubuntu workstation with Postgresql 8.3 and
> >> postgis compiled from source. I'll quickly find out if I run into the
> >> same problems. I'll keep you posted...
> >>
> >> Karel
> >>
> >> On 31 Mar 2008, at 21:32, Luca Giandoso wrote:
> >>> Thank you for your answer.
> >>>
> >>> I'm using:
> >>> Ubuntu linux 7.10
> >>> PostgreSQL 8.3 (I've also tried with 8.2)
> >>> Postgis 1.3.2 compiled from source
> >>> postgis.jar compiled from source (I've also tried with snapshot
> >>> release
> >>> from the site)
> >>> hibernatespatial 1.0-M1
> >>>
> >>> Luca Giandoso
> >>>
> >>> On Mon, 2008-03-31 at 20:56 +0200, Karel Maesen wrote:
> >>>> Hi Luca,
> >>>>
> >>>> What is your platform (OS, postgresql, postgis, postgis version)?
> >>>> Where did you get the software from?
> >>>>
> >>>> The problem discussed under this heading is due to the postgis.jar
> >>>> library not registering its spatial types in the postgresql JDBC
> >>>> driver.  In recent releases this should happen automatically,  
> >>>> but for
> >>>> some obscure reason it fails on some platforms. I have not been  
> >>>> able
> >>>> to determine when or why?
> >>>>
> >>>> Does any one else on the list is familiar with this?
> >>>>
> >>>> Regards,
> >>>>
> >>>> Karel Maesen
> >>>>
> >>>>
> >>>> On 24 Mar 2008, at 12:18, Luca Giandoso wrote:
> >>>>> Hi.
> >>>>> I've experienced the same problem, but I cannot solve it.
> >>>>> I've tried the same example posted previously using a JDBC
> >>>>> connection
> >>>>> directly and it works.
> >>>>>
> >>>>> Have you already solved it?
> >>>>>
> >>>>> Luca Giandoso
> >>>>>
> >>>>> _______________________________________________
> >>>>> hibernatespatial-users mailing list
> >>>>> hibernatespatial-users@lists.hibernatespatial.org
> >>>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>>>> hibernatespatial-users
> >>>>
> >>>> _______________________________________________
> >>>> hibernatespatial-users mailing list
> >>>> hibernatespatial-users@lists.hibernatespatial.org
> >>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>>> hibernatespatial-users
> >>>
> >>> _______________________________________________
> >>> hibernatespatial-users mailing list
> >>> hibernatespatial-users@lists.hibernatespatial.org
> >>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> >>> hibernatespatial-users
> >>
> >> _______________________________________________
> >> hibernatespatial-users mailing list
> >> hibernatespatial-users@lists.hibernatespatial.org
> >> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> >> hibernatespatial-users
> >
> > _______________________________________________
> > hibernatespatial-users mailing list
> > hibernatespatial-users@lists.hibernatespatial.org
> > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> > hibernatespatial-users
>
> _______________________________________________
> hibernatespatial-users mailing list
> hibernatespatial-users@lists.hibernatespatial.org
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
hibernatespatial-users@lists.hibernatespatial.org
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users