Changing database settings on an existing WebSphere Commerce instance
If you want to change database settings, such as the database host name or the port number, on an existing WebSphere Commerce instance, you must manually complete the changes.
Note: If you need to change database user and administrator passwords, you can update the WebSphere
Commerce configuration file and properties within the WebSphere Application Server administrative
console. For more information, see Changing database passwords.
Procedure
-
Change the values that correspond to the database settings that you changed.
Edit the following file in a text editor to ensure that the values match your database settings:
- WC_installdir/instances/instance_name/properties/createInstance.properties
- WC_userdir/instances/instance_name/properties/createInstance.properties
-
Change the values that correspond to the database settings that you changed.
Edit the following file in a text editor to ensure that the values match your database settings:
- WC_installdir/instances/instance_name/xml/instance_name.xml
- WC_userdir/instances/instance_name/xml/instance_name.xml
-
Ensure that your WebSphere Commerce instance is running and within a command-line utility,
go to the WC_installdir/bin directory. Run the following
script to propagate the change to wc-server.xml:
- config_ant -DinstanceName=instance_name UpdateEAR
- ./config_ant.sh -DinstanceName=instance_name UpdateEAR
-
Update the JDBC data sources in WebSphere Application Server administration console: