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
  • Oracle 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 and switch to the WCDE_installdir/bin directory.
  3. Issue the setdbtype cloudscape command.
  4. Issue one of the following commands, depending on your needs.
    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. When the command completes, restart the WebSphere Commerce Test server.