Modifying Connection Properties

The Connection tab is divided into three sections:

About Connection Settings

Cview accesses each database through its own connection. Database connection properties can be different for each database open in a system.

Cview's connection settings are used whenever a connection is established to a database, such as when it is opened or created. Modifying connection properties is optional; Cview provides default connection properties.

NOTE: When you open a second Cview window using File->New->Window, an additional new connection is established to each currently open database. If the first window contains two or more databases with different connection properties, the File->New command cannot successfully initiate connections to them all, and an error is displayed. Only databases with connection properties that match the current setting are successfully opened in the new window.

To see or modify connection properties:

  1. Click the System icon in the left panel.
  2. Choose the Connection tab in the right panel.

    The Connection tab displays three sections:

URL

The URL section of the Connection tab defaults to the embedded Cloudscape setting.

  1. If Cloudscape is running embedded, the URL prefix should be jdbc:db2j:. This is the default value. If you are accessing the server from a framework, you need to modify this value (see step 2).

    NOTE: Only connect to a database in an embedded environment if you are certain no other application is currently accessing the database; otherwise database corruption may occur. On Windows platforms, Cloudscape prevents you from doing this.

  2. To access a server from a framework, modify the value in the URL Prefix field:
  3. In the Host field, optionally specify the host name for a server.
  4. In the Port field, optionally specify the port for a server.
  5. In the Attributes field, optionally specify one or more attributes to the database connection URL. Prepend the attribute with a semicolon(;). For example, ;create=true or ;logDevice=LogDirPath. If you specify multiple attributes, also separate them with semicolons.

    For detailed information about supported attributes and values, see the section about Database Connection URL Attributes in the Cloudscape Reference Manual.

Log-in

  1. In the Log-in area, enter a user name and password, if required.

Driver

  1. Depending on your URL prefix, the Class field in the Driver section might be empty or automatically populated with the following value:

Note that once you have set connection properties within Cview, they are preserved for that system. For more information about system properties, see The Cloudscape System Panel.