oracle / oracle-r2dbc

R2DBC Driver for Oracle Database
https://oracle.com
Other
197 stars 40 forks source link

CONNECTION_PROPERTY_PROXY_CLIENT_NAME not present in OracleR2dbcOptions #154

Open deb538 opened 1 week ago

deb538 commented 1 week ago

OracleConnection class (https://docs.oracle.com/en/database/oracle/oracle-database/19/jajdb/oracle/jdbc/OracleConnection.html) has a field CONNECTION_PROPERTY_PROXY_CLIENT_NAME image

We use this field in our application.

We are moving to R2DBC. Extended options supported by Oracle R2DBC in https://github.com/oracle/oracle-r2dbc/blob/main/src/main/java/oracle/r2dbc/OracleR2dbcOptions.java does not have field CONNECTION_PROPERTY_PROXY_CLIENT_NAME. image

Please review and let me if there is any other way to pass proxy client name or it needs a fix.

Michael-A-McMahon commented 1 week ago

We should add this into OracleR2dbcOptions. Let's leave this issue open as a reminder to do that.

Working with the current release of Oracle R2DBC, it should be possible to configure this as a system property "-Doracle.jdbc.proxyClientName=...", or you can configure this in a connection properties file.

deb538 commented 1 week ago

-Doracle.jdbc.proxyClientName=..." works. Thanks for your quick response. May I know when the code fix can be available.

Michael-A-McMahon commented 1 week ago

Sorry, but I can't commit to any timeline right now.