'Specify v$session.program for R2DBC Oracle connection

I was trying to set the v$session.program at the connection from a R2DBC Oracle connection (within a Spring application)

For now I've tried this but without success. ConnectionFactories.get(ConnectionFactoryOptions.parse(dbUrl).mutate().option(Option.valueOf("v$session.program"), "PROGRAMNAME").build());

Would this be possible to set in any way?

Thanks for help.

oracle r2dbc

Solution 1:^[1]

Oracle R2DBC 0.4.0 does not support the v$session properties as ConnectionFactoryOptions. However, I think it should, so I'll be adding support for that in the next release of Oracle R2DBC.

If anyone needs a temporary workaround, these properties can be set as JVM system properties. System properties will bypass Oracle R2DBC's connection property filter.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Michael McMahon

'Specify v$session.program for R2DBC Oracle connection

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]