Re: blob without largeobject api - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: blob without largeobject api
Date
Msg-id 20040621174426.097e55ad@kingfisher.intern.logi-track.com
Whole thread Raw
In response to Re: blob without largeobject api  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Hi, Oliver,

On Wed, 07 Apr 2004 00:24:35 +1200
Oliver Jowett <oliver@opencloud.com> wrote:

> Edoardo Ceccarelli wrote:
> > Tried with a driver downloaded from http://jdbc.postgresql.org/
> >
> > pg74.213.jdbc3.jar
> >
> > the result is always the same:
> > java.lang.ClassCastException: com.caucho.sql.UserConnection
> > on row:
> > LargeObjectManager lom =
> > ((org.postgresql.PGConnection)db).getLargeObjectAPI();
>
> Ok, this means your pooling implementation is not using the postgresql
> driver's PooledConnection to generate the proxy connections to hand
> out, but is implementing them itself (using instances of
> com.caucho.sql.UserConnection, it appears). So you won't be able to
> get at postgresql-specific interfaces with that pooling
> implementation, regardless of what the driver does.

Maybe his pooling implementation provides a method to get to the
underlying "real" connection.

In one of our projects, we had to use this Trick to add the PostGIS
Wrapper Classes to the JDBC Driver.

HTH,
Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com

pgsql-jdbc by date:

Previous
From: Laurent Sylvain
Date:
Subject: Bug (and fix): leaks of TCP connections when connected to a <7.4 server
Next
From: Markus Schaber
Date:
Subject: Re: what is lslowing me down? JDBC or Postgresql itself?