Use the New Database Connection wizard or pages that are embedded in other wizards to create a JDBC connection to Cloudscape™.
You can download the DB2 JDBC drivers at www.ibm.com/software/data/db2/.The DB2 Universal Driver is included with the DB2 Application Development Client. This driver is a two tier pure Java™ JDBC driver that allows a Java client to communicate directly with DB2 UDB servers through the DRDA® protocol. This driver supports both Type 2 connections (to databases that are cataloged on your local computer) and Type 4 connections (using a host, database name, and port). This driver is designed to replace the Type 3 Net driver.
When you connect to a newly installed Cloudscape database, you will receive two error messages. These messages result from the some initialization steps that the database performs when you first connect to it. These messages are expected and do not indicate an error that requires your action.
The first message occurs when you finish creating a connection to a Cloudscape database: "IWAS0126E Problems encountered while trying to establish connection Con1. Reason: Database upgrade succeeded. The upgraded database is now ready for use. Revalidating stored prepared statements failed. See next exception for details of failure. Correct problem and recompile before executing prepared statement. See "ALTER STATEMENT RECOMPILE"."
The second message occurs when you click OK to the first message and then complete the connection again: "Problems encountered while importing from catalog. Reason: One or more problems were reported while accessing the database."