# Support and restrictions for Cloudscape database connections

Use the New Database Connection wizard or pages that are embedded in other wizards to create a JDBC connection to Cloudscape™.

The following JDBC drivers are supported for Cloudscape.

- Cloudscape Embedded JDBC Driver
- DB2® Universal Driver

Cloudscape Embedded JDBC Driver
  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/
DB2 JDBC Drivers

  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.

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

(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.