Configuring the Extract utility

You can change the database drivers that the Extract utility uses by doing the following:

  1. Follow the step appropriate to your platform:
    1. Extract the DB2ConnectionCustomizer.properties file from the MassExtract.zip archive in the following directory:
    2. WebSphere Commerce development environment Extract the DB2ConnectionCustomizer.properties file from the wcs.jar archive in the WCDE_installdir\AppServer\classes\ directory.

    Rename the extracted file and place it in a directory that is in the classpath.

    Important: Do not remove or modify the existing DB2ConnectionCustomizer.properties file.

    • i5/OSiSeriesCopy the ISeries_EXTWCSDTA_Customizer.properties file from the following directory:

      /QIBM/ProdData/Commerce56/properties

      to a directory that is in the classpath, rename the new file but keep the .properties extension. Make the necessary changes to this new file.

      Important: Do not remove or modify the original ISeries_EXTWCSDTA_Customizer.properties file.

  2. Modify the database-driver values in the new file.
    DBVendorName = DB2
    DBDriverName = COM.ibm.db2.jdbc.app.DB2Driver
    DBURL = jdbc:db2:
    

    where:

    DBVendorName
    The database type.
    The options are DB2 Universal Database for iSeries (DB2/iSeries), DB2 for other operating systems (DB2), and the Oracle database (Oracle).
    DBDriverName
    The JDBC driver. The options are DB2 Universal Database for iSeries (com.ibm.db2.jdbc.app.DB2Driver), DB2 for other operating systems (COM.ibm.db2.jdbc.app.DB2Driver), and the Oracle database (oracle.jdbc.driver.OracleDriver).
    DBURL
    The URL to access the database. The options are DB2 Universal Database for iSeries (jdbc:db2://), DB2 for other operating systems (jdbc:db2:), and the Oracle database (jdbc:oracle:oci8:@).

Feedback