Re: Using CopyManager with pooled JCA connection

> Try getPhysicalConnection()[1]. It's defined as returning an Object but internally it looks like it has the actual connection (in this case a java.sql.Connection). You'll probably just have to cast it to a java.sql.Connection.
>
> [1]: http://grepcode.com/file/repo1.maven.org/maven2/org.tranql/tranql-connector/1.6/org/tranql/connector/ManagedConnectionHandle.java/#32

Thanks for the link. I tried this but unfortunately it returns a proxy object:

import org.tranql.connector.jdbc.ConnectionHandle;
...
private BaseConnection getBaseConnection(Connection con)
{
BaseConnection temp = null;
if (con instanceof ConnectionHandle)
temp = (BaseConnection) ((ConnectionHandle) con).getAssociation().getPhysicalConnection(); // << exception here
else
temp = (BaseConnection) con;
return temp;
}

java.lang.ClassCastException: $Proxy46 cannot be cast to org.postgresql.core.BaseConnection