You can use Cloudscape’s sysinfo tool to check the versions of Cloudscape PRodUCts. Once you have the bin Directory in your PATH, you can run sysinfo by typing the following command in a command window:
sysinfo
The sysinfo script sets the appropriate environment variables, including class path, and executes the sysinfo program.
Running ij
You can use the ij tool to connect to a Cloudscape database. Once you have the bin directory in your PATH, you can execute the ij command by typing the following:
ij
The ij script sets up environment variables like class path and executes the ij program.
To create a database with ij, type the following command: ij> connect ’jdbc:cloudscape:testdb;create=true’;
This command creates the database called testdb in the current directory and populates the system tables. You can then execute any SQL statements from the ij command line. When you are ready to leave ij, type:
ij> exit;
See the IBM Cloudscape Tools and Utilities Guide for more information on running ij.
If you cannot run the scripts for the Cloudscape tools and utilities, you must complete certain steps manually. The following topics show how to manually set your environment and run the tools manually.
The installation program asked you to choose a base directory where the software was installed; we recommended that you name it Cloudscape_10. This document refers to that directory as the Cloudscape base directory.
If you do not plan to use the scripts in the frameworks/embedded/bin directory and your Operating system supports it, create an environment variable called CLOUDSCAPE_INSTALL and set its value to the path of the Cloudscape base directory. For example, if you installed the product in c:/Cloudscape_10, set CLOUDSCAPE_INSTALL to c:/Cloudscape_10:
set CLOUDSCAPE_INSTALL=c:/Cloudscape_10
The JVM (compiler or interpreter) needs to know the path (operating system instructions about location) of every class file needed by your application. The class path is a list of the class libraries needed by the JVM and other java applications in order to run your program.
There are two ways to set the class path. You can set the operating system’s CLASSPATH environment variable permanently or temporarily. If you set the environment variable temporarily, you must set it each time you open a new command window. Alternatively, you can set the class path with the runtime option, which means specifying the class path at the time you start your Java application and the JVM.
In most development environments, it works best to set the operating system’s CLASSPATH environment variable temporarily. Cloudscape provides some scripts to help you set your class path this way; they are found in theframeworks/embedded/bin directory or the frameworks/NetworkServer/bin directory. Run a script every time you open a new command window.
For example, you can set your class path as follows:
set CLASSPATH=%CLOUDSCAPE_INSTALL%/lib/cs.jar; %CLOUDSCAPE_INSTALL%/lib/cstools.jar;%CLASSPATH%
To manually run the sysinfo utility, type the following in a command window or shell:
java com.ihost.cs.tools.sysinfo
To manually run the ij utility, type the following in a command window or shell:
C:/>java com.ihost.cs.tools.sysinfo------------------ Java Information ------------------Java Version: 1.4.2_04Java Vendor: Sun Microsystems Inc.Java home: C:/Program Files/Java/j2re1.4.2_04Java classpath: .;E:/Program Files/J2EE_SDK/lib/J2EE.jar;E:/Program Files/IBM/Cloudscape_10.0/lib/cs.jar;E:/Program Files/IBM/Cloudscape_10.0/lib/cstools.jar;E:/Program Files/IBM/Cloudscape_10.0/lib/csnet.jar;E:/Program Files/J2EE_SDK/jdk/lib/tools.jar;E:/Program Files/J2EE_SDK/jdk/lib/dt.jar;OS name: Windows xpOS architecture: x86OS version: 5.1Java user name: tsuijyJava user home: D:/SettingsJava user dir: C:/--------- Cloudscape Information --------[E:/Program Files/IBM/Cloudscape_10.0/lib/cs.jar] 10.0.1.0 beta - (29729)[E:/Program Files/IBM/Cloudscape_10.0/lib/cstools.jar] 10.0.1.0 beta - (29729)[E:/Program Files/IBM/Cloudscape_10.0/lib/csnet.jar] 10.0.1.0 beta - (29729)----------------------------------------------------------------------- Locale Information -----------------------------------------------------------------------
C:/>java com.ihost.cs.tools.ijij version 10.0 (c) 1997, 2004 IBM Corp.ij>
Used without additional arguments, the -cp option tests for all Cloudscape libraries, outputting the libraries it can find as well as the ones it cannot, as shown below:
C:/>java com.ihost.cs.tools.sysinfo -cpTesting for presence of all Cloudscape-related libraries; typically, only some are needed.For a list of possible arguments, type java com.ihost.cs.tools.sysinfo -cp argsFOUND IN CLASS PATH: Cloudscape embedded engine library (cs.jar) Cloudscape Network Server library (csnet.jar) Cloudscape tools library (cstools.jar)
NOT FOUND IN CLASS PATH: Cloudscape Client libraries (db2jcc.jar) (com.ibm.db2.jcc.DB2Driver not found.)
试一试： E:/Program Files/IBM/Cloudscape_10.0/demo/programs/simple>java com.ihost.cs.tools.sysinfo -cp SimpleApp.classFOUND IN CLASS PATH: user-specified class (SimpleApp) SUCCESS: All Cloudscape related classes found in class path.
