Re: problem in getting Large Object from pooled PostgreSQL / Tomcat 6

ahmettemiz88 wrote:
> I am trying to Retrieve image ( Large Object) from pooled PostgreSQL /
> tomcat 6:
>
> I am having some exceptions from following
>
> ds = (DataSource) ctx.lookup("java:comp/env/jdbc/bzk2");
> Connection conn = ds.getConnection();
> PGConnection pgCon = (PGConnection) ((DelegatingConnection)conn) //
> ****exception
> .getInnermostDelegate();
>
> lobj = ((org.postgresql.PGConnection)pgCon).getLargeObjectAPI();
>
[...]
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource
> $PoolGuardConnectionWrapper cannot be cast to
> org.apache.commons.dbcp.DelegatingConnection
>
>
> how can I solve the problem ?

I don't thing that this has anything to do with PostgreSQL.

Neither an org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper
nor an org.apache.commons.dbcp.DelegatingConnection are part of the PostgreSQL
JDBC driver.

Yours,
Laurenz Albe