Changing the database to DB2 or Oracle instead of Apache Derby

If you want to use DB2 or Oracle as your database for the WebSphere Commerce development environment, you must customize Enterprise Deployment Utility to include extra tasks before replicating the environment onto multiple workstations.

You can create customizations by adding Apache Ant scripts and their properties under the custom directory:
  • WCDE_installdir/Enterprise Deployment/custom/build.xml
  • WCDE_installdir/Enterprise Deployment/custom/properties/custom.properties

Before you begin

  • Ensure that you set the enable_ALL properties to false in the WCDE_installdir/Enterprise Deployment/build/properties/install.properties file.
  • Ensure the database that you want to use is installed and configured on the workstations to which you are replicating the development environment.

About this task

This task calls the following scripts in this order:
  1. WCDE_installdir/setdbtype.bat
  2. WCDE_installdir/updatedb.bat
  3. WCDE_installdir/enableFeature.bat

Procedure

  1. Determine the parameters needed for each of the following scripts:
    • WCDE_installdir/updatedb.bat
    • WCDE_installdir/enableFeature.bat
    Run each of the scripts to print out the usage statement, which indicates the parameters that must be passed in.
    Note: The WCDE_installdir/setdbtype.bat does not require parameters.
  2. Add a target for each of the three scripts in the WCDE_installdir/Enterprise Deployment/custom/build.xml file.
  3. Add a property for each target in the WCDE_installdir/Enterprise Deployment/custom/properties/custom.properties file to turn on or off each target.
  4. Add the properties that you determined were needed in Step 1 to the WCDE_installdir/Enterprise Deployment/custom/properties/custom.properties for parameters that must be passed into the scripts.
  5. Replicate the environment onto multiple workstations.