Setting up the Payment Service Provider Simulator database

In this lesson, you set up the Payment Service Provider Simulator database in WebSphere Commerce Developer.

Procedure

  1. Download the PSPSIMDB.zip file that contains the Payment Service Provider database to a temporary directory.
  2. Extract the file into a directory of your choice.
    For example, C:\
  3. Confirm that a directory named PSPSIMDB is created under the directory you choose in step 2.
  4. Open WebSphere Commerce Developer.
  5. Select the Java EE perspective.
  6. In the Enterprise Explorer view, expand PSPSim. Right-click Deployment Descriptor: PSPSim; click Open.
  7. In the Application Deployment Descriptor editor:
    1. Select the Deployment tab.
    2. In the JDBC provider list, select Derby JDBC Provider.
    3. In the Data source defined in the JDBC provider selected above list, select PSPSimDS.
    4. In the Resource properties defined in the data source selected above list, select databaseName and click Edit.
    5. In the Value field, type the full path of the directory in step 3.
      For example, C:\PSPSIMDB:

    PSPSIMDB deployment descriptors
  8. Save your changes and close the Application Deployment Descriptor editor.