The Derby properties
are used for configuring the system and database, as well as for diagnostics
such as logging statements, and monitoring and tracing locks.
This section includes all of the core
Derby properties.
Note: When
setting properties that have boolean values, be sure to trim extra spaces
around the word true. Extra spaces around the word true cause
the property to be set to false.
Derby properties summarizes
the general
Derby properties.
In this table, S stands for system-wide, D stands for database-wide, and C
indicates the value persists with newly created conglomerates. X means yes.
Table 1. Derby properties
| Property |
Scope |
Dynamic |
| derby.authentication.ldap.searchAuthDN |
S, D |
|
| derby.authentication.ldap.searchAuthPW |
S, D |
|
| derby.authentication.ldap.searchBase |
S, D |
|
| derby.authentication.ldap.searchFilter |
S, D |
|
| derby.authentication.provider |
S, D |
|
| derby.authentication.server |
S, D |
|
| derby.connection.requireAuthentication |
S, D |
|
| derby.database.defaultConnectionMode |
S, D |
X* |
| derby.database.forceDatabaseLock |
S |
|
| derby.database.fullAccessUsers |
S, D |
X* |
| derby.database.propertiesOnly |
D |
X |
| derby.database.readOnlyAccessUsers |
S, D |
X* |
| derby.infolog.append |
S |
|
| derby.jdbc.xaTransactionTimeout |
S, D |
X |
| derby.language.logQueryPlan |
S |
|
| derby.language.logStatementText |
S, D |
|
| derby.locks.deadlockTimeout |
S, D |
X |
| derby.locks.deadlockTrace |
S, D |
X |
| derby.locks.escalationThreshold |
S, D |
X |
| derby.locks.monitor |
S, D |
X |
| derby.locks.waitTimeout |
S, D |
X |
| derby.storage.initialPages |
C |
|
| derby.storage.minimumRecordSize |
S, D, C |
X |
| derby.storage.pageCacheSize |
S |
|
| derby.storage.pageReservedSpace |
S, D, C |
X |
| derby.storage.pageSize |
S, D, C |
X |
| derby.storage.tempDirectory |
S, D |
X |
| derby.stream.error.field |
S |
|
| derby.stream.error.file |
S |
|
| derby.stream.error.method |
S |
|
| derby.stream.error.logSeverityLevel |
S |
|
| derby.system.durability |
S |
|
| derby.system.home |
S |
|
| derby.user.UserName |
S, D |
X |
* See the main page for this property for information
about when changes to the property are dynamic.
There are additional properties associated with the Derby tools.
For more information about tool-specific properties, see the Java DB Tools and Utilities Guide Guide.