
The Cloudscape System Panel
What Is the Cloudscape System?
The Cloudscape system consists ofan instance of Cloudscape and the environment in which it runs. For Cloudview sessions, the system is determined when Cloudview was started (or, for clients, when the connection is established). There can be only one system per Cloudview session, but a system does not restrict which databases you can open.
For any particular database, the system context exists only as long as the Cloudview session; system information is not retained with databases opened in Cloudview. However, system settings are preserved for that system, and are automatically written to the SysVisual.properties file in the System Directory. The SysVisual.properties file is read each time Cloudview starts that system (i.e., starts in that directory).
For more information, see the section About the System Directory.
Working in the Cloudscape System
From the System tab, you can configure the Cloudview system, or interact with Cloudscape databases:
System Settings
When the System node is highlighted in the left panel of Cloudview, the right panel displays tabs which you can use to specify system-specific information:

Connection Tab
The Connection tab specifies the default connection for the system. These settings are used by databases opened or created from the Cloudview system. Cloudview reads these connection settings upon each Open or Create operation, so different databases in a single system can have different connection properties.
As with all system settings, connection properties specified here are not stored with the database. Even if, within a single Cloudview session, you establish multiple connections with differing properties, Cloudview only preserves one set of connection properties (those specified here when Cloudview exits).
Depending on how Cloudview was started, the information in the connection tab varies. For more information about this tab, see "Modifying Connection Properties".

Preferences Tab
The Preferences tab contains the following Cloudview preference settings:
- Save edits without prompting: check this box to disable confirmation prompts when modifying objects or data.
- Save DDL as case insensitive: check this box to ignore case for objects created in Cloudview.
- Browser EXE path for Help (Windows only): On Windows systems, you can optionally specify a browser for viewing the online help. If you don't specify a browser here, Cloudview uses the standard Cloudview Help Browser.
To specify a browser, click the ... button and navigate to the browser executable (for example, netscape.exe).

Information Tab
The Information tab displays the results the Cloudscape sysinfo utility. This tab displays, among other things, the class path and the Cloudscape and Java versions running at the time Cloudview was started.
This information is static; it cannot be modified from Cloudview, and it cannot be dynamically refreshed. The display reflects sysinfo output at the time Cloudview was started.

