How to change database settings for a deployed war file?

Question

We have a WAR file that is deployed however we want to change the database settings. How do I get about doing that? I opened the WAR file in an IDE and there are like 2-3 places that have the database settings. What is the proper way of changing it?

Thank You

Answer 1

The proper way is to use a datasource at the application level and to administer it at the application server level. Check the MySQL DBCP Example in the Tomcat documentation.

Answer 2

The tomcat instance should be set up to provide a datasource through JNDI.