Re: pg jdbc and dbcp error

tfinneid@student.matnat.uio.no wrote:
> Hi
>
> I am having problems getting apache DBCP to work with pg jdbc.
> It is claiming it can't convert a Connection into a PGConnection.
>
> the sentence throws the exception is something like this:
>
>     Connection con = ds.getConnection()    \\ DBCP BasicDataSource
>    ((PGConnection)con).getCopyAPI.copyIntoDB("COPY attr (val1) from
> STDIN"), stream);
>
> the error message is (the message is handcopied so I might make mistakes)
>
> ClassCastException:
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper can
> not be cast to org.postgresql.PGConnection
>
>
> Anybody got any ideas whats wrong? the getConnection() returns a
> javax.sql.Connection object, so casting it to PGConnection should not be a
> problem.
>
>

This is an incorrect assumption.  Just because PGConnection implements
Connection, it doesn't mean what DBCP is giving you is an instance of
PGConnection.

Evidently ds.getConnection() is handing you back an instance of
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper,
which implements Connection, but *is not* an instance of PGConnection,
hence the ClassCastException.  I don't use DBCP, but from the name
"PoolGuardConnectionWrapper", it would seem there's an instance of
PGConnection inside this object, to which the wrapper object delegates.

Regards,
Eric Faulhaber