Table of Contents
Page 1 of 1

Table of Contents

About This Document

Purpose of This Document

Audience

How This Document Is Organized

PART ONE
Cloudscape Server Guide

1 Using Cloudscape in a Multi-User Environment

Cloudscape in a Server Framework

Connectivity Configurations

Differences Between Embedded and Server Configurations

Embedding Servers

Using a Server Framework with Cloudsync

Multi-User Features Available in All Cloudscape Products

RmiJdbc

Row-Level Locking

Multiple Concurrency Levels

Multi-Connection and Multi-Threading

Administrative Tools

Cloudconnector

Features of Cloudconnector

Development

Integrated Development Environments (IDEs)

Web Development in Java

Workspaces

Integration

Deployment

Transactions

Firewall Support

Data Caching

Shared Database Connections

Server Scalability

Standard Internet Protocols

Management

Graphical Management Console

Integrated Logging

The WebLogic JDBC Services Integration

About this Book and the Cloudconnector Documentation

2 Installing Cloudscape in a Server Framework

Installation Directory

JDK

Libraries

When to Use client.jar

Setting PATH for a Server

Class Path for a Server

Library Path for Cloudconnector on UNIX

3 Starting and Shutting Down the Cloudconnector Server

Overview

Starting Cloudconnector on the Server

Startup Tasks

Step One: Open a Command Window for Starting the Server

Step Two: Include Cloudconnector in the PATH Variable

Step Three: Modify the class path Script (setServerCloudscapeCP)

Step Four: Modify the Startup Script (startCS)

Default File Configuration

Step Five: Optionally Modify weblogic.properties

Setting a Password

Modifying the Port Number

Step Six: Run Both Scripts

Verifying Startup

Shutting Down Cloudconnector

Shutting Down Cloudconnector when User Authentication Is Enabled

Using ;shutdown=true with Concurrent Embedded and Remote Access

The Cloudconnector Scripts

4 Accessing Cloudconnector from a Client

Preparing Clients

JDK Version

Class Path

Cloudconnector WebLogic Version

Using Cloudconnector Clients

Specifying the Client JDBC Driver

Programmatically

From ij or Cloudview

Specifying the Database Connection URL

Example URLs

Setting Session-Level WebLogic Properties on the URL

Turning off Prefetching and Caching

Turning off the Parameter Cache

Using ij and Cloudview with Cloudconnector

5 Working with Java Data Types in a Server

Deploying Java Classes

Using the Cloudscape Types on a Client

Working with Non-Serializable Types

6 User Authentication Using Cloudconnector

Why Use Connection Pools?

Creating a Connection Pool

Setting Up Access Control Lists

Using a Connection from a Connection Pool

Refreshing or Resetting a Connection Pool

7 Configuring a Server Framework for Cloudscape

Setting Cloudscape Properties

System Properties

Conglomerate-Specific and Database-Wide Properties

Other Properties

Setting Cloudconnector Properties

Configuring Multi-Threading

Disabling HTTP Services

Cloudconnector Administration

8 SSL Security in Cloudconnector

Setting Properties to Enable SSL

URLs for SSL

9 Cloudscape Access Using RmiJdbc

How RmiJdbc Works

Configuring Cloudscape for RmiJdbc

Setting Class Path

RmiJdbc JVM Information

Setting Port Numbers

Starting and Stopping the RmiJdbc Server

Starting the Server

Altering the StartCS Script

Shutting Down the Server

Accessing RmiJdbc Server from a Client

Client Class Path

JDBC Driver and Database Connection URL for an RmiJdbc Client

Client JDK

Database Connection URL for RmiJdbc

Using the Cloudscape Tools with RmiJdbc

The RJPing Utility

10 Embedding Servers

Overview

Embedded Server Topology

How to Start an Embedded Server From an Application

RmiJdbc Server Example

Cloudconnector Example

PART TWO
Cloudscape Administration Guide

11 Checking Database Consistency

The checkTable Method

Sample Error Messages

Sample Queries

12 Backing Up and Restoring Databases

Backing Up a Database

Offline Backups

On-line Backups

Using the backup Method

Using Operating System Commands with the freeze and unfreeze Methods

When the Log is in a non-Default Location

Backing Up Encrypted Databases

Backup History

Failure Recovery

Restoring from a Backup

Restoring a Database When the Log Is in a Non-Default Location

When You Backed up with Cloudscape's Built-In Backup Command

When You Backed up with Operating System Commands

13 Logging on a Separate Device

Using the logDevice Property

Example of Creating a Log in a Non-Default Location

Example of Moving a Log Manually

Issues for Logging in a Non-Default Location

14 Getting Locking Information

Displaying Current Locking Information

LockTable

TransactionTable

Example Using the Lock Manager VTIs

Lock Monitoring

15 Identifying and Reclaiming Unused Space

Overview

Identifying Unused Space in a Table or Index

Getting an Estimate of Reclaimable Space

About the Page Usage Information

Reclaiming Unused Space

Index