public interface Property
This class exists for two reasons
This class should not be shipped with the product.
This class has no methods, all it contains are String's which by are public, static and final since they are declared in an interface.
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ALPHA_BETA_ALLOW_UPGRADE
Allow database upgrade during alpha/beta time.
|
static java.lang.String |
AUTHENTICATION_BUILTIN_ALGORITHM
Property that specifies the name of the hash algorithm to use with
the configurable hash authentication scheme.
|
static java.lang.String |
AUTHENTICATION_BUILTIN_ALGORITHM_DEFAULT
Default value for derby.authentication.builtin.algorithm when creating
a new database.
|
static java.lang.String |
AUTHENTICATION_BUILTIN_ALGORITHM_FALLBACK
Alternative default value for derby.authentication.builtin.algorithm if
AUTHENTICATION_BUILTIN_ALGORITHM_DEFAULT is not available at
database creation time. |
static java.lang.String |
AUTHENTICATION_BUILTIN_ITERATIONS
Property that specifies the number of times to apply the hash
function in the configurable hash authentication scheme.
|
static int |
AUTHENTICATION_BUILTIN_ITERATIONS_DEFAULT
Default value for derby.authentication.builtin.iterations.
|
static java.lang.String |
AUTHENTICATION_BUILTIN_SALT_LENGTH
Property that specifies the number of bytes with random salt to use
when hashing credentials using the configurable hash authentication
scheme.
|
static int |
AUTHENTICATION_BUILTIN_SALT_LENGTH_DEFAULT
The default value for derby.authentication.builtin.saltLength.
|
static java.lang.String |
AUTHENTICATION_NATIVE_PASSWORD_LIFETIME |
static long |
AUTHENTICATION_NATIVE_PASSWORD_LIFETIME_DEFAULT |
static java.lang.String |
AUTHENTICATION_PASSWORD_EXPIRATION_THRESHOLD |
static double |
AUTHENTICATION_PASSWORD_EXPIRATION_THRESHOLD_DEFAULT |
static java.lang.String |
AUTHENTICATION_PROVIDER_BUILTIN |
static java.lang.String |
AUTHENTICATION_PROVIDER_LDAP |
static java.lang.String |
AUTHENTICATION_PROVIDER_LOCAL_SUFFIX |
static java.lang.String |
AUTHENTICATION_PROVIDER_NATIVE |
static java.lang.String |
AUTHENTICATION_PROVIDER_NATIVE_LOCAL |
static java.lang.String |
AUTHENTICATION_PROVIDER_PARAMETER |
static java.lang.String |
AUTHENTICATION_SERVER_PARAMETER |
static java.lang.String |
BOOT_ALL
derby.system.bootAll
Automatically boot any services at start up time. |
static java.lang.String |
BOOT_DB_CLASSPATH
internal use only, passes the database classpathinto the class manager
Undocumented.
|
static java.lang.String |
CHECKPOINT_INTERVAL
Property name for specifying checkpoint interval
Undocumented.
|
static java.lang.String |
COLLATION |
static java.lang.String |
COLLATION_NONE |
static java.lang.String |
CREATE_WITH_NO_LOG
Creation of an access factory should be done with no logging.
|
static java.lang.String |
DATABASE_CLASSPATH
derby.database.classpath
Consists of a series of two part jar names. |
static java.lang.String |
DATABASE_MODULE |
static java.lang.String |
DATABASE_PROPERTIES_ONLY
derby.database.propertiesOnly
|
static java.lang.String |
DEADLOCK_MONITOR
Turn on lock monitor to help debug deadlocks.
|
static java.lang.String |
DEADLOCK_TIMEOUT
Configuration parameter for deadlock timeouts, set in seconds.
|
static int |
DEADLOCK_TIMEOUT_DEFAULT
Default value for deadlock timesouts (20 seconds)
|
static java.lang.String |
DEADLOCK_TRACE
Turn on deadlock trace to help debug deadlocks.
|
static java.lang.String |
DEFAULT_CONNECTION_MODE_PROPERTY
Default connection level authorization, set to
one of NO_ACCESS, READ_ONLY_ACCESS or FULL_ACCESS.
|
static int |
DEFAULT_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
Default value for above
|
static int |
DEFAULT_LOCKS_ESCALATION_THRESHOLD
The default value for LOCKS_ESCALATION_THRESHOLD
|
static java.lang.String |
DEFAULT_USER_NAME |
static int |
DEFAULT_XA_TRANSACTION_TIMEOUT
The default value for XA transaction timeout if the corresponding
property is not found in system properties.
|
static java.lang.String |
DELETE_ON_CREATE
derby.
|
static java.lang.String |
DELETE_ROOT_ON_ERROR
db2j.deleteRootOnError
If we a new root is created while doing restore from backup, it should be deleted if a error occur before we could complete restore successfully. |
static java.lang.String |
DERBY_INSTALL_URL
This property is private to Derby.
|
static java.lang.String |
DERBY_SECURITY_HOST
This property is private to Derby.
|
static java.lang.String |
DERBY_SECURITY_PORT
This property is private to Derby.
|
static java.lang.String |
DRDA_PROP_HOSTNAME |
static java.lang.String |
DRDA_PROP_KEEPALIVE
derby.drda.keepAlive
client socket setKeepAlive value |
static java.lang.String |
DRDA_PROP_LOGCONNECTIONS
derby.drda.logConnections
Indicates whether to log connections and disconnections.
|
static java.lang.String |
DRDA_PROP_MAXTHREADS |
static java.lang.String |
DRDA_PROP_MINTHREADS |
static java.lang.String |
DRDA_PROP_PORTNUMBER
derby.drda.portNumber
The port number used by the network server. |
static java.lang.String |
DRDA_PROP_SECURITYMECHANISM
derby.drda.securityMechanism
This property can be set to one of the following values USER_ONLY_SECURITY CLEAR_TEXT_PASSWORD_SECURITY ENCRYPTED_USER_AND_PASSWORD_SECURITY STRONG_PASSWORD_SUBSTITUTE_SECURITY if derby.drda.securityMechanism is set to a valid mechanism, then the Network Server accepts only connections which use that security mechanism. |
static java.lang.String |
DRDA_PROP_SSL_MODE
derby.drda.sslMode
This property may be set to one of the following three values off: No Wire encryption basic: Encryption, but no SSL client authentication peerAuthentication: Encryption and with SSL client authentication |
static java.lang.String |
DRDA_PROP_STREAMOUTBUFFERSIZE
derby.drda.streamOutBufferSize
size of buffer used when stream out for client.
|
static java.lang.String |
DRDA_PROP_TIMESLICE |
static java.lang.String |
DRDA_PROP_TRACE
derby.drda.trace
|
static java.lang.String |
DRDA_PROP_TRACEALL
derby.drda.traceAll
Turns tracing on for all sessions.
|
static java.lang.String |
DRDA_PROP_TRACEDIRECTORY
derby.drda.traceDirectory
The directory used for network server tracing files. |
static java.lang.String |
DURABILITY_PROPERTY
derby.system.durability
Currently the only valid supported case insensitive value is 'test'
Note, if this property is set to any other value other than 'test', this
property setting is ignored
In the future, this property can be used to set different modes - for
example a form of relaxed durability where database can recover to a
consistent state, or to enable some kind of in-memory mode.
|
static java.lang.String |
DURABILITY_TESTMODE_NO_SYNC
This is a value supported for derby.system.durability
When derby.system.durability=test, the storage system does not
force syncs and the system may not recover.
|
static java.lang.String |
ERRORLOG_FIELD_PROPERTY
derby.stream.error.field=
className.fieldName returning an OutputStream or Writer object
|
static java.lang.String |
ERRORLOG_FILE_PROPERTY
derby.stream.error.file=absolute or relative error log filename
Takes precendence over derby.stream.error.method.
|
static java.lang.String |
ERRORLOG_METHOD_PROPERTY
derby.stream.error.method=
|
static java.lang.String |
ERRORLOG_ROLLINGFILE_COUNT_PROPERTY
derby.stream.error.rollingfile.count=the rolling file count
The default count is 10
|
static java.lang.String |
ERRORLOG_ROLLINGFILE_LIMIT_PROPERTY
derby.stream.error.rollingfile.limit=the rolling file size limit
The default limit is 1024000
|
static java.lang.String |
ERRORLOG_ROLLINGFILE_PATTERN_PROPERTY
derby.stream.error.rollingfile.pattern=the pattern
A pattern consists of a string that includes the following special
components that will be replaced at runtime:
"/" the local pathname separator
"%t" the system temporary directory
"%h" the value of the "user.home" system property
"%d" the value of the "derby.system.home" system property
"%g" the generation number to distinguish rotated logs
"%u" a unique number to resolve conflicts
"%%" translates to a single percent sign "%"
If no "%g" field has been specified and the file count is greater
than one, then the generation number will be added to the end of
the generated filename, after a dot.
|
static java.lang.String |
ERRORLOG_STYLE_PROPERTY
derby.stream.error.style=The error stream error style.
|
static java.lang.String |
EXT_DIAG_SEVERITY_LEVEL
derby.stream.error.ExtendedDiagSeverityLevel=integerValue
Indicates the minimum level of severity for errors that are reported thread dump information and diagnosis information depends on jvm vender. |
static java.lang.String |
FILESYNC_TRANSACTION_LOG
derby.storage.fileSyncTransactionLog
When set, the store system will use sync() call on the log at
commit instead of doing a write sync on all writes to the log;
even if the write sync mode (rws) is supported in the JVM.
|
static java.lang.String |
FORCE_DATABASE_LOCK
derby.database.forceDatabaseLock
Derby attempts to prevent two instances of Derby from booting the same database with the use of a file called db.lck inside the database directory. |
static java.lang.String |
FULL_ACCESS |
static java.lang.String |
FULL_ACCESS_USERS_PROPERTY
List of users with full access connection level authorization.
|
static java.lang.String |
HTTP_DB_FILE_LENGTH |
static java.lang.String |
HTTP_DB_FILE_NAME |
static java.lang.String |
HTTP_DB_FILE_OFFSET |
static int |
IDX_PAGE_SIZE_BUMP_THRESHOLD
The bump threshold for pages size for index.
|
static java.lang.String |
IN_RESTORE_FROM_BACKUP
db2j.inRestore
This Property is used to indicate that we are in restore mode if if the system is doing a restore from backup. |
static java.lang.String |
LANG_PERMISSIONS_CACHE_SIZE
The size of the permissions cache used by the data dictionary.
|
static int |
LANG_PERMISSIONS_CACHE_SIZE_DEFAULT |
static java.lang.String |
LANG_SEQGEN_CACHE_SIZE
The size of the sequence generator cache
used by the data dictionary.
|
static int |
LANG_SEQGEN_CACHE_SIZE_DEFAULT |
static java.lang.String |
LANG_SEQUENCE_PREALLOCATOR
Name of the implementation of SequencePreallocator which is used
to tune how many values Derby pre-allocates for identity columns
and sequences.
|
static java.lang.String |
LANG_SPS_CACHE_SIZE
The size of the stored prepared statment descriptor cache
used by the data dictionary.
|
static int |
LANG_SPS_CACHE_SIZE_DEFAULT |
static java.lang.String |
LANG_TD_CACHE_SIZE
The size of the table descriptor cache used by the
data dictionary.
|
static int |
LANG_TD_CACHE_SIZE_DEFAULT |
static java.lang.String |
LANGUAGE_STALE_PLAN_CHECK_INTERVAL
derby.language.stalePlanCheckInterval
This property tells the number of times a prepared statement should
be executed before checking whether its plan is stale.
|
static java.lang.String |
LOCKS_ESCALATION_THRESHOLD
derby.locks.escalationThreshold
The number of row locks on a table after which we escalate to table locking. |
static java.lang.String |
LOCKS_INTRO |
static java.lang.String |
LOCKWAIT_TIMEOUT
Configuration parameter for lock wait timeouts, set in seconds.
|
static java.lang.String |
LOG_ARCHIVE_MODE
derby.storage.logArchiveMode
used to identify whether the log is being archived for the database or not. |
static java.lang.String |
LOG_BOOT_TRACE
derby.stream.error.logBootTrace
defaults to false. |
static java.lang.String |
LOG_BUFFER_SIZE
Property name for specifying log Buffer Size
Undocumented.
|
static java.lang.String |
LOG_DEVICE_AT_BACKUP
derby.storage.logDeviceWhenBackedUp
This property indicates the logDevice location(path) when the backup was taken, used to restore the log to the same location while restoring from backup. |
static java.lang.String |
LOG_FILE_APPEND
derby.infolog.append={true,false}
If the info stream goes to a file and the file already exist, it can either delete the existing file or append to it. |
static java.lang.String |
LOG_SEVERITY_LEVEL
derby.stream.error.logSeverityLevel=integerValue
Indicates the minimum level of severity for errors that are reported to the error stream. |
static java.lang.String |
LOG_SWITCH_INTERVAL
Property name for specifying log switch interval
Undocumented.
|
static long |
MILLISECONDS_IN_DAY |
static int |
MIN_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
Minimum value for above
|
static int |
MIN_LOCKS_ESCALATION_THRESHOLD
The minimum value for LOCKS_ESCALATION_THRESHOLD
|
static java.lang.String |
MODULE_ENV_CLASSES_PREFIX
Declare a set of classes that the class for a module or sub sub protocol requires.
|
static java.lang.String |
MODULE_ENV_JDK_PREFIX
Declare a minimum JDK level the class for a module or sub sub protocol supports.
|
static java.lang.String |
MODULE_PREFIX
derby.module.modulename
Defines a new module.
|
static java.lang.String |
NO_ACCESS |
static java.lang.String |
NO_AUTO_BOOT
derby.database.noAutoBoot
Don't automatically boot this service at start up time. |
static java.lang.String |
PAGE_SIZE_DEFAULT_LONG
The default page size to use for tables that contain a long column.
|
static java.lang.String |
PAGE_SIZE_PARAMETER
The page size to create a table or index with.
|
static java.lang.String |
PROP_XA_TRANSACTION_TIMEOUT
The property name used to get the default value for XA transaction
timeout in seconds.
|
static java.lang.String |
PROPERTIES_CONGLOM_ID
derby.storage.propertiesId
Stores the id of the conglomerate that holds the per-database properties. |
static java.lang.String |
PROPERTIES_FILE
Name of the file that contains system wide properties.
|
static java.lang.String |
PROPERTY_RUNTIME_PREFIX
By convention properties that must not be stored any persistent form of
service properties start with this prefix.
|
static java.lang.String |
READ_ONLY_ACCESS |
static java.lang.String |
READ_ONLY_ACCESS_USERS_PROPERTY
List of users with read-only connection level authorization.
|
static java.lang.String |
REPLICATION_LOG_BUFFER_SIZE
Property name for specifying the size of the replication log buffers
|
static java.lang.String |
REPLICATION_MAX_SHIPPING_INTERVAL
Property name for specifying the maximum log shipping interval
|
static java.lang.String |
REPLICATION_MIN_SHIPPING_INTERVAL
Property name for specifying the minimum log shipping interval
|
static java.lang.String |
REPLICATION_VERBOSE
Property name for specifying whether or not replication messages are
written to the log
|
static java.lang.String |
REQUIRE_AUTHENTICATION_PARAMETER |
static java.lang.String |
ROW_LOCKING
Derby supports Row Level Locking (rll), but you can use this
property to disable rll.
|
static java.lang.String |
SERVER_STARTED_FROM_CMD_LINE
Internal.
|
static java.lang.String |
SERVICE_LOCALE |
static java.lang.String |
SERVICE_PROTOCOL |
static java.lang.String |
SQL_AUTHORIZATION_PROPERTY |
static java.lang.String |
START_DRDA
derby.drda.startNetworkServer
If true then we will attempt to start a DRDA network server when Derby
boots, turning the current JVM into a server.
|
static java.lang.String |
STATEMENT_CACHE_SIZE |
static int |
STATEMENT_CACHE_SIZE_DEFAULT |
static java.lang.String |
STORAGE_AUTO_INDEX_STATS
Tells if automatic index statistics update is enabled (default is true).
|
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_DEBUG_ABSDIFF_THRESHOLD
Specifies the lower threshold for the absolute difference between the
row estimate for the table and the row estimate for the index before
creating statistics for the associated indexes.
|
static int |
STORAGE_AUTO_INDEX_STATS_DEBUG_ABSDIFF_THRESHOLD_DEFAULT |
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_DEBUG_CREATE_THRESHOLD
Specifies the lower threshold for the number of rows in a table before
creating statistics for the associated indexes.
|
static int |
STORAGE_AUTO_INDEX_STATS_DEBUG_CREATE_THRESHOLD_DEFAULT |
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_DEBUG_KEEP_DISPOSABLE_STATS
Specifies whether to revert to 10.8 behavior and keep disposable stats.
|
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_DEBUG_LNDIFF_THRESHOLD
Specifies the lower threshold for the logarithmical (natural logarithm e)
difference between the row estimate for the table and the row estimate
for the index before creating statistics for the associated indexes.
|
static double |
STORAGE_AUTO_INDEX_STATS_DEBUG_LNDIFF_THRESHOLD_DEFAULT |
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_DEBUG_QUEUE_SIZE
Specifies the size of the work unit queue in the index statistics update
daemon.
|
static int |
STORAGE_AUTO_INDEX_STATS_DEBUG_QUEUE_SIZE_DEFAULT |
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_LOGGING
Tells if activities related to automatic index statistics update should
be written to the Derby system log file (derby.log).
|
static java.lang.String |
STORAGE_AUTO_INDEX_STATS_TRACING
Tells if more detailed activities related to automatic index statistics
update should be traced.
|
static java.lang.String |
STORAGE_DATA_NOT_SYNCED_AT_ALLOCATION
db2j.storage.dataNotSyncedAtAllocation
When set, the store system will not force a sync() call on the
containers when pages are allocated.
|
static java.lang.String |
STORAGE_DATA_NOT_SYNCED_AT_CHECKPOINT
db2j.storage.dataNotSyncedAtCheckPoint
When set, the store system will not force a sync() call on the
containers during a checkpoint.
|
static java.lang.String |
STORAGE_LOG_NOT_SYNCED
db2j.storage.logNotSynced
When set, the store system will not force a sync() call on the log at
commit.
|
static java.lang.String |
STORAGE_TEMP_DIRECTORY
derby.storage.tempDirectory
Sets the temp directory for a database. |
static java.lang.String |
STORAGE_USE_DEFAULT_FILE_PERMISSIONS
derby.storage.useDefaultFilePermissions = {false,true}
When set to true, the store system will not limit file permissions of
files created by Derby to owner, but rely on the current OS default.
|
static java.lang.String |
SUB_SUB_PROTOCOL_PREFIX
derby.subSubProtocol.xxx
A new subsubprotocol can be defined by specifying the class that handles storage for the
subsubprotocol by implementing the
StorageFactory or
WritableStorageFactory interface. |
static java.lang.String |
SYSTEM_HOME_PROPERTY
derby.system.home
Property name for the home directory. |
static int |
TBL_PAGE_SIZE_BUMP_THRESHOLD
The bump threshold for pages sizes for create tables
If the approximate column sizes of a table is greater than this
threshold, the page size for the tbl is bumped to PAGE_SIZE_DEFAULT_LONG
provided the page size is not already specified as a property
|
static java.lang.String |
TERRITORY_BASED_COLLATION |
static java.lang.String |
TERRITORY_BASED_IDENTICAL_COLLATION |
static java.lang.String |
TERRITORY_BASED_PRIMARY_COLLATION |
static java.lang.String |
TERRITORY_BASED_SECONDARY_COLLATION |
static java.lang.String |
TERRITORY_BASED_TERTIARY_COLLATION |
static java.lang.String |
UCS_BASIC_COLLATION |
static java.lang.String |
USER_PROPERTY_PREFIX |
static int |
WAIT_TIMEOUT_DEFAULT
Default value for wait timeouts (60 seconds)
|
static final java.lang.String PROPERTIES_FILE
static final java.lang.String PROPERTY_RUNTIME_PREFIX
static final java.lang.String LOG_SEVERITY_LEVEL
static final java.lang.String EXT_DIAG_SEVERITY_LEVEL
static final java.lang.String LOG_BOOT_TRACE
static final java.lang.String ERRORLOG_STYLE_PROPERTY
static final java.lang.String ERRORLOG_FILE_PROPERTY
static final java.lang.String ERRORLOG_METHOD_PROPERTY
static final java.lang.String ERRORLOG_FIELD_PROPERTY
static final java.lang.String ERRORLOG_ROLLINGFILE_PATTERN_PROPERTY
Thus for example a pattern of "%t/java%g.log" with a count of 2 would typically cause files to be written on Solaris to /var/tmp/java0.log and /var/tmp/java1.log whereas on Windows 95 they would be typically written to C:\TEMP\java0.log and C:\TEMP\java1.log
Generation numbers follow the sequence 0, 1, 2, etc.
Normally the "%u" unique field is set to 0. However, if the FileHandler tries to open the filename and finds the file is currently in use by another process it will increment the unique number field and try again. This will be repeated until FileHandler finds a file name that is not currently in use. If there is a conflict and no "%u" field has been specified, it will be added at the end of the filename after a dot. (This will be after any automatically added generation number.)
Thus if three processes were all trying to output to fred%u.%g.txt then they might end up using fred0.0.txt, fred1.0.txt, fred2.0.txt as the first file in their rotating sequences.
Note that the use of unique ids to avoid conflicts is only guaranteed to work reliably when using a local disk file system.
The default pattern is "%d/derby-%g.log"
static final java.lang.String ERRORLOG_ROLLINGFILE_LIMIT_PROPERTY
The default limit is 1024000
static final java.lang.String ERRORLOG_ROLLINGFILE_COUNT_PROPERTY
The default count is 10
static final java.lang.String LOG_FILE_APPEND
static final java.lang.String SYSTEM_HOME_PROPERTY
static final java.lang.String BOOT_ALL
static final java.lang.String NO_AUTO_BOOT
static final java.lang.String DELETE_ON_CREATE
INTERNAL USE ONLY
static final java.lang.String FORCE_DATABASE_LOCK
static final java.lang.String LOCKS_INTRO
static final java.lang.String LOCKS_ESCALATION_THRESHOLD
static final int DEFAULT_LOCKS_ESCALATION_THRESHOLD
static final int MIN_LOCKS_ESCALATION_THRESHOLD
static final java.lang.String DEADLOCK_TIMEOUT
static final int DEADLOCK_TIMEOUT_DEFAULT
static final int WAIT_TIMEOUT_DEFAULT
static final java.lang.String DEADLOCK_MONITOR
static final java.lang.String DEADLOCK_TRACE
static final java.lang.String LOCKWAIT_TIMEOUT
static final java.lang.String DATABASE_CLASSPATH
static final java.lang.String BOOT_DB_CLASSPATH
static final java.lang.String DATABASE_PROPERTIES_ONLY
static final java.lang.String DERBY_INSTALL_URL
static final java.lang.String DERBY_SECURITY_HOST
static final java.lang.String DERBY_SECURITY_PORT
static final java.lang.String CREATE_WITH_NO_LOG
Creation of an access factory should be done with no logging. This is a run-time property that should not make it to disk in the service.properties file.
Undocumented.
static final java.lang.String PAGE_SIZE_PARAMETER
static final java.lang.String PAGE_SIZE_DEFAULT_LONG
static final int TBL_PAGE_SIZE_BUMP_THRESHOLD
static final int IDX_PAGE_SIZE_BUMP_THRESHOLD
static final java.lang.String ROW_LOCKING
static final java.lang.String PROPERTIES_CONGLOM_ID
INTERNAL USE ONLY
static final java.lang.String STORAGE_TEMP_DIRECTORY
static final java.lang.String DURABILITY_PROPERTY
Currently the only valid supported case insensitive value is 'test'
Note, if this property is set to any other value other than 'test', this
property setting is ignored
In the future, this property can be used to set different modes - for
example a form of relaxed durability where database can recover to a
consistent state, or to enable some kind of in-memory mode.
When set to 'test', the store system will not force sync calls in the
following cases
- for the log file at each commit
- for the log file before data page is forced to disk
- for page allocation when file is grown
- for data writes during checkpoint
That means
- a commit no longer guarantees that the transaction's modification
will survive a system crash or JVM termination
- the database may not recover successfully upon restart
- a near full disk at runtime may cause unexpected errors
- database can be in an inconsistent state
This setting is provided for performance reasons and should ideally
only be used when the system can withstand the above consequences.
One sample use would be to use this mode (derby.system.durability=test)
when using Derby as a test database, where high performance is required
and the data is not very important
Valid supported values are test
Example
derby.system.durability=test
One can set this as a command line option to the JVM when starting the
application or in the derby.properties file. It is a system level
property.
This property is static; if you change it while Derby is running,
the change does not take effect until you reboot.
static final java.lang.String DURABILITY_TESTMODE_NO_SYNC
DURABILITY_PROPERTY
,
Constant Field Valuesstatic final java.lang.String FILESYNC_TRANSACTION_LOG
When set, the store system will use sync() call on the log at commit instead of doing a write sync on all writes to the log; even if the write sync mode (rws) is supported in the JVM.
Undocumented.
static final java.lang.String LOG_ARCHIVE_MODE
INTERNAL USE ONLY
static final java.lang.String LOG_DEVICE_AT_BACKUP
INTERNAL USE ONLY
static final java.lang.String MODULE_PREFIX
Defines a new module. Modulename is a name used when loading the definition of a module, it provides the linkage to other properties used to define the module, derby.env.jdk.modulename and derby.env.classes.modulename. The value is a Java class name that implements functionality required by the other parts of a Derby system or database. The class can optionally implement these classes to control its use and startup.
static final java.lang.String SUB_SUB_PROTOCOL_PREFIX
A new subsubprotocol can be defined by specifying the class that handles storage for the
subsubprotocol by implementing the
StorageFactory
or
WritableStorageFactory
interface. This
is done using a property named db2j.subsubprotocol.xxx where xxx is the subsubprotocol name.
Subsubprotocol names are case sensitive and must be at least 3 characters in length.
For instance:
derby.subSubProtocol.mem=com.mycompany.MemStore
defines the "mem" subsubprotocol with class com.mycompany.MemStore as its StorageFactory implementation.
A database implemented using this subsubprotocol can be opened with the URL "jdbc:derby:mem:myDatabase".
Subsubprotocols "directory", "classpath", "jar", "http", and "https" are built in and may not be overridden.
static final java.lang.String MODULE_ENV_JDK_PREFIX
static final java.lang.String MODULE_ENV_CLASSES_PREFIX
static final java.lang.String LANG_TD_CACHE_SIZE
Undocumented.
static final int LANG_TD_CACHE_SIZE_DEFAULT
static final java.lang.String LANG_PERMISSIONS_CACHE_SIZE
Undocumented.
static final int LANG_PERMISSIONS_CACHE_SIZE_DEFAULT
static final java.lang.String LANG_SPS_CACHE_SIZE
The size of the stored prepared statment descriptor cache used by the data dictionary. Database. Static.
Externally visible but undocumented.
static final int LANG_SPS_CACHE_SIZE_DEFAULT
static final java.lang.String LANG_SEQGEN_CACHE_SIZE
Externally visible and documented.
static final int LANG_SEQGEN_CACHE_SIZE_DEFAULT
static final java.lang.String LANG_SEQUENCE_PREALLOCATOR
Externally visible.
static final java.lang.String LANGUAGE_STALE_PLAN_CHECK_INTERVAL
This property tells the number of times a prepared statement should be executed before checking whether its plan is stale. Database. Dynamic.
Externally visible but undocumented.
static final int DEFAULT_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
static final int MIN_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
static final java.lang.String STATEMENT_CACHE_SIZE
static final int STATEMENT_CACHE_SIZE_DEFAULT
static final java.lang.String STORAGE_AUTO_INDEX_STATS
static final java.lang.String STORAGE_AUTO_INDEX_STATS_LOGGING
static final java.lang.String STORAGE_AUTO_INDEX_STATS_TRACING
static final java.lang.String STORAGE_AUTO_INDEX_STATS_DEBUG_CREATE_THRESHOLD
Specifies the lower threshold for the number of rows in a table before creating statistics for the associated indexes.
NOTE: This is a debug property which will be removed or renamed.
Undocumented.
static final int STORAGE_AUTO_INDEX_STATS_DEBUG_CREATE_THRESHOLD_DEFAULT
static final java.lang.String STORAGE_AUTO_INDEX_STATS_DEBUG_ABSDIFF_THRESHOLD
Specifies the lower threshold for the absolute difference between the row estimate for the table and the row estimate for the index before creating statistics for the associated indexes.
NOTE: This is a debug property which will be removed or renamed.
Undocumented.
static final int STORAGE_AUTO_INDEX_STATS_DEBUG_ABSDIFF_THRESHOLD_DEFAULT
static final java.lang.String STORAGE_AUTO_INDEX_STATS_DEBUG_LNDIFF_THRESHOLD
Specifies the lower threshold for the logarithmical (natural logarithm e) difference between the row estimate for the table and the row estimate for the index before creating statistics for the associated indexes.
NOTE: This is a debug property which will be removed or renamed.
Undocumented.
static final double STORAGE_AUTO_INDEX_STATS_DEBUG_LNDIFF_THRESHOLD_DEFAULT
static final java.lang.String STORAGE_AUTO_INDEX_STATS_DEBUG_QUEUE_SIZE
Specifies the size of the work unit queue in the index statistics update daemon.
NOTE: This is a debug property which will be removed or renamed.
Undocumented.
static final int STORAGE_AUTO_INDEX_STATS_DEBUG_QUEUE_SIZE_DEFAULT
static final java.lang.String STORAGE_AUTO_INDEX_STATS_DEBUG_KEEP_DISPOSABLE_STATS
Specifies whether to revert to 10.8 behavior and keep disposable stats.
NOTE: This is a debug property which will be removed or renamed.
Undocumented.
static final java.lang.String PROP_XA_TRANSACTION_TIMEOUT
static final int DEFAULT_XA_TRANSACTION_TIMEOUT
static final java.lang.String DEFAULT_USER_NAME
static final java.lang.String DATABASE_MODULE
static final java.lang.String SQL_AUTHORIZATION_PROPERTY
static final java.lang.String DEFAULT_CONNECTION_MODE_PROPERTY
static final java.lang.String NO_ACCESS
static final java.lang.String READ_ONLY_ACCESS
static final java.lang.String FULL_ACCESS
static final java.lang.String READ_ONLY_ACCESS_USERS_PROPERTY
static final java.lang.String FULL_ACCESS_USERS_PROPERTY
static final java.lang.String REQUIRE_AUTHENTICATION_PARAMETER
static final java.lang.String AUTHENTICATION_PROVIDER_PARAMETER
static final java.lang.String USER_PROPERTY_PREFIX
static final java.lang.String AUTHENTICATION_PROVIDER_NATIVE
static final java.lang.String AUTHENTICATION_PROVIDER_BUILTIN
static final java.lang.String AUTHENTICATION_PROVIDER_LDAP
static final java.lang.String AUTHENTICATION_SERVER_PARAMETER
static final java.lang.String AUTHENTICATION_PROVIDER_LOCAL_SUFFIX
static final java.lang.String AUTHENTICATION_PROVIDER_NATIVE_LOCAL
static final java.lang.String AUTHENTICATION_NATIVE_PASSWORD_LIFETIME
static final long MILLISECONDS_IN_DAY
static final long AUTHENTICATION_NATIVE_PASSWORD_LIFETIME_DEFAULT
static final java.lang.String AUTHENTICATION_PASSWORD_EXPIRATION_THRESHOLD
static final double AUTHENTICATION_PASSWORD_EXPIRATION_THRESHOLD_DEFAULT
static final java.lang.String AUTHENTICATION_BUILTIN_ALGORITHM
Property that specifies the name of the hash algorithm to use with the configurable hash authentication scheme.
static final java.lang.String AUTHENTICATION_BUILTIN_ALGORITHM_DEFAULT
static final java.lang.String AUTHENTICATION_BUILTIN_ALGORITHM_FALLBACK
AUTHENTICATION_BUILTIN_ALGORITHM_DEFAULT
is not available at
database creation time.static final java.lang.String AUTHENTICATION_BUILTIN_SALT_LENGTH
Property that specifies the number of bytes with random salt to use when hashing credentials using the configurable hash authentication scheme.
static final int AUTHENTICATION_BUILTIN_SALT_LENGTH_DEFAULT
static final java.lang.String AUTHENTICATION_BUILTIN_ITERATIONS
Property that specifies the number of times to apply the hash function in the configurable hash authentication scheme.
static final int AUTHENTICATION_BUILTIN_ITERATIONS_DEFAULT
static final java.lang.String LOG_SWITCH_INTERVAL
static final java.lang.String CHECKPOINT_INTERVAL
static final java.lang.String LOG_BUFFER_SIZE
static final java.lang.String REPLICATION_LOG_BUFFER_SIZE
static final java.lang.String REPLICATION_MIN_SHIPPING_INTERVAL
static final java.lang.String REPLICATION_MAX_SHIPPING_INTERVAL
static final java.lang.String REPLICATION_VERBOSE
static final java.lang.String ALPHA_BETA_ALLOW_UPGRADE
Allow database upgrade during alpha/beta time. Only intended to be used to allow Derby developers to test their upgrade code. Only supported as a system/application (derby.properties) property.
Undocumented.
static final java.lang.String IN_RESTORE_FROM_BACKUP
INTERNAL USE ONLY
static final java.lang.String DELETE_ROOT_ON_ERROR
INTERNAL USE ONLY
static final java.lang.String HTTP_DB_FILE_OFFSET
static final java.lang.String HTTP_DB_FILE_LENGTH
static final java.lang.String HTTP_DB_FILE_NAME
static final java.lang.String START_DRDA
derby.drda.startNetworkServer
If true then we will attempt to start a DRDA network server when Derby boots, turning the current JVM into a server.
Default: false
static final java.lang.String DRDA_PROP_LOGCONNECTIONS
derby.drda.logConnections
Indicates whether to log connections and disconnections.
Default: false
static final java.lang.String DRDA_PROP_TRACEALL
derby.drda.traceAll
Turns tracing on for all sessions.
Default: falseDefault: false
static final java.lang.String DRDA_PROP_TRACE
derby.drda.trace
static final java.lang.String DRDA_PROP_TRACEDIRECTORY
static final java.lang.String DRDA_PROP_MINTHREADS
static final java.lang.String DRDA_PROP_MAXTHREADS
static final java.lang.String DRDA_PROP_TIMESLICE
static final java.lang.String DRDA_PROP_SSL_MODE
static final java.lang.String DRDA_PROP_SECURITYMECHANISM
static final java.lang.String DRDA_PROP_PORTNUMBER
static final java.lang.String DRDA_PROP_HOSTNAME
static final java.lang.String DRDA_PROP_KEEPALIVE
static final java.lang.String DRDA_PROP_STREAMOUTBUFFERSIZE
static final java.lang.String SERVICE_PROTOCOL
static final java.lang.String SERVICE_LOCALE
static final java.lang.String COLLATION
static final java.lang.String UCS_BASIC_COLLATION
static final java.lang.String TERRITORY_BASED_COLLATION
static final java.lang.String TERRITORY_BASED_PRIMARY_COLLATION
static final java.lang.String TERRITORY_BASED_SECONDARY_COLLATION
static final java.lang.String TERRITORY_BASED_TERTIARY_COLLATION
static final java.lang.String TERRITORY_BASED_IDENTICAL_COLLATION
static final java.lang.String COLLATION_NONE
static final java.lang.String STORAGE_DATA_NOT_SYNCED_AT_CHECKPOINT
When set, the store system will not force a sync() call on the containers during a checkpoint.
An internal debug system only flag. The recovery system will not work properly if this flag is enabled, it is provided to do performance debugging to see whether the system is I/O bound based on checkpoint synchronous I/O.
static final java.lang.String STORAGE_DATA_NOT_SYNCED_AT_ALLOCATION
When set, the store system will not force a sync() call on the containers when pages are allocated.
An internal debug system only flag. The recovery system will not work properly if this flag is enabled, it is provided to do performance debugging to see whether the system is I/O bound based on page allocation synchronous I/O.
static final java.lang.String STORAGE_LOG_NOT_SYNCED
When set, the store system will not force a sync() call on the log at commit.
An internal debug system only flag. The recovery system will not work properly if this flag is enabled, it is provided to do performance debugging to see whether the system is I/O bound based on log file synchronous I/O.
static final java.lang.String STORAGE_USE_DEFAULT_FILE_PERMISSIONS
derby.storage.useDefaultFilePermissions = {false,true}
When set to true, the store system will not limit file permissions of
files created by Derby to owner, but rely on the current OS default. On
Unix, this is determined by umask(1)
. Only relevant for JVM >=
6.
The default value is true
on embedded, but false
on the
Network server if started from command line, otherwise it is true for
the server, too (i.e. started via API).
static final java.lang.String SERVER_STARTED_FROM_CMD_LINE
derby.storage.useDefaultFilePermissions
isn't specified.
INTERNAL USE ONLYApache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.