No handling of equals method for two connection object about datasource-proxy HOT 5 CLOSED

@sudhipanamdocs Thanks for the report.

While I'll take a look, as a workaround, you can use ProxyJdbcObject#getTarget to retrieve the original connection:

if (conn instanceof ProxyJdbcObject) {
    Connection original = (Connection) ((ProxyJdbcObject) conn).getTarget();
    // compare with another connection or its underlying connection if it is an another proxy
}

Out of curiosity, what is your usecase to make a proxy DataSource managed by a connection pool?
Usually, you want to observe how your application interacts with DataSource, not how the connection pool works with underlying DataSource unless you are writing your own connection pool, I presume.

So, in general, it is like:
Application -> Proxy DataSource -> Connection Pool Library -> Actual DataSource

from datasource-proxy.

@ttddyy I am not using Datasource, I am using raw jdbc to create Connections(Drivermanager.getconnection()). it is legacy application. To monitor jdbc calls we are using this library and creating connection proxy instead of connections by using jdkJdbcProxyFactory.createConnection().

from datasource-proxy.

@sudhipanamdocs Thanks for sharing the usage.

As a workaround, you may create another proxy on top of the created proxy connection to handle equals method.

class MyInvocationHandler implements InvocationHandler {
    @Override
    public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
        if (method.getName().equals("equals")) {
            Object target = args[0];
            if (proxy.equals(target)) {
                return true;
            }
            if (target instanceof ProxyJdbcObject) {
                Object originalConnection = ((ProxyJdbcObject)proxy).getTarget();
                Object targetOriginal = ((ProxyJdbcObject)target).getTarget();
                return originalConnection.equals(targetOriginal);
            }
            return false;
        }
        return method.invoke(proxy, args);
    }
}

from datasource-proxy.

@ttddyy Please release 1.10 version. We are waiting for it.

from datasource-proxy.

@ttddyy can we release the milestone 1.10 before other open issues for milestone.

from datasource-proxy.