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>, Joao Filipe Placido <joao-f-placido(at)ptinovacao(dot)pt>
Subject: ClassCastException with LargeObjectAPI and Tomcat Connection Pool (DBCP)
Date: 2003-01-03 15:01:57
Message-ID: D397A7FACCC45A44A0A207FD892961EA04A3749E@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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kovács Péter 2003-01-03 15:06:22 Re: Patch for streaming resultsets
Previous Message Patric Bechtel 2003-01-03 14:57:36 Re: Patch for streaming resultsets [Viruschecked]