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 ?
You have to get the underlying connection from the pooled connection.