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:

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:

  1. Open the WAS console.

    Refer to the Starting and logging off the console topic in the WAS Information Center.

  2. Select Resources > JDBC Providers.

  3. 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.

  4. Click the JDBC provider for the quick publish target.

  5. Click Data sources.

  6. Click the data source for the quick publish target. The default name for the data source is WebSphere Commerce DBMS_name Publish DataSource instance.

  7. 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:

      1. 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.

      2. Click Custom properties.

      3. Click URL.

      4. 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:

        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
        where:

        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.

      5. Click OK.

      6. 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:

      Oracle thick JDBC driver

      jdbc:oracle:oci8:@hostname:port:SID

      Oracle thin JDBC driver

      jdbc:oracle:thin:@hostname:port:SID
      where:

      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.

  8. Click OK and then save your changes to the master configuration.

  9. Confirm the user ID and password required to access the production database:

    1. Select Resources > JDBC Providers.

    2. Click the JDBC provider for the quick publish target.

    3. Click Data sources.

    4. Click the data source for the quick publish target. The default name for the data source is:

      WebSphere Commerce DBMS_name Publish DataSource instance

    5. 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

    6. Click J2EE Connector Architecture (J2C) authentication data entries.

    7. Click the entry you noted earlier.

    8. 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.

    9. Click OK and then save your changes to the master configuration.

  10. 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