Index
Page 1 of 1

A - B - C - D - E - F - G - H - I - J - K - L
M - N - O - P - Q - R - S - T - U - V - W - X
Y - Z - Symbols - Numerics

Index

A

Access
full (read-write) vs. read-only
Accessing classes not stored in database
Accessing databases
Accessing read-only databases from class path
APIs for public classes and interfaces
Approximating CONVERT functions with Java methods
Archiving read-only databases ,
Arrays
using external libraries to support
Attributes to database connection URL
setting
specifying with Properties object
Attributes (URL), setting as properties
Authentication
definition
Authentication provider
specifying
Authorization
Authorization identifiers
Auto-commit
and transactions
turning off ,
turning off using database connection URL attribute
using
Auto-commit, turning off
Auto-commit, turning off with JDBC
Autoincrement defaults
Automatic booting
of databases in system
Available databases
list of provided by databaseName attribute

B

Backing up databases
Batch files
Bits
manipulating

C

Case-insensitive sorts
CAST function
use of
Class aliases
Class path
accessing databases from
Class versioning
Class versioning (keeping classes compatible when modifying)
Class versions, specifying
Classes
storing in database
Classes, modifying
classpath subsubprotocol
client.jar
Client/server environments
deploying client applications
deploying Cloudscape for
description
Cloudscape
multiple client applications accessing
Cloudscape environments
Cloudscape system
cloudscape.jar ,
cloudscape.LOG
cloudscape.properties file ,
cloudscape.system.home
used to define system directory
CLOUDSCAPE_INSTALL environment variable
Columns
maximum number allowed per table
COM.cloudscape.aggregates.AggregateDefinition
COM.cloudscape.aggregates.Aggregator
COM.cloudscape.core.AbstractDataSource
COM.cloudscape.core.BasicDataSource
COM.cloudscape.core.DataSourceFactory
COM.cloudscape.core.LocalConnectionPoolDataSource
COM.cloudscape.core.RemotXaDataSource
COM.cloudscape.core.XaDataSource
COM.cloudscape.database.JBMSException
COM.cloudscape.database.TriggerExecutionContext
use of in trigger actions
COM.cloudscape.database.UserUtility
COM.cloudscape.triggers.TriggerNewTransitionRows
COM.cloudscape.triggers.TriggerOldTransitionRows
COM.cloudscape.types.TypeDescriptor
COM.cloudscape.vti.SpaceTable
COM.cloudscape.vti.UpdatableVTITemplate ,
COM.cloudscape.vti.VTICosting
COM.cloudscape.vti.VTIMetaDataTemplate ,
COM.cloudscape.vti.VTITemplate ,
Concurrency
Conditional expression
Connecting to a database
Connecting to databases
in embedded mode
when path is ambiguous because of databases in class path
when path is ambiguous with databases in file system
Connecting to databases not directly in the system directory
Connecting to multiple databases
Connections
getting
Controlling evaluation order
Creating a database
using database connection URL attribute
Creating a method alias for a static method
Creating a method/method alias to mimic a Sybase-style built-in function (SUBSTRING)
Creating empty queries
Cursors
all result sets as
and Cloudconnector
naming
requirements for being updatable
scrolling insensitive
updatable
working with
Cursors, accessing system-generated names
Cursors, naming

D

Data
importing
Data encryption
configuring
providers
Data sources
Database class loading
Database connection URL
description
features common to embedded and client/server versions
retrieving from database
syntax
using
Database design issues
Database encryption
Database locales
Database name attribute
use of in database connection URL
Database pages
description
DatabaseMetaData precompiled queries
Databases
accessing
backing up
configuring
connecting
connecting to outside system
connecting to within system
controlling access to
convention for specifying connection path when outside system
creating
description of in Cloudscape system
dropping
encrypting
encrypting upon creation
shutting down individually
upgrading ,
Database-side JDBC method connecting to different database
example invocation
Database-side JDBC methods
and SQLExceptions
definition ,
example definition
example invocation
using nested connections
using non-nested connections
Database-side methods
definition ,
Deadlock detection
Deadlocks
description
detecting
programming an application to handle
Defining a sequence-number column
definition
Deployment environments
choosing
Deployment modes
threading/connection modes and
Derived tables
using to avoid redundant method calls
directory subsubprotocol ,
Dirty reads
definition
Disk encryption
DriverPropertyInfo Array
Dropping databases
Dynamic parameters
need to cast data type of as method parameters