Modifying Connection Properties
The Connection tab is divided into three sections:
About Connection Settings
Cloudview accesses each database through its own connection. Database connection properties can be different for each database open in a system.
Cloudview'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, and Cloudview provides default connection properties.
Situations in which you may need to modify connection properties include those in which the database is located on a different machine or can only be accessed through a particular framework (such as Cloudconnector or RmiJdbc).
NOTE: When you open a second Cloudview window using File->New->Window, a new, additional 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 whose connection properties match the current setting are successfully opened in the new window.
To see or modify connection properties:
- Click the System icon in the left panel.
- Choose the Connection tab in the right panel.
The Connection tab displays three sections:
URL
The URL section of the properties tab defaults to the embedded Cloudscape setting.
- If Cloudscape is running embedded, the URL prefix should be jdbc:cloudscape: (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.
- To access a server from a framework (such as Cloudconnector or rmiJdbc), modify the value in the URL Prefix field:
- If connecting to Cloudconnector, specify the client JDBC driver with the URL prefix jdbc:cloudscape:weblogic:
- If connecting to Cloudconnector using Secure Socket Layer, choose the URL prefix jdbc:cloudscape:weblogic-ssl:
- For any other server framework, enter the appropriate URL prefix. For example, to specify the client JDBC driver using RmiJdbc, you might enter jdbc:rmijdbc://localhost:1099/jdbc:cloudscape:
When you choose a pre-defined URL prefix, the appropriate driver class automatically displays in the Driver area of the Connection panel. If your URL isn't pre-defined, type the driver name by hand.
- In the Host field, optionally specify the host name for a server. If you specify the Cloudconnector driver, the appropriate default is automatically entered.
- In the Port field, optionally specify the port for a server. If you are using the WebLogic driver, the appropriate default appears.
- 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, 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.
NOTE:
The autocommit=false attribute is not supported in Cloudview. Autocommit is always turned on in Cloudview, regardless of this setting.
Log-in
- In the Log-in area, enter a user name and password, if required.
Driver
- Depending on your URL prefix, the Class field in the Driver section might be empty or automatically populated with one of the following values:
- COM.cloudscape.core.JDBCDriver
if Cloudscape is embedded
- COM.cloudscape.core.WebLogicDriver
to specify the client JDBC driver for connecting to Cloudconnector (with or without SSL)
- RmiJdbc.RJDriver
to specify the client driver for the RmiJdbc framework
If you are using a server framework not listed here, type the appropriate value in the Class field.
NOTE: If you connect to a database that requires upgrading to the current version of Cloudscape, a message displays when you attempt the connection.
Note that once you have set connection properties within Cloudview, they are preserved for that system. For more information about system properties, see The Cloudscape System Panel.
About the System Directory
Within Cloudview, the location of the system directory is only meaningful when opening or creating a database, and when modifying System Settings (the SysVisual.properties file).
The system directory provides the default database location during an Open or Create operation. However, you can always use the Directory button (from inside the Create Database or Open Database dialogs) to create or locate databases outside the System Directory.
You can explicitly specify the system directory for a Cloudview session in these ways:
- using the cloudscape.system.home property from the Cloudview command-line
- from inside the optional cloudscape.properties file
- from a customized shortcut
If you do not explicitly specify the location of the system directory, it defaults to one of the following:
- the directory from which Cloudview was started (if invoked programmatically or from a command shell)
- the Cloudscape installation directory (if invoked from the Start menu)
Creating or Opening Databases
This section covers the following topics:
For information about executing SQL-J statements against a database, see the section "Submitting SQL-J Statements".
For information about creating or deleting dictionary objects, see the section "Dictionary Objects"

Creating a Database
From Cloudview you can create a new database.
NOTE: When you create a new database from Cloudview, the database's connection properties are inherited from the Cloudview connection settings. Before creating a new database, you may want to check the connection properties. For information on connection properties, see "Modifying Connection Properties".
To create a new database:
Choose File->New->Database from the menu bar. The New Database dialog appears.

The New Database Dialog
The New Database dialog contains four tabs: Database, Synchronization, Localization, and Encryption. All tabs except Database are optional.
Database Tab
- On the Database tab, enter a name for the database in the Name field. Optionally, specify a full path with the name.
If you want to browse the file system to locate a directory, click the Directory button. Use the file browser to choose the directory that will hold the new database. When finished, click OK. Type the name of the database after the path in the Name field.
NOTE:
To modify which drives are accessible from the Cloudview directory browser, see "Configuring Cloudview".
Synchronization Tab
- Optionally, on the Synchronization tab, specify a synchronization type for the database (source, target, or none). If the Type field is set to none (the default), the database will not be synchronization-enabled. source and target are options only if you have installed Cloudsync.
NOTE:
You can change a non-source database to be a source database after creation from the Cloudview menus. For more information, see Converting to a Source Database.
- Target databases must be created from a copy file. If you chose target in the Type field, select the Load From field, and enter the pathname or URL for the copy file from which the database should be created.
For more information about target databases, see the Synchronization Guide.
Localization Tab
- On the Localization tab, optionally choose a locale for the database. Locales are in the format xx_YY (where xx is the language, and YY is the nationality). The database locale defaults to the locale of your java system. The database locale determines the language of database errors, sort order for international data types, and so on.
For more information on locales, see the Cloudscape Tools and Utilities Guide, or the Internationalization appendix in the Cloudscape Developer's Guide.
Encryption Tab
- On the encryption tab, optionally specify a Data Encryption Algorithm for the database. Choose between No Encryption (the default), Default Encryption (SunJCE), or Custom Encryption (other encryption provider). For the Algorithm, specify a name and the feedback mode.
Optionally specify a value in the Boot Password field. For Custom Encryption, specify the fully-qualified provider name in the Encryption Provider field.
The bottom of the Encryption Tab displays the fully constructed database connection URL based on your choices.
Where is the Database Created?
Unless you explicitly specified a database directory on the database tab, the directory in which the database is created depends on how you started Cloudview, and whether it is connecting to the new database as a client:
- Client
- Regardless of how you start Cloudview, the database is created in the cloudscape.system.home directory specified by the server.
- Standalone
- If you started Cloudview from the command line and specified the cloudscape.system.home property, it is created there.
- If you started Cloudview from the command-line without setting cloudscape.system.home, it is created in the command-line directory.
- If you started Cloudview from the Windows Programs menu shortcut, it is created in the directory in which you installed Cloudscape.

Opening an Existing Database
You can open an existing database in the following ways:
Once you have opened a database, it is displayed in the left panel next to the database icon, and its name is added to the File History list saved with this system.
From the File History List
On the File menu, Cloudview displays a list of databases previously opened in this system. To open a previously-opened database, choose it from the history list on the File menu.
Using the Directory Browser
To open an existing database using the Cloudview directory browser:
- Choose File->Open from the menu bar. The Browse for Folder dialog displays.
By default, the browser opens in the System directory.
- Navigate to the appropriate directory, highlight the database name, and click OK.
- Click OK.
By Name
The Open by Name feature lets you open a database in the system directory without having to use the navigator or specify a pathname or location. To open a database by name:
- Choose File->Open by Name from the menu bar. The "Open by Name" dialog appears.
- In the Name field, type the name of a database in the System Directory. Optionally, you can choose the name using the Directory or List buttons.
Click Directory to choose from the file browser, or List to choose from a list of databases known to the system.
- Click OK.
From the Command Line or Shortcut
To automatically open a database when Cloudview opens, specify the database name on the command line when you launch Cloudview. For example:
java COM.cloudscape.tools.cview MyDBName