Cloudscape database connections

Use the New Database Connection wizard or the Database Connection page to create a JDBC connection to Cloudscape.

Restriction: Multiple connections to a single Cloudscape database are not supported due to a Cloudscape configuration limitation. Attempting to connect to the same database more than once within this product might cause the workbench to stop.

The Cloudscape Embedded JDBC Driver is supported for Cloudscape.

The Cloudscape Embedded JDBC Driver is included with the Cloudscape product. You can download Cloudscape and this driver from http://www-306.ibm.com/software/data/cloudscape/

To connect to Cloudscape databases, specify the following information. Other fields should be filled in as described in the pop-up help.

Database location

Type the absolute directory path to where Cloudscape data is stored on your file system.

To create a new Cloudscape database, use one of the following options:

If you are connecting using the Database Connection page, append ;create=true to the path you specified.
If you are using the New Database Connection wizard, select the Create the database if required check box.

Class location

%DBHOME%\db2j.jar

where %DBHOME% is the full directory path where the database manager is installed.

Note:

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."

Cloudscape database connections

Related tasks