apache > db
Apache DB Project
 
Font size:      

Index

Index

Special characters
  • ? (731)
  • + -, *, /, unary + and - expressions (1025)
  • ? (dynamic parameter)
    • in prepared statements (1053)
    • used in conditional expression (1054)
  • % as wildcard in SQL (727)
  • * as wildcard in SQL SELECT (726), (884)
  • _ as wildcard within SQL (728)
  • {call (JDBC escape syntax) (1156)
  • {d (JDBC escape syntax) (1158)
  • {oj (JDBC escape syntax) (1170)
  • {t (JDBC escape syntax) (1173)
  • {ts (JDBC escape syntax) (1176)
A
  • abs (JDBC scalar function) (1165)
  • ABS or ABSVAL (function) (900)
  • Adding Columns (764)
  • Adding Constraints (765)
  • Aggregates (897)
  • ALTER TABLE statement (753)
  • AND boolean operator (1038)
  • ASC
    • implied in ORDER BY clause (874)
  • Attributes to database connection URL (1178), (1205)
  • AuthorizationIdentifierName identifier (750)
  • autogenerated keys (1152)
  • AVG aggregate function (901)
B
  • Backing indexes
    • created automatically to enforce primary key, unique, and foreign key constraints (780), (843)
    • specifying storage properties for (846)
  • Batch processing (JDBC) (1140), (1141), (1142)
  • BETWEEN boolean operator (1046)
  • BIGINT data type (994)
  • BIGINT function (903)
  • BLOB data type (995), (1135)
  • Boolean expression (1036)
  • Boolean operators
  • bootPassword=key (database connection URL attribute) (1179)
  • Byte strings
C
  • call (JDBC escape keyword) (1155)
  • CALL (PROCEDURE) (822)
  • CASE expression (911)
  • Case sensitivity of keywords and identifiers (723)
  • CAST expression (1020)
  • CAST function (904)
  • CHAR data type (996)
  • CHAR FOR BIT DATA type (997)
  • CHAR function (907)
  • Character expressions (1027)
  • Check constraints (849)
  • Class path
    • accessing read-only databases from (1087)
  • CLOB data type (998), (1136)
  • Column defaults (788)
  • Column-level constraints (826)
    • used in CREATE TABLE statement (830)
  • column-Name identifier (744)
  • Column reference expression (1016)
  • Column widths
  • Columns
  • org.apache.derby.authentication.UserAuthenticator (1237)
  • org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource (1235)
  • org.apache.derby.jdbc.EmbeddedDataSource (1234)
  • org.apache.derby.jdbc.EmbeddedDriver (1233)
  • org.apache.derby.jdbc.EmbeddedXADataSource (1236)
  • org.apache.derby.tools.sysinfo (1232)
  • Comment delimiters within SQL (730)
  • Comparison boolean operators (1041)
  • Compressing tables (754)
  • Compressing Tables (957)
  • concat (JDBC scalar function) (1163)
  • Concatenation function (909)
  • Conditional expression (1023)
  • Connecting to a database (using databaseName attribute) (1184)
  • Connection pooling (1210), (1227)
  • Connections
    • garbage collection of (1092)
    • session-severity exceptions closing (1093)
    • system-severity exceptions closing (1094)
  • Constant expression (1017)
  • Constraint clause
    • referential actions in (851)
  • CONSTRAINT clause (824)
  • constraint-Name identifier (747)
  • Constraints (825)
  • Conversions
    • of SQL-92 data types using CAST (905)
    • using CAST function (explicit) (906)
  • correlation-Name identifier (743)
  • COUNT(*) aggregate function (914)
  • COUNT aggregate function (912)
  • CREATE FUNCTION statement (774)
  • CREATE INDEX statement (776)
  • CREATE PROCEDURE statement (782)
  • CREATE SCHEMA statement (784)
  • CREATE TABLE statement (786)
  • CREATE TRIGGER statement (791)
  • create=true (database connection URL attribute) (1182)
  • CREATE VIEW statement (801)
  • createFrom=Path (database connection URL attribute) (1201)
  • CURRENT DATE function (915)
  • CURRENT_DATE function (916)
  • CURRENT ISOLATION function (917)
  • CURRENT TIME function (920)
  • CURRENT_TIME function (921)
  • CURRENT TIMESTAMP function (922)
  • CURRENT_TIMESTAMP function (923)
  • CURRENT_USER function (924)
  • cursor-Name identifier (748)
  • Cursors (857), (858)
    • pre-fetching affecting (1116)
    • scrolling insensitive (1139)
D
  • d (JDBC escape keyword) (1157)
  • Data encryption
  • Data sources (1224)
    • creating a database for (1230)
    • shutting down a database for (1231)
  • Data types
  • Database connection URL (1084)
    • attributes (1088)
    • settable through Properties in connection call (1089)
    • syntax in embedded mode (1085)
  • Database Manager limitations (1251)
  • DatabaseMetaData.getProcedureColumns (1100)
  • databaseName=nameOfDatabase (database connection URL attribute) (1183)
  • Databases
  • dataEncryption=true (database connection URL attribute) (1185)
  • DATE data type (999)
  • Date formats
    • JDBC escape syntax for (1159)
  • DATE function (925)
  • DATE limitations (1247)
  • Date/time expressions (1030)
  • DAY function (926)
  • DECIMAL data type (1000)
  • DECLARE GLOBAL TEMPORARY TABLE statement (852)
  • Defaults (787)
  • DELETE statement (854)
  • delimited identifiers
  • Dependencies
    • internal tracking of (751)
  • DESC
    • optional element of ORDER BY clause (875)
  • Descending indexes (777)
  • Dictionary objects
  • DISTINCT
    • qualifier in AVG function (902)
    • qualifier in COUNT aggregate function (913)
  • DISTINCT clause
    • part of SelectExpression (883)
  • Distributed transaction management (1214)
  • DOUBLE data type (1001)
  • DOUBLE function (927)
  • DOUBLE PRECISION data type (1002)
  • DROP FUNCTION statement (803)
  • DROP INDEX statement (805)
  • DROP PROCEDURE statement (806)
  • DROP SCHEMA statement (808)
  • DROP TABLE statement (810)
  • DROP TRIGGER statement (812)
  • DROP VIEW statement (814)
  • Dropping Constraints (766)
  • Dynamic parameter expression (1019)
  • Dynamic parameters (1050)
E
  • Encrypting databases (1180), (1186)
  • Encryption
  • encryptionAlgorithm=algorithm (database connection URL attribute) (1191)
  • encryptionProvider=providerName (database connection URL attribute) (1188)
  • escape (JDBC escape keyword) (1160)
  • Escape character
    • for single-quotation mark (722)
  • Escape character for LIKE clauses (1161)
  • Escape syntax (JDBC) (1154)
  • EXISTS boolean operator (1048)
  • Export
    • SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure (978)
    • SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure (975)
  • Expression subquery (881)
  • Expressions
F
  • FLOAT data type
    • as alias for REAL or DOUBLE PRECISION (1003)
    • java.sql type converted to DOUBLE PRECISION when retrieved (1129)
  • fn (JDBC escape keyword) (1162)
  • FOR UPDATE clause (856)
  • Foreign keys (841)
  • FROM clause (860)
  • FUNCTION
  • Functions, built-in (894)
G H I
  • Identifier length limitations (1241)
  • Identifiers
  • Identity Column Attributes (789)
  • Identity columns
  • Import
    • SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure (984)
    • SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure (981)
  • IN (? or dynamic) parameters (1051)
  • IN boolean operator (1047)
  • In-place updates (859)
  • index-Name identifier (746)
  • Indexes
    • automatic creation of for primary key, unique, and foreign key constraints (781), (844)
    • created in descending order (778)
    • specifying page size for (779)
  • INNER JOIN expression (863)
  • INSERT statement (865)
  • INTEGER data type (1004)
  • INTEGER function (929)
  • Internationalization features
  • IS NOT NULL boolean operator (1043)
  • IS NULL boolean operator (1042)
  • ISOLATION (821)
  • Isolation levels
J
  • J2EE (1206)
  • Java identifiers
    • case sensitivity of within SQL (725)
  • java.sql.Blob (1133)
  • java.sql.CallableStatement (1112)
  • java.sql.Clob (1134)
  • java.sql.Connection (1091)
  • java.sql.Connection.isReadOnly (1098)
  • java.sql.Connection.setReadOnly (1097)
  • java.sql.Connection.setTransactionIsolation (1095)
  • java.sql.DatabaseMetaData (1099)
  • java.sql.Driver (1078)
  • java.sql.Driver.getPropertyInfo (1090)
  • java.sql.DriverManager.getConnection (1082)
  • java.sql.ParameterMetaData (1145)
  • java.sql.PreparedStatement (1103)
  • java.sql.ResultSet (1115)
  • java.sql.ResultSetMetaData (1122)
  • java.sql.Savepoint (1146)
  • java.sql.SQLException (1123)
  • java.sql.SQLWarning (1125)
  • java.sql.Statement (1101)
  • java.sql.Types
  • java.transaction.xa package (1216)
  • JavaIdentifiers
  • javax.sql.ConnectionPoolDataSource (1211), (1225)
  • javax.sql.DataSource (1209), (1223)
  • javax.sql package (1221)
  • javax.sql.PooledConnection (1212), (1226)
  • javax.sql.XAConnection (1228)
  • javax.sql.XADataSource (1229)
  • javax.sql.XAxxx interfaces (1215)
  • javax.transaction.xa.XAException (1220)
  • javax.transaction.xa.XAResource (1218)
  • javax.transaction.xa.Xid (1219)
  • JDBC 2.0
  • JDBC 3.0
  • JDBC API
    • Derby implementation of (1076)
  • JDBC driver
  • jdbc.drivers system property
  • JDBC escape syntax (1153)
  • JDBC types
  • JNDI (1208)
  • JOIN operation (867)
  • JTA API (1217)
K L M
  • Mapping
    • of SQL types to java.sql.Types (1132)
  • MAX aggregate function (933)
  • MIN aggregate function (934)
  • MINUTE function (935)
  • mod (JDBC scalar function) (1168)
  • MOD function (936)
  • MONTH function (937)
N O
  • oj (JDBC escape keyword) (1169)
  • ON clause
    • part of INNER JOIN expression (864)
  • OR boolean operator (1039)
  • ORDER BY clause (873)
    • affecting cursors (876)
    • needed to guarantee order of results (886)
  • Outer joins (868)
    • JDBC escape syntax for (1171)
PP
  • password=userPassword (database connection URL attribute) (1199)
  • Precision
    • of decimal arithmetic expressions (992)
  • Prepared statements
    • tracking of dependencies (752)
    • use of dynamic parameters in (1052)
  • Primary key constraints (839)
  • Primary keys
  • Procedure
Q
  • Quantified comparison boolean operator (1049)
R
  • Read-write VTIs
  • REAL data type (1008)
  • Referential actions (850)
  • Referential integrity
  • RENAME INDEX statement (816)
  • RENAME TABLE statement (817)
  • Reserved words (1055)
  • Resource manager
    • Derby as in J2EE system (1207)
  • restoreFrom=Path (database connection URL attribute) (1202)
  • ResultSets
    • errors in statement affecting creation of (1102)
  • RIGHT OUTER JOIN expression (879)
  • rollforwardRecovery=Path (database connection URL attribute) (1200)
  • RTRIM (function) (938)
S
  • Savepoints
  • Savepoints (JDBC) (1144), (1147)
  • Scalar subquery expression (1021)
  • ScalarSubquery (880)
  • Scale
    • for decimal arithmetic (991)
    • of decimal arithmetic expressions (993)
  • schema-Name identifier (739)
  • Schemas
  • Scroll insensitive cursors (JDBC) (1137)
  • Scrolling insensitive cursors (1138)
  • SECOND function (939)
  • Select expression (882)
  • SELECT statement (885)
  • SESSION_USER (function) (940)
  • Set functions (895)
  • SET ISOLATION statement (820)
  • SET SCHEMA statement (818), (918)
  • setAsciiStream (1108)
  • setBinaryStream (1106), (1107)
  • setUnicodeStream (1109)
  • setXXXStream requests (1104)
  • shutdown=true (database connection URL attribute) (1203)
  • Simple-column-Name identifier (745)
  • SMALL INTEGER data type (1009)
  • SMALLINT function (941)
  • Special characters
    • escaping in SQL statements (721)
  • SQL-92
    • features not supported by Derby (1058)
    • features supported by Derby (1057)
  • SQL-92 data types
    • supported by Derby (987)
  • SQL identifiers
  • SQL92Identifiers
  • SQLExceptions
  • SQLState values (1074)
  • SQLState XJZZZ
  • SQRT (function) (942)
  • sqrt (JDBC scalar function) (1164)
  • Statements
  • Storage properties
    • for indexes backing constraints (845)
  • Stream (1111)
  • Streaming columns
    • as IN parameters to prepared statement (1105)
    • retrieving from ResultSets using getXXXStream methods (1118)
  • String expressions
  • String limitations (1245)
  • Strings
    • delimited by single quotation marks within SQL statements (720)
  • SUBSTR (function) (943)
  • substring (JDBC scalar function) (1167)
  • Subsubprotocol
    • part of database connection URL syntax (1086)
  • SUM aggregate function (944)
  • SYSALIASES system table (1059)
  • SYSCHECKS system table (1060)
  • SYSCOLUMNS system table (1061)
  • SYSCONGLOMERATES system table (1062)
  • SYSCONSTRAINTS system table (1063)
  • SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure (973)
  • SYSCS_UTIL.SYSCS_CHECK_TABLE function (951)
  • SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure (971)
  • SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure (959)
  • SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure (979)
  • SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure (976)
  • SYSCS_UTIL.SYSCS_FREEZE_DATABASE system procedure (967)
  • SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function (955)
  • SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS function (953)
  • SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure (985)
  • SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure (982)
  • SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure (965)
  • SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure (961)
  • SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure (963)
  • SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure (969)
  • SYSDEPENDS system table (1064)
  • SYSFILES system table (1065)
  • SYSFOREIGNKEYS system table (1066)
  • SYSKEYS system table (1067)
  • SYSSCHEMAS system table (1068)
  • SYSSTATEMENTS system table (1070)
  • SYSSTATISTICS system table (1069)
  • SYSTABLES system table (1071)
  • system functions
    • SYSCS_UTIL.SYSCS_CHECK_TABLE (952)
    • SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY (956)
    • SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS (954)
  • System procedures
    • SYSCS_UTIL.SYSCS_BACKUP_DATABASE (972)
    • SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE (970)
    • SYSCS_UTIL.SYSCS_COMPRESS_TABLE (958)
    • SYSCS_UTIL.SYSCS_EXPORT_QUERY (977)
    • SYSCS_UTIL.SYSCS_EXPORT_TABLE (974)
    • SYSCS_UTIL.SYSCS_FREEZE_DATABASE (966)
    • SYSCS_UTIL.SYSCS_IMPORT_DATA (983)
    • SYSCS_UTIL.SYSCS_IMPORT_TABLE (980)
    • SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY (964)
    • SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS (960)
    • SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING (962)
    • SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE (968)
  • SYSTRIGGERS system table (1072)
  • SYSVIEWS system table (1073)
T
  • t (JDBC escape keyword) (1172)
  • Table constraints
    • used in CREATE TABLE statement (834)
  • Table-level constraints (828)
  • table-Name identifier (740)
  • Table subquery expression (1022)
  • TableExpression (887)
  • Tables
  • TableSubquery (888)
  • Territories
  • territory
  • territory=ll_CC (database connection URL attribute) (1194)
  • TIME data type (1010)
  • Time formats
    • JDBC escape syntax for (1174)
  • TIME function (945)
  • TIME limitations (1248)
  • TIMESTAMP data type (1011)
  • Timestamp formats
    • JDBC escape syntax for (1177)
  • TIMESTAMP function (946)
  • TIMESTAMP limitations (1249)
  • TriggerName identifier (749)
  • Triggers
    • and database events (794)
    • and recursion (800)
    • and the referencing clause (795)
    • creating (792)
    • defining when they fire (793)
    • dropping (813)
    • order of execution (799)
    • referencing old and new values (796)
    • statement versus row triggers (797)
    • the triggered-SQL-statement (798)
  • ts (JDBC escape keyword) (1175)
  • Type correspondence
    • for JDBC and SQL types (1128)
U
  • Unicode
  • Unicode escapes
    • support for in SQL statements (719)
  • UNION (877)
  • UNION ALL (878)
  • Unique constraints (840)
  • UPDATE statement (889)
  • UPPER function (947)
  • USER function (948)
  • user=userName (database connection URL attribute) (1204)
V W X Y
Previous Page
Table of Contents
Index