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. More information about Cloudscape can be found at:
http://www-3.ibm.com/software/data/cloudscape/

Cloudscape documents can be found at:
http://www-3.ibm.com/software/data/cloudscape/pubs/collateral.html

The latest Cloudscape version can be downloaded from:
http://www-3.ibm.com/software/data/cloudscape/

rss

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.