Accessing the development database directly

You can access the development database while the test server is running or idle.

• WebSphere Commerce Test Server is running:

  For all development database types, to issue SQL statements against the WebSphere Commerce development database while the , use the following URL from the same machine that is running WebSphere Commerce Developer:

  http://localhost/webapp/wcs/admin/servlet/db.jsp
  

  This URL will provide an entry field where you can issue SQL statements that will run against your development database. This URL works for any valid development database type.

  I5/OS|(DB2) (Oracle) You can also use native database tools to access the database, for example a DB2 command window.

• WebSphere Commerce Test Server is not running:

  I5/OS|(DB2) (Oracle) Use native database tools to access the database, for example a DB2 command window.

  To issue SQL statements against the WebSphere Commerce development database when the WebSphere Commerce Test Server is not running, use the ij.bat utility to start a Cloudscape SQL session:

  1. Start a command prompt session.

  2. Navigate to the WCDE_installdir\bin directory.

  3. Issue the following command to start a Cloudscape SQL session

     ij.bat
     

  4. Issue the following command to connect to the WebSphere Commerce database

     connect '..\db\mall'; 
     

     You can now issue SQL statements that will run against your development database. Ensure that you end each of your SQL statements with a semicolon.

  5. To end your session, issue the following command: exit;

The ij.bat utility can also be used to run SQL scripts. To run an SQL script named script against your development database:

1. Shut down your WebSphere Commerce Test Server.

2. Start a command prompt session.

3. Navigate to the WCDE_installdir\bin directory.

4. Ensure that your script begins with the following statement

   connect '..\db\mall';
   

5. Issue the following command:

   ij.bat script

Only one process at a time can connect to the Cloudscape database. Therefore, ensure that the WebSphere Commerce Test Server is stopped before beginning an ij.bat session and, conversely, that the ij.bat session is ended before starting the WebSphere Commerce Test Server.

Related concepts

WebSphere Commerce development database
WebSphere Commerce development environment

Related tasks

Resetting the Cloudscape database to contain only bootstrap data
Switching between development database types