Administer > Manage WebSphere Commerce features > Enable Workspaces > Update the quick publish target
Update the JDBC provider setting for the quick publish target
If database information for the production server changes, update the JDBC provider setting for the quick publish target.
Before you begin
To update the JDBC provider setting for the quick publish target, have the following information about the production server database ready:
- Database name
- Database user name (user ID)
- Database user password
- Fully qualified database server host name
- Database server port
You will also need the name of the JDBC data source entered on the Staging page of the Instance Creation wizard when you originally created the authoring server instance.
Quick publish is not supported in WebSphere Commerce Developer.
Procedure
- Open the WebSphere Application Server administrative console..
- Select Resources > JDBC Providers.
- If necessary, set the scope to the application server containing WebSphere Commerce on the Authoring server.
For more information, refer to the Administrative console scope settings topic in the WebSphere Application Server Information Center.
- Click the JDBC provider for the quick publish target.
- Click Data sources.
- Click the data source for the quick publish target. The required name for the data source is WebSphere Commerce DBMS_name Publish DataSource instance.
- Update the data source information for the quick publish target:
- Change the value in the Database name field (under DB2 legacy CLI-based type 2 data source properties) to the name of production server database as cataloged on the authoring server.
- Execute the following steps:
- Change the value in the Database name field (under DB2 UDB for iSeries (native or Toolbox) data source properties) to the name of the production server database.
- Click Custom properties.
- Click URL.
- Change the value in the Value field to point to the production database. The URL can have either of the following formats, depending on the JDBC driver:
where:
- Native i5/OS JDBC driver
- jdbc:db2://hostname:port:/ database_name jdbc:db2://hostname/ database_name
- IBM Toolbox for Java JDBC driver
- jdbc:as400://hostname:port:/ database_name jdbc:as400://hostname/ database_name
- hostname
- The fully qualified host name of the machine hosting the production server database.
- port
- (Optional) The port used for database communication with the production server database.
- database_name
- The name of the production database.
- Click OK.
- Return to the page for the data source for the quick publish target.
- Change the value in the URL field (under Oracle data source properties) to point at the production server database. Depending on the Oracle JDBC driver you use, the URL has the following format:
where:
- Oracle thick JDBC driver
- jdbc:oracle:oci8:@hostname:port:SID
- Oracle thin JDBC driver
- jdbc:oracle:thin:@hostname:port:SID
- hostname
- The fully qualified host name of the machine hosting the production server database.
- port
- The port used for database communication with the production server database
- SID
- The Oracle SID of the production server database.
- Click OK and then save the changes to the master configuration.
- Confirm the user ID and password required to access the production database:
- Select Resources > JDBC Providers.
- Click the JDBC provider for the quick publish target.
- Click Data sources.
- Click the data source for the quick publish target. The default name for the data source is:
WebSphere Commerce DBMS_name Publish DataSource instance
- Take note of the entry in the Component-managed authentication alias field. The default name for the authentication alias for the production database is:
WC_instance - authDataAlias for Publish
- Click Connector Architecture (J2C) authentication data entries.
- Click the entry you noted earlier.
- Confirm that the user ID is the correct user ID for the production database. If the user ID is not correct, change the user ID and enter the correct password for the user ID.
- Click OK and then save the changes to the master configuration.
- Click Logout and follow any additional prompts. If you are prompted about unsaved changes, save the changes to the master configuration.