Font size:

Index

Index

Index

Access
- full (read-write) versus read-only (756)
Accessing read-only databases from class path (612)
Archiving read-only databases (606), (610)
Attributes (URL), setting as properties (569)
Attributes to database connection URL (556)
- setting (557)
- specifying with Properties object (570)
Authentication (731)
- definition (725)
Authentication provider
- specifying (734)
Authorization (753)
Authorization identifiers (749)
Auto-commit
- and transactions (653)
- turning off (656)
- turning off with JDBC (655)
- using (654)
Autocommit
- holdable cursors and (672)
Automatic booting
- of databases in system (514)
Available databases
- list of provided by databaseName attribute (783)

Backing up databases (537)

Class path
- accessing databases from (554)
Classes
- storing in database (617)
classpath subsubprotocol (585)
derby.log (512)
derby.properties file (509), (520)
Derby system (506)
derby.system.home
- used to define system directory (517)
Columns
- maximum number allowed per table (532)
org.apache.derby.database.UserUtility (758)
org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource (721)
org.apache.derby.jdbc.EmbeddedDataSource (720)
org.apache.derby.jdbc.EmbeddedXADataSource (722)
Concurrency (676)
Connecting to a database (595)
Connecting to databases
- in embedded mode (594)
- when path is ambiguous because of databases in class path (615)
- when path is ambiguous with databases in file system (614)
Connecting to databases not directly in the system directory (555)
Connecting to multiple databases (648)
Connections
- getting (647)
Creating a database
- using database connection URL attribute (564)
Creating empty queries (796)
derby.jar (600)
Cursors
- accessing system-generated names (665)
- all result sets as (650)
- holdable (670)
- naming (663), (664)
- requirements for being updatable (661)
- scrolling insensitive (669)
- updatable (662)
- working with (659)

Data encryption
- configuring (767)
- providers (765)
Database class loading (616)
Database connection URL
- description (504)
- features common to embedded and client/server versions (505)
- retrieving from database (788)
- syntax (581)
- using (587)
Database encryption (762)
Database name attribute
- use of in database connection URL (558)
Database pages
- description (544)
Database-side JDBC procedures (622)
- and SQLExceptions (632)
- definition (624)
- example of connecting to different database (630)
- using nested connections (625)
- using non-nested connections (629)
Database-side procedures
- definition (623)
Databases
- backing up (538)
- configuring (545)
- connecting (549)
- connecting to outside system (551)
- connecting to within system (550)
- controlling access to (755)
- convention for specifying connection path when outside system (552)
- creating (565)
- description of in Derby system (522)
- dropping (535)
- encrypting (763)
- encrypting upon creation (567)
- shutting down individually (563)
Deadlock detection (701)
Deadlocks
- description (700)
- detecting (702)
- programming an application to handle (703)
Deployment modes
- threading/connection modes and (705)
directory subsubprotocol (553), (584)
Dirty reads
- definition (682)
Disk encryption (727)
DriverPropertyInfo Array (784)
Dropping databases (536)

Embedded applications
- deploying (597)
Embedded environments (596), (601)
- Derby as single-user database (598)
- how applications interact with Derby in (599)
- how to deploy Derby (602)
Encrypted databases
- booting (568), (771)
- creating (766)
Encrypting databases (728)
Encryption
- configuring (768)
- providers (764)
Encryption algorithms
- configuring (770)
Encryption providers
- configuring (769)
Error log (511)
- description (519)
Exclusive locks
- definition (696)
Explicit close of JDBC objects (657)
External directory services
- used to provide user authentication (735)

File descriptors
- configuring to run Derby (578)
Full access
- definition (761)

getPropertyInfo
- using (785)
Getting a nested connection
- using database connection URL attribute (589)

Holdable cursors and autocommit (671)

Identity column
- defining (791)
- definition (792)
IDEs
- and need to use server framework (787)
- using Derby with (786)
Indexes
- limitations of (547)
- maximum number allowed per table (531)
- not supported for CLOB, BLOB, and LONG VARCHAR data types (548)
Installation directory
Internationalization (798)
interrupt calls
- caught by Derby (714)
IOExceptions
- indicating need to relax file descriptors limit (579)
Isolation levels (674)
- configuring (689)

jar directory
- function (527)
jar files
- databases in (609)
- installing, removing, and replacing (621)
- loading signed (620), (772)
- storing in database (618)
Jar files
jar subsubprotocol (586)
Java 2 Security Manager (776)
java.sql.Connection.TRANSACTION_READ_COMMITTED (678), (679)
java.sql.Connection.TRANSACTION_READ_UNCOMMITTED (677)
java.sql.Connection.TRANSACTION_SERIALIZABLE (680)
java.sql.Driver.getPropertyInfo (782)
JDBC
- tutorial for (502)
JDBC Connections (644)
- definition (646)
JDBC driver
- description (503)
JDBC driver (embedded) (580)
- starting (592)
JDBC Statement
- definition (649)
JNDI properties for user authorization
- setting (741)
jndid
- required for LDAP user authorization (738)
JVMs (Java Virtual Machines)
- verified for Derby (577)

