Changing the database to DB2 or Oracle instead of Apache Derby
You can change your database type 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 you replicate 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 tofalse
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
- WCDE_installdir/setdbtype.bat
- WCDE_installdir/updatedb.bat
Procedure
-
Determine the parameters that are needed for the
WCDE_installdir/updatedb.bat script:
Print the usage statement, which indicates the parameters that must be passed in.Note: The WCDE_installdir/setdbtype.bat does not require parameters.
- Add a target for each of the three scripts in the WCDE_installdir/Enterprise Deployment/custom/build.xml file.
- Add a property for each target in the WCDE_installdir/Enterprise Deployment/custom/properties/custom.properties file to turn on or off each target.
- 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.
- Replicate the environment onto multiple workstations.