We have this problem where we need to change the connecction-url to point to a different database while the app-server is still running.
We are running oracle.
I know that I can hot-deploy the change by changing the connection-url in the oracle-ds.xml.
I am just wondering instead of doing that, can I change the setting via the JMX console? I saw that there is a ManagedConnectionFactory seting for the specific pool?
Look for service=ManagedConnectionFactory
you should be able to set "ManagedConnectionFactoryProperties", which is an XML element.
You at least have to stop/start the service. I'm not sure if this works or not, however.