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

On Tue, Dec 23, 2008 at 3:12 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> 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.
>

Dave