E

Embedded applications
deploying
Embedded environments ,
Cloudscape as single-user database
how applications interact with Cloudscape in
how to deploy Cloudscape
multiple connections and threads
Encrypted databases
booting ,
creating
Encrypting databases
Encryption
configuring
providers
Encryption algorithms
configuring
Encryption providers
configuring
EPOC
Cloudscape on
Error log
Error messages
localized
Exclusive locks
definition
Executing static methods
Explicit close of JDBC objects
External data
accessing ,
External directory services
used to provide user authentication
External libraries
integrating
External resources
managing by storing URLs
External virtual tables
requirements for
Externalizable
use of compared to Serializable

F

Fields
accessing
File descriptors
configuring to run Cloudscape
Finding out the canonical path of the system directory
Finding out the system directory
Forcing garbage collection and finalization
Full access
definition
Functions
emulating with java.lang methods
how java.lang classes map to
Functions (SQL-92 style)
emulating

G

getPropertyInfo
using
Getting a nested connection
using database connection URL attribute
using getCurrentConnection() built-in method

I

IDEs
and need to use server framework
using Cloudscape with
Indexes
limitations of
maximum number allowed per table
not supported for long rows
Information log
description
Input/output streams
and serializable objects
Inserting a row of Nulls
Installation directory
layout of
INSTANCEOF
use of
Integrating external libraries
International string data types
Internationalization
interrupt calls
caught by Cloudscape
Invoking java.lang.String methods
Invoking methods
when method does not return a value
Invoking non-static methods on SQL-J expressions
Invoking static methods of java.langMath
IOExceptions
indicating need to relax file descriptors limit
Isolation levels
configuring

J

jar directory
function
Jar files
databases in
loading signed ,
storing in database
jar subsubprotocol
Java
extensions to SQL-J
Java data types
and implementation of equals
deploying classes for
storing
Java objects
defining a column to store
inserting from application
retrieving and updating
storing in tables
Java stored procedures
as database-side methods with classes stored in database
java.sql.Connection.TRANSACTION_READ_COMMITTED
java.sql.Connection.TRANSACTION_REPEATABLE_READ
java.sql.Connection.TRANSACTION_SERIALIZABLE
java.sql.Driver.getPropertyInfo
JDBC
tutorial for
JDBC Connections
definition
JDBC driver
description
JDBC driver (embedded)
starting
JDBC metadata for Java data types
JDBC Statement
definition
JNDI properties for user authorization
setting
jndi.jar
required for LDAP user authorization ,
JVMs (Java Virtual Machines)
verified for Cloudscape

L

LDAP directory services
used to provide user authentication
ldap.jar
required for LDAP user authorization
Limitations
in current version
Literals
using to save keystrokes
Locales
definition
determining
setting
special library requirements
Localization
Lock granularity
Locking
row-level
table-level
Locks
exclusive
scope of
shared
update
log directory
function
Logic
storing in database

M

Managing external resources
Mapping column values to return values
Memory usage
limiting
Method invocation
need to cast data type of dynamic parameters
using to refine search conditions
when class not stored in database
Methods
accessing when column stores superclass or interface
invoking
invoking in search condition
invoking on stored objects
Methods without return values, invoking
Mobile devices
Multiple connections
from multiple applications connecting to server
from single application running in embedded mode
in single application
Multiple JVMs accessing single system
prohibition of
Multiple rows VALUES clause
Multiple threads sharing single connection
Multi-threaded applications
Multi-user database access
programming for

N

Nested connections
definition
getting , , ,
limitations of
Network encryption
NEW keyword
NIS Directory Service Plus
used to provide user authentication
nisplus.jar
required for NIS+ user authorization
Non-nested connections
using
Non-repeatable reads
definition

O

Object storage
Objects
inserting
retrieving
updating (single step)
updating (two steps)
Orderable Java data types
and comparison operators
and implementation of compareTo
programming classes for
requirements

