Re: Using CopyManager with pooled JCA connection - Mailing list pgsql-jdbc

> 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