Updating the JDBC provider setting for the quick publish target
Quick publish is not supported in WebSphere Commerce Developer.
If database information for your production server changes, update the JDBC provider setting for the quick publish target.
To update the JDBC provider setting for the quick publish target, have the following information about your 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.
To update the JDBC provider setting for the quick publish target:
- Open the WAS console.
Refer to the Starting and logging off the console topic in the WAS Information Center.
- Select Resources > JDBC Providers.
- If necessary, set the scope to the application server containing WebSphere Commerce on your Authoring server.
For more information, refer to the Administrative console scope settings topic in the WAS Information Center.
- 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.
- Update the data source information for the quick publish target:
AIX|Linux|Solaris|Windows:
(DB2) 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.
I5/OS|(DB2) Perform 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 your 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.
(Oracle) 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 your 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 J2EE 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 your 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.
Related tasks
Updating the quick publish target
Create an authoring server
Create a task group
Related Reference
Workspaces commit and publishing options