Introduced in Feature Pack 3

Verifying your customization

Introduced in Feature Pack 3 In this step of the tutorial, you verify your customization by running the Data Load utility in WebSphere Commerce Developer.

Procedure

  1. Open WebSphere Commerce Developer.
  2. Apache DerbyEnsure that your WebSphere Commerce Server is stopped before you run the Data Load utility.
    For more information about stopping your server, see Starting and stopping WebSphere Commerce Test Server.
  3. Click Run > Run Configurations.
    The Run Configurations dialog displays.
  4. Create a Java Application configuration.
    Double-click the Java Application on the left panel. On the Main tab, enter the following information:
    1. In the Name field, type a name for your configuration.
    2. In the Project field, enter the project WebSphereCommerceServerExtensionsLogic.
    3. In the Main class field, enter the class name com.ibm.commerce.foundation.dataload.DataLoaderMain.

      Screen capture of the Run Configuration menu - Main Tab

  5. Click the Arguments tab; then enter the following information:
    1. In the Program arguments field, enter ..\samples\DataLoad\Member\Password\wc-dataload.xml.
    2. In the VM arguments field, set the following parameters
      -Dj2se
      Sets the Java platform type to J2SE. Set the value for the parameter to true.
      -Djava.util.logging.config.file
      Sets the JVM parameter. Set the value of the parameter to ..\workspace\WC\xml\config\dataload\logging.properties.
    3. In the Working directory field, enter the WCDE_installdir/bin directory.

      Screen capture of the Run Configuration menu - Arguments Tab

  6. Click the Classpath tab; then click User Entries and add the following class path information:
    1. Click Add External JARs, then browse to the location of the JDBC driver JAR file for the specific database you are using. Click Open.

      Apache DerbyWCDE_installdir\lib\derby.jar

      DB2db2_installdir\java\db2jcc4.jar

      Oracleoracle_installdir\jdbc\lib\ojdbc6.jar

    2. Click Advanced > Add Folder, then click OK. Navigate to WC > xml, then click OK.

      Screen capture of the Run Configurations menu - Classpath tab

  7. Click Run.
  8. Verify your results by running the following SQL statement: 
    Select * from userreg
    The USERREG database table displays the content that you specified in your CSV file.
    Customization results in the USERREG database table
    Customization results in the SALT column of the USERREG database table
  9. Open your store in an internet browser.
  10. Click Sign In and log on to the store with the following user credentials:
    User name Password
    jacobsmith shopper1

    Screen capture of My Account Summary page for Jacob Smith
    This user information is defined in the MemberDataload_Password.csv file and loaded into the WebSphere Commerce database.