•  Print this page
    Print this page

Cloudscape
 
 
Cloudscape (an IBM product) is a relational SQL DBMS written in the Java programming language. Cloudscape does not require much memory or disk space, and it is easy to administer. The Java 2 SDK, Enterprise Edition v. 1.3.1 includes a version of the Cloudscape DBMS (v. 4.0.6). Cloudscape supports entry-level SQL-92.

In August 2004 IBM contributed the code to the Apache Software Foundation as Derby.
In March 2007 IBM announced that they would withdraw marketing and support for the Cloudscape product.

More information about Derby can be found at: http://db.apache.org/derby/

Quick guides







Installing Cloudscape.



Information
J2EE 1.3.1 includes a version of the Cloudscape DBMS (v. 4.0.6).

Operating system used
Windows XP Home Edition Version 5.1 SP 2

Software prerequisites
J2EE SDK version 1.3.1

Procedure
  1. When J2EE 1.3.1 is installed, Cloudscape can be found in:
    %J2EE_HOME%\cloudscape

  2. In directory "%J2EE_HOME%\lib\system" the following jar files can be found: cloudscape.jar and cloudutil.jar. Add these files into your classpath e.g.:

    CLASSPATH=%CLASSPATH%;
    %J2EE_HOME%\lib\system\cloudscape.jar;
    %J2EE_HOME%\lib\system\cloudutil.jar

    These jar files are needed if you want to use Cloudscape sysinfo tool.

  3. To start Cloudscape, type:

    %J2EE_HOME%\bin\cloudscape -start

    You should see:

    xxx [RmiJdbc] Starting Cloudscape RmiJdbc Server Version 1.7.2 ...
    xxx [RmiJdbc] COM.cloudscape.core.JDBCDriver registered in DriverManager
    xxx [RmiJdbc] Binding RmiJdbcServer...
    xxx [RmiJdbc] No installation of RMI Security Manager...
    xxx [RmiJdbc] RmiJdbcServer bound in rmi registry



  4. To stop Cloudscape, type:

    %J2EE_HOME%\bin\cloudscape -stop

    You should see:

    URL=[jdbc:rmi:jdbc:cloudscape:]
    Attempting to shutdown RmiJdbc server
    RmiJdbc Server RmiAddr is: //XXXXXX/RmiJdbcServer
    WARNING: Shutdown was successful!

  5. To use Cloudscape sysinfo tool, type:

    java COM.cloudscape.tools.sysinfo

    You should see:

    ---------------- Cloudscape Information --------------
    [C:\Tools\java\j2sdkee1.3.1\lib\system\cloudscape.jar] 4.0.6 - (22602)
    [C:\Tools\java\j2sdkee1.3.1\lib\system\cloudutil.jar] 4.0.6 - (22602)
    [License Type] Development. Valid.
    ----------------------------------------------------

    Note: Make sure the versions (4.0.6) are both the same.