Changing the jdbc connection-url using JMX console

[darwinl]

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?

-Darwin

[genman]

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.