apache > db
Apache DB Project
 
Font size:      

Index

Index

A
  • 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)
  • Authentication provider
  • Authorization (753)
  • Authorization identifiers (749)
  • Auto-commit
  • Autocommit
    • holdable cursors and (672)
  • Automatic booting
    • of databases in system (514)
  • Available databases
    • list of provided by databaseName attribute (783)
B
  • Backing up databases (537)
C
  • 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
  • Creating a database
    • using database connection URL attribute (564)
  • Creating empty queries (796)
  • derby.jar (600)
  • Cursors
D
  • Data encryption
  • 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
  • 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
  • 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
  • Disk encryption (727)
  • DriverPropertyInfo Array (784)
  • Dropping databases (536)
E
  • Embedded applications
  • Embedded environments (596), (601)
    • Derby as single-user database (598)
    • how applications interact with Derby in (599)
    • how to deploy Derby (602)
  • Encrypted databases
  • Encrypting databases (728)
  • Encryption
  • Encryption algorithms
  • Encryption providers
  • Error log (511)
  • Exclusive locks
  • Explicit close of JDBC objects (657)
  • External directory services
    • used to provide user authentication (735)
F
  • File descriptors
    • configuring to run Derby (578)
  • Full access
G
  • getPropertyInfo
  • Getting a nested connection
    • using database connection URL attribute (589)
H
  • Holdable cursors and autocommit (671)
I
  • Identity column
  • 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
  • IOExceptions
    • indicating need to relax file descriptors limit (579)
  • Isolation levels (674)
J
  • jar directory
  • jar files
  • 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
  • JDBC Connections (644)
  • JDBC driver
  • JDBC driver (embedded) (580)
  • JDBC Statement
  • JNDI properties for user authorization
  • jndid
    • required for LDAP user authorization (738)
  • JVMs (Java Virtual Machines)
    • verified for Derby (577)
L
  • LDAP directory services
    • used to provide user authentication (737)
  • ldap.jar
    • required for LDAP user authorization (739)
  • Limitations
    • in current version (546)
  • Locales
  • Localization (797)
  • Lock granularity (690)
  • Locking (675)
  • Locks
  • log directory
  • Logic
    • storing in database (619)
M
  • Mapping column values to return values (795)
  • Multi-threaded applications (706)
  • Multi-user database access
  • Multiple connections
    • from multiple applications connecting to server (708)
    • from single application running in embedded mode (707)
    • in single application (704)
  • Multiple JVMs accessing
  • Multiple rows VALUES clause (794)
  • Multiple threads sharing single connection (710)
N P
  • Passwords (744)
  • Permissions (759)
  • Phantom reads
  • Policy files
  • Processing SQLExceptions (717)
  • Properties
    • defined for system in derby.properties (510)
  • providerutil.jar
    • required for LDAP user authentication (740)
R
  • Read-only access
  • Read-only databases
  • Recovery (540), (543)
  • Referential actions
  • Referential integrity
  • 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)
S
  • Schemas
  • Scrolling insensitive cursors (667)
  • Security
  • Security features (723)
  • seg0 directory (524)
  • service.properties file (525)
  • Shared locks
  • Shutdown
  • Shutting down a single database (539), (561)
  • Shutting down Derby
  • using database connection URL attribute (562)
  • Signed jar files (773)
  • single system
  • Size limitations of Derby objects and databases (528)
  • SQL99 standards
  • 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
  • Statements shared by threads
  • Subprotocol
  • part of database connection URL syntax (582)
  • Subsubprotocol
  • part of database connection URL syntax (560), (583)
  • System
T
  • Tables
    • maximum number allowed per database (529)
    • size limitations (530)
  • Threads
  • tmp directory
  • Transaction anomalies in generic database systems
  • 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)
  • 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)
U
  • 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)
  • User names
  • 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)
V Z
  • Zip files

Previous Page
Table of Contents
Index