Apache DerbyWebSphere Commerce Developer

Configuring the development environment to use Apache Derby

You can return to using the Apache Derby for your development database if you are currently using another database.

About this task

You can return to using Apache Derby for your development database if you currently have one of the following databases configured:
  • DB2 database
  • WebSphere Commerce EnterpriseWebSphere Commerce - ExpressWebSphere Commerce ProfessionalOracle database
  • DB2 for IBM i

All data in the current database base is not affected when you configure the Apache Derby database.

Procedure

  1. Stop Rational Application Developer and the test server.
  2. Start a Windows command prompt session and switch to directory WCDE_installdir/bin.
  3. Issue the command: setdbtype cloudscape.
  4. Depending on your needs, perform one of the following commands.
    OptionDescription
    You are configuring the development environment to use a newly created Apache Derby database. Issue the following command:
    setdbtype cloudscape createdb
    This command creates and populates the Apache Derby development database and switches the development database to this newly created database.
    You are configuring the development environment to use an existing Apache Derby development database. Issue the following command:
    setdbtype cloudscape
    This command switches the current development database to the existing Apache Derby database.
  5. Re-enable any features you are using by running feature enablement.
    See WebSphere Commerce feature packs. There is no need to disable any enabled features.
    WebSphere Commerce DeveloperIntroduced in Feature Pack 2Note: If you enabled search, re-build the search index.
  6. When the command completes, restart the WebSphere Commerce server.