P

Passwords
no encryption of
providing
Permissions
Phantom reads
definition
Pocket PCs
Cloudscape on
Processing SQLExceptions
Properties
defined for system in cloudscape.properties
providerutil.jar
required for LDAP user authentication
provider.jar
required for LDAP user authentication
PSION
Cloudscape on

Q

Querying the system tables

R

Read-only access
definition
Read-only databases
accessing in zip/jar files
archiving to jar or zip files
creating
deploying
putting in class path
upgrading
working with
Read-only databases, accessing
Read-write VTIS
and query execution
Read-write VTIs
and query compilation
examples
Recovery ,
Referential actions
and triggers
Referential integrity
via triggers
Replication systems
what to deploy on server and on remote machines
Resource manager
Cloudscape as in J2EE system
Restarting Cloudscape within same JVM
ResultSets
behavior of with auto-commit
scrolling insensitive (JDBC 2.0)
silently closed with auto-commit
working with
Rollback
implicit vs. explicit
Row count
approximate
Rows
maximum number allowed per table
size limitations

S

Sample applications and databases
description
Schemas
and users
Scrolling insensitive cursors
Security
configuring
Security features
limitations of
seg0 directory
Sequence-number column
Serializable
use of compared to Externalizable
Serialization
description
incompatibility for pre-1.1.6 and post-1.2 databases
requirements for
serialVersionUID
use of
service.properties file
Shared locks
definition
Shell scripts
Shutdown
description
Shutting down a single database ,
Shutting down Cloudscape
using database connection URL attribute
Signed jar files ,
Size limitations of Cloudscape objects and databases
Small devices
Sorts
case-insensitive
SQLExceptions
chaining of
importance of not catching within database-side methods
user-defined (38001-38999)
working with
SQLWarnings
SSL ,
Starting Cloudscape
embedded mode
Starting JBMS
Start-up
description
Statements shared by threads
dangers of
Static fields
not serialized
Static methods
executing
Stored prepared statements
need for recompiling before transferring to read-only media
Stored procedures
replaced by Java methods
using method invocation to emulate
Subprotocol
part of database connection URL syntax ,
Subsubprotocol
part of database connection URL syntax ,
System
description
System directory
creating and naming directory for
default
specifying
System properties
accessing from within SQL-J
System tables
querying

T

Tables
maximum number allowed per database
size limitations
Threads
notifying
sleep and interrupt calls
tmp directory
function
Transaction anomalies in generic database systems
description
Transaction isolation levels
Transactions
definition
TRANSACTION_READ_COMMITTED isolation level
TRANSACTION_REPEATABLE_READ isolation level
TRANSACTION_SERIALIZABLE isolation level
Transient
use of to optimize object storage
Triggers
accessing before and after rows
and exceptions
and separate connections
and user-defined SQLExceptions
automatic rollback of trigger actions
examples of trigger actions
limitations of trigger actions
long-running trigger actions in separate thread
programming trigger actions
transactionally-independent trigger actions
use of SQL and Java in trigger actions
use of to perform referential actions
Type correspondence
between SQL-J and Java types

U

Unicode support
Unique keys
generating
Update locks
Upgrades ,
for synchronization databases
upgrade=true (database connection URL attribute)
Upgrading read-only databases
User authentication ,
enabling
programming applications for
use of external directory service for
User authorization
definition
for databases
providing your own
User names
providing
User-defined aggregates
examples of
programming
Users
and schemas
Cloudscape's built-in repository
defining for a system
providing a name and password for in connection
UserUtility
Using a supplied parameter multiple times in a query
Using the COM.cloudscape.types types to get metadata

V

VALUES clause
power of ,
Versioning of classes
compatible changes for serialization
mini-tutorial
using
Virtual Table Interface (VTI)
example
requirements of ,
VTIs
and costing
and implementation of ResultSet and ResultSetMetaData and
and single compilation requirement
built-in
compile-time ResultSetMetaData
default parameters
determining compile time or run time
estimating cost of
examples ,
parameter rules
programming
read-write
read-write vs. read-only
templates for creating

W

Working with Arrays

Z

Zip files
databases in

Numerics

100% Pure Java certification