Develop > Persistence layer > Data assets > Work with the Data load utility


Run 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 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 new Java Application configuration. Double-click the Java Application on the left panel; then on the Main tab, enter the following information:

    1. In the Name field, type a name for the 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.

  4. Click the Arguments tab; then 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

      Sets the Java platform type to J2SE. Set this to true.

    3. In the Working directory field, enter the WCDE_INSTALL/bin directory.

  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.

      WCDE_INSTALL\lib\derby.jar

      db2_installdir\java\db2jcc4.jar

      oracle_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_INSTALL/WC directory.

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

  6. Click Run.

  7. Verify the results of the load.

Related reference

Data Load utility