WebSphere Commerce Developer

Running the Data Load utility in the WebSphere Commerce development environment

Run the Data Load utility inside the development environment when testing customizations or when debugging issues with the utility. This configuration to run the utility is less time-consuming than first deploying to a runtime environment, then running the utility for test purposes.

Procedure

  1. Open WebSphere Commerce Developer.
  2. Click Run > Run Configurations.
    The Run Configurations dialog displays.
  3. 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

  4. Click the Arguments tab. Enter the following information:
    1. In the Program arguments field, type the path to the load order configuration file.
    2. In the VM arguments field, set the following parameter:
      -Dj2se=true
      Sets the Java platform type to J2SE. Set the value to true.
      -Djava.util.logging.config.file=..\workspace\WC\xml\config\dataload\logging.properties
      Enables the logging for the Data Load utility. The logging information is included in the logging.properties file in the workspace_dir\WC\xml\config\dataload directory.
    3. In the Working directory field, enter the WCDE_installdir/bin directory.

      Screen capture of the Run Configurations menu - Arguments Tab

  5. Click the Classpath tab; click User Entries, then add the following class path information:
    1. OracleDB2Apache Derby 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. Go to WC > xml, then click OK.

      Screen capture of the Run Configurations menu - Classpath tab

  6. Click Run.
  7. Verify the results of the load.