From: | tfinneid(at)student(dot)matnat(dot)uio(dot)no |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Cc: | kato(at)iki(dot)fi |
Subject: | pg jdbc and dbcp error |
Date: | 2007-10-01 14:20:30 |
Message-ID: | 34154.134.32.140.234.1191248430.squirrel@webmail.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
Using the driver
podtgresql-jdbc-8.2-505-copy-20070719.jdbc3.jar
which contains a pathc for COPY functionality
(http://kato.iki.fi/sw/db/postgresql/jdbc/copy/)
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Lewis | 2007-10-01 14:40:21 | Re: pg jdbc and dbcp error |
Previous Message | tfinneid | 2007-10-01 13:44:49 | pg jdbc and dbcp |