We need a way to set the v$session.program at the connection from a R2DBC Oracle connection and after reviewing documentation and stack overflow I haven't found a way to do it
(my case is within a Spring application, but I believe this to be irrelevant)
Is your feature request related to a problem? Please describe
We've tried some solutions including this but without success.
ConnectionFactories.get( ConnectionFactoryOptions.parse(dbUrl) .mutate() .option(Option.valueOf("v$session.program"), "PROGRAMNAME") .build());
Reviewing the driver source code, it seems the property would need to be supported at the OracleReactiveJdbcAdapter::JDBC_CONNECTION_PROPERTY_OPTIONS Set
Describe the solution you'd like
Any other way to achieve the same goal would be useful.
If this is already possible please excuse me, but I haven't found one.
joao-rebelo
commented
2 years ago
Feature Request
We need a way to set the v$session.program at the connection from a R2DBC Oracle connection and after reviewing documentation and stack overflow I haven't found a way to do it (my case is within a Spring application, but I believe this to be irrelevant)
Issue opened there without answers: https://stackoverflow.com/questions/72048278/specify-vsession-program-for-r2dbc-oracle-connection
Is your feature request related to a problem? Please describe
We've tried some solutions including this but without success.
ConnectionFactories.get( ConnectionFactoryOptions.parse(dbUrl) .mutate() .option(Option.valueOf("v$session.program"), "PROGRAMNAME") .build());Reviewing the driver source code, it seems the property would need to be supported at the OracleReactiveJdbcAdapter::JDBC_CONNECTION_PROPERTY_OPTIONS Set
Describe the solution you'd like
Any other way to achieve the same goal would be useful.
If this is already possible please excuse me, but I haven't found one.