r2dbc/r2dbc-pool

Allow to specify v$session.program for connection

joao-rebelo opened this issue · 1 comments

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.

wrong github.. sory