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.
-
Change the values that correspond to the database settings that you changed.
-
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 the WebSphere Application Server administration console. Ensure
that you have updated the sources on both the WebSphere Commerce server and the Solr server if Solr
is running on a separate node.
-
Log on to the WebSphere Application Server administration console.
-
Expand . Click Datasources
-
For each of the following data sources for your instance, update the values for any of the
database settings that you want to change.
- jdbc/WebSphere Commerce DataSource
- jdbc/WebSphere Commerce Publish DataSource
Ensure that you change the User ID and Password preferences for the data sources. To change the
ID and Password, click
JAAS J2C authentication data in the
Related
items section of the data source configuration tab. In the list of data sources, select
the data source that you want to update. In the list of
General Properties,
change the ID and Password and then click .
-
Save the changes
-
If you are running WebSphere Commerce Version 6 or earlier, the data source information will
not be automatically updated in the wc-data-config.xml configuration file. Edit
the wc-data-config.xml file and manually update the url
parameter of the
dataSource
element to point to the new source.
-
Restart the WebSphere Commerce Server.