Verifying your customization

In this lesson, you verify your customization by running the Data Load utility in the development environment.

Procedure

  1. Open WebSphere Commerce Developer.
  2. Apache DerbyEnsure that the WebSphere Commerce Server is stopped before you run the Data Load utility.
    For more information about stopping the 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\warranty\wc-dataload-warranty.xml.
    2. In the VM arguments field, set the following parameter
      -Dj2se
      Sets the Java platform type to J2SE. Set the value of 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; click User Entries, then add the following class path information:
    1. Apache DerbyDB2Oracle 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 Add JARs, then browse to the location of the Inventory-Server.jar and Price-Server.jar files in the WCDE_installdir/WC directory.
    3. 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 statements: 
    SELECT * FROM XWARRANTY;
SELECT * FROM XCAREINSTRUCTION;

    You see the warranty and care information content you specified in your XML file.