LDAP directory services
- used to provide user authentication (737)
ldap.jar
- required for LDAP user authorization (739)
Limitations
- in current version (546)
Locales
- definition (799)
Localization (797)
Lock granularity (690)
Locking (675)
- row-level (692)
- table-level (691)
Locks
- exclusive (693)
- scope of (699)
- shared (694)
- update (695)
log directory
- function (523)
Logic
- storing in database (619)

Mapping column values to return values (795)
Multi-threaded applications (706)
Multi-user database access
- programming for (709)
Multiple connections
- from multiple applications connecting to server (708)
- from single application running in embedded mode (707)
- in single application (704)
Multiple JVMs accessing
- prohibition of (513)
Multiple rows VALUES clause (794)
Multiple threads sharing single connection (710)

Nested connections
- definition (651)
- getting (588), (590), (626), (627)
- limitations of (628)
Non-repeatable reads
- definition (683)

Passwords (744)
- no encryption of (748)
- providing (747)
Permissions (759)
- database access (779)
- granting to Derby (777)
- mandatory (778)
- optional (780)
Phantom reads
- definition (684)
Policy files
- and Derby permissions (775)
- examples (781)
Processing SQLExceptions (717)
Properties
- defined for system in derby.properties (510)
providerutil.jar
- required for LDAP user authentication (740)

Read-only access
- definition (760)
Read-only databases
- accessing (559)
- accessing in zip/jar files (611)
- archiving to jar or zip files (607)
- creating (604)
- deploying (605)
- putting in class path (613)
- working with (603)
Recovery (540), (543)
Referential actions
- and triggers (637)
Referential integrity
- via triggers (639)
Resource manager
- Derby as in J2EE system (719)
Restarting Derby within same JVM (515)
ResultSets
- behavior of with auto-commit (666)
- scrolling insensitive (JDBC 2.0) (668)
- working with (660)
Rollback
- implicit versus explicit (658)
Rows
- maximum number allowed per table (533)
- size limitations (534)

Schemas

and users (751)

Scrolling insensitive cursors (667)
Security

configuring (729)

Security features (723)

limitations of (774)

seg0 directory (524)
service.properties file (525)
Shared locks

definition (697)

Shutdown

description (542)

Shutting down a single database (539), (561)
Shutting down Derby

using database connection URL attribute (562)

Signed jar files (773)
single system

prohibition of (513)

Size limitations of Derby objects and databases (528)
SQL99 standards

and Derby (801)

SQLExceptions

chaining of (716)
importance of not catching within database-side procedures (631)
user-defined (38001-38999) (633)
working with (715)

SQLWarnings (718)
Start-up

description (541)

Starting Derby (593)

embedded mode (591)

Statements shared by threads

dangers of (711)

Subprotocol

part of database connection URL syntax (582)

Subsubprotocol

part of database connection URL syntax (560), (583)

System

description (508)

System directory (507)

creating and naming directory for (521)
default (518)
specifying (516)

Tables
- maximum number allowed per database (529)
- size limitations (530)
Threads
- notifying (713)
- sleep and interrupt calls (712)
tmp directory
- function (526)
Transaction anomalies in generic database systems
- description (681)
Transaction isolation levels (673)
TRANSACTION_READ_COMMITTED isolation level (687)
TRANSACTION_READ_UNCOMMITTED isolation level (688)
TRANSACTION_REPEATABLE_READ isolation level (686)
TRANSACTION_SERIALIZABLE isolation level (685)
Transactions (645)
- definition (652)
Triggers
- accessing before and after rows (640)
- and exceptions (642)
- automatic rollback of trigger actions (643)
- example of trigger actions (641)
- limitations of trigger actions (636)
- programming trigger actions (634)
- use of SQL and Java in trigger actions (635)
- use of to perform referential actions (638)

Unicode support (800)
Update locks (698)
User authentication (730)
- definition (724)
- enabling (732)
- programming applications for (745)
- use of external directory service for (736)
User authorization (752)
- definition (726)
- for databases (754)
- providing your own (742)
User names
- providing (746)
Users
- and schemas (750)
- Derby's built-in repository (743)
- defining for a system (733)
- providing a name and password for in connection (566)
UserUtility (757)
Using a supplied parameter multiple times in a query (789)

VALUES clause
- power of (790), (793)

Zip files
- databases in (608)

Previous Page
Table of Contents
Index