> 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