Installation Guide

Chapter 5 Configuring Cloudscape Databases

This chapter describes how to configure your Informix Cloudscape database for use as a SilverMaster or application database within the SilverStream Application Server environment. It includes these sections:

For the latest information on supported database versions, see the SilverStream Application Server Release Notes. In Windows, you can access the Release Notes from the SilverStream program group or from SilverStream online help.

Setting up SilverMaster databases

To use a Cloudscape database as the SilverMaster database:

Install the Cloudscape software.
Create a Cloudscape SilverMaster database.

The sections that follow explain these steps.

Step 1: Install the Cloudscape software

The SilverStream installation program installs the Informix Cloudscape software by default.The installation program copies three JAR files into the SilverStream lib\Cloudscape subdirectory. The JAR files are:

JAR name

Description

cloudscape.jar

Provides the Cloudscape JDBC driver

RmiJdbc.jar

Provides the Cloudscape RmiJdbc driver

tools.jar

Provides the Cloudscape tools

JAR name	Description
cloudscape.jar	Provides the Cloudscape JDBC driver
RmiJdbc.jar	Provides the Cloudscape RmiJdbc driver
tools.jar	Provides the Cloudscape tools

You can also download the Informix Cloudscape software from the Cloudscape Web site. The URL is www.cloudscape.com.

You must be able to connect to the destination Cloudscape database from the workstation that hosts the SilverStream server.

Step 2: Create a Cloudscape SilverMaster database

You can create a SilverMaster database using:

The SilverStream installation program
Cloudscape tools

The SilverStream installation program During the SilverStream installation process, you can specify that the install create a Cloudscape database for your SilverMaster. You should specify the username APP and the password password when prompted.

Cloudscape tools You can use Cloudscape's tools to create the SilverMaster database. If the Cloudscape database that you use already contains users (not the APP user), then the database must also contain a schema of the same name.

For more information, see Cloudscape users, schema, and SilverStream.

Setting up application databases

To set up a Cloudscape database as an application database, perform these tasks:

Create the Cloudscape database.
Add the Cloudscape database to the SilverStream Server.

The sections that follow explain these steps.

Step 1: Create a Cloudscape application database

You can create the Cloudscape database:

Using the Cloudscape tools

For more information, see the Cloudscape documentation at www.cloudscape.com.
When you add the database to the SilverStream server

When you add a database to the SilverStream server, you must specify the JDBC URL for the database. You can create the database at the same time that you add it by appending the string ;create=true to the URL.

You can add a Cloudscape database using:
- The Add Database dialog (from the Main Designer)
- The AddDatabase command of the SilverCmd command-line tool
For more information on Cloudscape JDBC URLs see, Locating Cloudscape databases.

Using the Add Database dialog Provide these values:

Database Name
User name: APP
Password: password

By default, Cloudscape databases are created with no security. Use the APP/password combination whenever connecting to an unsecured database.
Database platform: Informix Cloudscape
JDBC URL: jdbc:cloudscape:databasepath/databasename;create=true

For example,
```
  jdbc:cloudscape:c:/mydb/Testdb;create=true
```

Using SilverCmd AddDatabase You can invoke SilverCmd AddDatabase like this:

  SilverCmd AddDatabase server[:port] -f file [options]

The following XML shows the contents of a file that you might specify using the -f parameter. This example creates and adds a database named EstoreDB and connects as the user APP.

  <?xml version="1.0" encoding="UTF-8" ?> 
  <?AgMetaXML 1.0?> 
  <obj_DatabaseOptions> 
     <obj_MainDatabase> 
      <obj_ConnectionOptions> 
       <DatabaseName>EStoreDB</DatabaseName> 
       <Username>APP</Username> 
       <Password>password</Password> 
        <LDSKey>CloudscapeEmbeddedDriver</LDSKey> 
        <obj_OtherDriver> 
         <JDBC_URL>jdbc:cloudscape:c:/mydb/Testdb;create=true</JDBC_URL> 
        </obj_OtherDriver> 
      </obj_ConnectionOptions> 
     </obj_MainDatabase> 
  </obj_DatabaseOptions>

Step 2: Add the Cloudscape database to the SilverStream server

To add a Cloudscape database, follow the steps described in Step 1: Create a Cloudscape application database. You do not need the string ;create=true when you are adding an existing database. If the database already exists, the string is ignored.

Locating Cloudscape databases

Cloudscape JDBC URLs take this form:

  jdbc:cloudscape:dbname

The dbname parameter can be a fully qualified pathname, a relative pathname, or a database name. SilverStream uses the cloudscape.system.home system property to locate databases (unless they are fully qualified). By default, SilverStream sets the system property cloudscape.system.home to the following directory:

  SilverStreamInstallDir\db

If the SilverStream is unable to locate the database using the system property, then SilverStream tries the current directory.

Cloudscape users, schema, and SilverStream

If the SilverStream server connects to the Cloudscape database as a specific user (not APP), then SilverStream requires that the database contain a schema of the same name. For example, if you want to connect to a database as the user DBADMIN, then the database must contain a schema also called DBADMIN.

For more information on creating users and schemas, see the Cloudscape documentation at the Cloudscape Web site www.cloudscape.com.

Accessing open Cloudscape databases

When the SilverStream server has a database open, you must use a different JDBC driver and URL to connect to that database from a different source like a JDBC program or a Cloudscape tool. For example, you might want to run a JDBC program against that database.

For example, to use Cloudscape's ij, you would normally do the following:

  java COM.cloudscape.tools.ij 
  ij> connect 'jdbc:cloudscape:d:/MyDbs/MyDatabase';

But to connect while the SilverStream server is running, you would have to run it like this:

  java -Dij.driver=COM.cloudscape.core.RmiJdbcDriver COM.cloudscape.tools.ij 
  ij> connect 'jdbc:cloudscape:rmi:d:/MyDbs/MyDatabase';

In CloudView, before connecting to the database click on the Connection tab, and change the prefix field to jdbc:cloudscape:rmi://localhost:1099/. This automatically changes the driver to COM.cloudscape.core.RmiJdbcDriver.

Installation Guide