COPY using Hibernate

Hello All,

I am using C3p0 for connection pooling using hibernate. The connection object returned by that pool does not provide the COPY from STDIN functionality. Have also checked with the apache dbcp pooling mechanism. I am using JDBC4 driver with JDK1.6.
As I understand, to support COPY operation of postgres using JDBC, the connection object should be an implementation of "PGConnection" interface.

I am able to perform the COPY operation if I do not use any connection pooling.

I am curious to know, if postgres provide some sort of connection pooling API which I can integrate in Hibernate and then use the COPY operation ?

Thanks,
Vaibhav.

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/