Download Brazil Project source Code and Cloudscape

History of Informix Cloudscape and Modern Alternatives

Instructions

1. Download the JDBC course resource file.
   1. Once you have downloaded the JDBC course resource file, unzip it into a new directory of its own. A suggested location is on your C: drive with the name JDBC Course.
   
   
2. Download and install the latest version of Oracle's Java Development Kit (JDK) from the following link: Download Oracle JDK
   If you already have a JDK installed on the system where you will run the JDBC exercises, you can skip this step.
   1. Look on that page for a link to the "JavaTM 2 SDK, Standard Edition" and follow it. The site will next present you with a choice of downloads targeted to specific platforms. Choose the one for the platform you intend to use. Depending on the platform you choose, this page may also offer a link that will take you through the process of downloading the JDK documentation set. This is equivalent to performing step 3 below.
   2. Look through the page and locate the prompt that will allow you to start the SDK download.
      The appearance of these pages may differ from target platform to target platform.
      Again, continue to follow the links to start the download itself.
   3. Once the download has completed, run the downloaded executable or unarchive the download, as appropriate, and follow the supplied directions for installing the SDK.
   
   
3. Optional:
   If you have the documentation installed for your JDK, you can skip this step. You will not need this documentation to complete the exercises. You also will not need this if you intend to use the on-line set of documents provided by Oracle. It's recommended that you have access to some form of the documentation because it will be referenced occasionally in the course and, more importantly, it is an indispensable reference as you continue to work with Java. Otherwise, follow the links for the "JavaTM 2 SDK, Standard Edition Documentation." If you are using an SDK with a different version number than that shown on this page, you may have to do a little detective work to search for the appropriate download link. Likewise, if you use a non-Oracle SDK, you will have to seek out that download with the SDK vendor.
   
   
   1. Once the download has completed, run the downloaded executable or unarchive the download, as appropriate, and follow the supplied directions for installing the documentation set.
   
   
4. Download and install Cloudscape database. Go to the Cloudscape Web site and look for a link that will direct you to a page where you can download the software. As of the date this course was written, Cloudscape offered a developer's version of their product free of charge. A developer does have to register with Cloudscape to be eligible to download the software. The download links will lead you through that process. Complete those pages and download the Cloudscape archive file.
   1. The developer's version of Cloudscape is packaged in a zip file. Once that file has been downloaded, unzip it into a directory of its own. This should be a different directory from the one you created in Step 1.

Set your Environment and test the Installation

5. Set your environment.
   1. After downloading the JDBC course file and Cloudscape, complete the setup by editing the setjv102env.bat script. This script will properly set the environmental variables so your programs can find the resources they need to run. It must be run every time you start a command line session in which you will work on your JDBC labs.
   2. Check the setjv102env.bat file to see that the variables JAVA_HOME and CloudscapeHome are correctly set. JAVA_HOME should reflect the root directory for the Java SDK files. CloudscapeHome should reflect the root directory of the Cloudscape files. View the code below to see the listing of the original setjv102env.bat file:

 
echo off
rem
rem  Set the location of the java sdk and then include the java utilities 
rem  in the pathBE SURE the JAVA_HOME variable is set to the proper 
rem  location for the root of the JAVA SDK directories
rem
set JAVA_HOME=C:\jdk1.7
set path=%JAVA_HOME%\bin;%PATH%
rem
rem  Point to the proper location for Cloudscape and include it in the classpath.  
rem  BE SURE the CloudscapeHome variable is set to the root of the Cloudscape files.
rem 
set CloudscapeHome=D:\Cloudscape
set CLASSPATH=%CLOUDSCAPEHOME%\lib\cloudscape.jar;
%CLOUDSCAPEHOME%\lib\tools.jar;%CLASSPATH%;

6. OPTIONAL: test your installation.
   1. Run the following command to test and verify that Cloudscape can be run with the .bat file set above.
   2. Open a command line session and navigate to the directory that contains the setj102env.bat file.
   3. Run the script file and then, from the command prompt, run the command:
      

      java COM.cloudscape.tools.sysinfo
      

   
   View the code below to see the output:

------------------ Java Information ------------------
Java Version:    1.4.0
Java Vendor:     Oracle Microsystems Inc.
Java home:       C:\Program Files\JavaSoft\JRE\1.4
Java classpath:  D:\Cloudscape\lib\cloudscape.jar;D:\Cloudscape\lib\tools.jar;.;
OS name:         Windows 2000
OS architecture: x86
OS version:      5.0
Java user name:  Administrator
Java user home:  C:\Documents and Settings\Administrator
Java user dir:   D:\JDBCCourse
---------------- Cloudscape Information --------------
[D:\cloudscape\lib\cloudscape.jar] 3.6.4 - (20531)
[D:\cloudscape\lib\tools.jar] 3.6.4 - (20531)
[D:\cloudscape\lib\cloudscape.jar] 3.6.4 - (20531)
[D:\cloudscape\lib\tools.jar] 3.6.4 - (20531)
[License Type] Evaluation. Valid.