background image

<< Contents - Data types | Contents - JDBC 4.0 and 4.1 features >>

Contents - Derby system tables

<< Contents - Data types | Contents - JDBC 4.0 and 4.1 features >>

Version 10.8 Derby Reference Manual

v

TIMESTAMP data type......................................................................................202
User-defined types............................................................................................ 203
VARCHAR data type......................................................................................... 203
VARCHAR FOR BIT DATA data type...............................................................204
XML data type................................................................................................... 204

Argument matching.......................................................................................................... 206

SQL reserved words......................................................................................................... 208

Derby support for SQL-92 features ............................................................................... 212

Derby system tables......................................................................................................... 220

SYSALIASES system table................................................................................... 220
SYSCHECKS system table....................................................................................221
SYSCOLPERMS system table...............................................................................221
SYSCOLUMNS system table.................................................................................222
SYSCONGLOMERATES system table..................................................................223
SYSCONSTRAINTS system table......................................................................... 224
SYSDEPENDS system table..................................................................................225
SYSFILES system table.........................................................................................226
SYSFOREIGNKEYS system table.........................................................................226
SYSKEYS system table......................................................................................... 227
SYSPERMS system table...................................................................................... 227
SYSROLES system table...................................................................................... 229
SYSROUTINEPERMS system table...................................................................... 230
SYSSCHEMAS system table................................................................................. 231
SYSSEQUENCES system table............................................................................ 232
SYSSTATEMENTS system table...........................................................................233
SYSSTATISTICS system table.............................................................................. 234
SYSTABLEPERMS system table.......................................................................... 234
SYSTABLES system table.................................................................................... 237
SYSTRIGGERS system table................................................................................ 237
SYSVIEWS system table....................................................................................... 238

XPLAIN style tables.......................................................................................................... 240

SYSXPLAIN_STATEMENTS system table........................................................... 240
SYSXPLAIN_STATEMENT_TIMINGS system table............................................. 242
SYSXPLAIN_RESULTSETS system table............................................................ 244
SYSXPLAIN_RESULTSET_TIMINGS system table..............................................249
SYSXPLAIN_SCAN_PROPS system table........................................................... 251
SYSXPLAIN_SORT_PROPS system table........................................................... 255

Derby exception messages and SQL states.................................................................. 258

SQL error messages and exceptions.................................................................. 258

JDBC reference................................................................................................................. 302

java.sql.Driver interface.........................................................................................302

java.sql.Driver.getPropertyInfo method............................................................. 303

java.sql.DriverManager.getConnection method..................................................303

Derby database connection URL syntax...........................................................304
Syntax of database connection URLs for applications with embedded databases
........................................................................................................................... 304
Additional SQL syntax....................................................................................... 304
Attributes of the Derby database connection URL ...........................................305

java.sql.Connection interface............................................................................... 305

java.sql.Connection.setTransactionIsolation method........................................ 306
java.sql.Connection.setReadOnly method.........................................................306
java.sql.Connection.isReadOnly method...........................................................306