We have IVR application project with Database Connector.
It works fine.
But customer does something with it's own environment and changes database location to frequently.
I want to let the customer to set database URL in Configuration parameters. So, at connect time just read configuration variable and use it instead of the one which was set ( in Pluggable Connector -> Database Configuration -> JDBC Data Sources).
How to correctly set the database connection URL at runtime?
Will it be correct to add java code in db operation java class in constructor method, after tag
ConnectionProperties props = getConnectionProperties();
Will it be enough?
And another question is how to configure failover path for a database connection at runtime?
Thanks in advance for your help!