ClassCastException with LargeObjectAPI and Tomcat Connection Pool (DBCP)

From: Joao Filipe Placido <joao-f-placido(at)ptinovacao(dot)pt>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: ClassCastException with LargeObjectAPI and Tomcat Connection Pool (DBCP)
Date: 2003-01-03 18:00:12
Message-ID: D397A7FACCC45A44A0A207FD892961EA04A375C2@RIOVOUGA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello list,

I configured successfully a PostgreSQL 7.2.3 connection pool with JNDI
DataSource following the Tomcat docs (v 4.1.12).
But when I try to use the returned connection with the LargeObjectAPI,
tomcat gives me a ClassCastException (runtime), in the following line:

LargeObjectManager lobj =
((org.postgresql.PGConnection)db).getLargeObjectAPI();

I tried using pgjdbc2.jar, in which case instead of
org.postgresql.PGConnection, it only works with org.postgresql.Connection.
With pg73jdbc3.jar, and using org.postgresql.PGConnection, the same
Exception occurs.
I also tried with a compiled JDBC jar from the 7.3 sources, with no luck.

I don't understand why the connection works with non-LargeObject SQL and
fails here. I have the same jars working with the LargeObjectAPI without the
Tomcat DBCP.
Any help is appreciated. Has anyone successfully configured a tomcat DBCP
with PostgresSQL and used LOs with it?

Thank you,

João Filipe Plácido

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-01-03 18:30:18 Re: [GENERAL] 7.3 Prepared statements
Previous Message Jeff 2003-01-03 17:12:44 Re: join over 12 tables takes 3 secs to plan