my integration requires a connection to a Oracle database which requires the logged in session to set the password to the database role.
after logging in, i have to run the following…
“set role <rolename> identified by ‘<password>’;”
I’ve thought of putting the above statement into a startup service of the packages that needs it but is not sure if it would work.
Basically, the concern is with connection pooling.
When the jdbc adapter only up the connection to the database as and when it’s needed. And these “new” sessions will not have executed the above sql statement.