Bug Report: Connection proxy returned by unwrap() throws UndeclaredThrowableException instead of SQLException #8487

Brief Summary

The InvocationHandler in ConnectionHolder40.getProxyObject doesn't unwrap InvocationTargetException:

return method.invoke(actualObject, args);

As a result, every SQLException thrown by a method on the connection returned by unwrap(OracleConnection.class) (or any other vendor interface) arrives as an UndeclaredThrowableException, so catch (SQLException e) doesn't catch it.

This is the same bug as #216, which was fixed only in ProfiledConnectionWrapper40.

Expected Outcome

The driver's SQLException is rethrown unchanged:

try {
    return method.invoke(actualObject, args);
} catch (InvocationTargetException e) {
    throw e.getCause();
}

Current Outcome

An UndeclaredThrowableException is thrown, wrapping an InvocationTargetException that wraps the original SQLException.

Reproducer

Oracle pool, ojdbc17 23.26.2.0.0:

try (Connection con = dataSource.getConnection()) {
    OracleConnection ora = con.unwrap(OracleConnection.class);
    ora.setTransactionIsolation(12345); // expected: SQLException ORA-17030, actual: UndeclaredThrowableException
}

Operating System

Windows 11 Pro

JDK Version

Adoptium jdk-21.0.8.9-hotspot

Payara Distribution

Payara Server Full Profile