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