Table of Contents
Purpose of This Document
Audience
How This Document Is Organized
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
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
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
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
Deploying Java Classes
Using the Cloudscape Types on a Client
Working with Non-Serializable Types
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
Setting Cloudscape Properties
System Properties
Conglomerate-Specific and Database-Wide Properties
Other Properties
Setting Cloudconnector Properties
Configuring Multi-Threading
Disabling HTTP Services
Cloudconnector Administration
Setting Properties to Enable SSL
URLs for SSL
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
Overview
Embedded Server Topology
How to Start an Embedded Server From an Application
RmiJdbc Server Example
Cloudconnector Example
The checkTable Method
Sample Error Messages
Sample Queries
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
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
Displaying Current Locking Information
LockTable
TransactionTable
Example Using the Lock Manager VTIs
Lock Monitoring
Overview
Identifying Unused Space in a Table or Index
Getting an Estimate of Reclaimable Space
About the Page Usage Information
Reclaiming Unused Space
|