You can change the database drivers that the Extract utility uses by doing the following:
- Follow the step appropriate to your platform:
- Extract the DB2ConnectionCustomizer.properties file from the MassExtract.zip archive in the following directory:
WC_installdir/lib/loader
WC_installdir\lib\loader
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.
Copy 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.
- Extract the DB2ConnectionCustomizer.properties file from the MassExtract.zip archive in the following directory:
- 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:@).