HCL Commerce Developer

Running the Data Load utility in the HCL Commerce development environment

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

Procedure

  1. Open HCL 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\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\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. Click Add External JARs, then browse to the location of the JDBC driver JAR file for the specific database you are using. Click Open.

      DB2db2_installdir\java\db2jcc4.jar

      Oracleoracle_installdir\jdbc\lib\ojdbc6.jar

      HCL Commerce Version 9.1.12.0 or laterUse the file ojdbc8.jar in both Oracle Database and IBM Db2 Database Db2 configurations.

    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.