[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
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
- 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
- Backing up databases
- Batch files
- Bits
- manipulating
- 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
- 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
- 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
- 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
- getPropertyInfo
- using
- Getting a nested connection
- using database connection URL attribute
- using getCurrentConnection() built-in method
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Querying the system tables
- 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
- 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
- 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
- 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
- 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
- Working with Arrays
- Zip files
- databases in
- 100% Pure Java certification
|