Java Doc for Property.java in » Database-DBMS » db-derby-10.2 » org » apache » derby » iapi » reference » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation

1.	6.0 JDK Core
2.	6.0 JDK Modules
3.	6.0 JDK Modules com.sun
4.	6.0 JDK Modules com.sun.java
5.	6.0 JDK Modules sun
6.	6.0 JDK Platform
7.	Ajax
8.	Apache Harmony Java SE
9.	Aspect oriented
10.	Authentication Authorization
11.	Blogger System
12.	Build
13.	Byte Code
14.	Cache
15.	Chart
16.	Chat
17.	Code Analyzer
18.	Collaboration
19.	Content Management System
20.	Database Client
21.	Database DBMS
22.	Database JDBC Connection Pool
23.	Database ORM
24.	Development
25.	EJB Server geronimo
26.	EJB Server GlassFish
27.	EJB Server JBoss 4.2.1
28.	EJB Server resin 3.1.5
29.	ERP CRM Financial
30.	ESB
31.	Forum
32.	GIS
33.	Graphic Library
34.	Groupware
35.	HTML Parser
36.	IDE
37.	IDE Eclipse
38.	IDE Netbeans
39.	Installer
40.	Internationalization Localization
41.	Inversion of Control
42.	Issue Tracking
43.	J2EE
44.	JBoss
45.	JMS
46.	JMX
47.	Library
48.	Mail Clients
49.	Net
50.	Parser
51.	PDF
52.	Portal
53.	Profiler
54.	Project Management
55.	Report
56.	RSS RDF
57.	Rule Engine
58.	Science
59.	Scripting
60.	Search Engine
61.	Security
62.	Sevlet Container
63.	Source Control
64.	Swing Library
65.	Template Engine
66.	Test Coverage
67.	Testing
68.	UML
69.	Web Crawler
70.	Web Framework
71.	Web Mail
72.	Web Server
73.	Web Services
74.	Web Services apache cxf 2.0.1
75.	Web Services AXIS2
76.	Wiki Engine
77.	Workflow Engines
78.	XML
79.	XML UI

Java

Java Tutorial

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.iapi.reference

Source Cross Reference

Class Diagram

Java Document (Java Doc)

org.apache.derby.iapi.reference .Property

Property

public interface Property (Code)

List of all properties understood by the system. It also has some other static fields.

This class exists for two reasons

To act as the internal documentation for the properties.
To remove the need to declare a java static field for the property name in the protocol/implementation class. This reduces the footprint as the string is final and thus can be included simply as a String constant pool entry.

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.

Field Summary
String	ALPHA_BETA_ALLOW_UPGRADE Allow database upgrade during alpha/beta time.
final public static String	AUTHENTICATION_PROVIDER_BUILTIN
final public static String	AUTHENTICATION_PROVIDER_LDAP
final public static String	AUTHENTICATION_PROVIDER_PARAMETER
final public static String	AUTHENTICATION_SERVER_PARAMETER
String	BOOT_ALL derby.system.bootAll Automatically boot any services at start up time.
String	BOOT_DB_CLASSPATH
final public static String	CHECKPOINT_INTERVAL
final public static String	CREATE_WITH_NO_LOG Creation of an access factory should be done with no logging.
String	DATABASE_CLASSPATH derby.database.classpath Consists of a series of two part jar names.
final public static String	DATABASE_MODULE
String	DATABASE_PROPERTIES_ONLY
final public static String	DEADLOCK_MONITOR Turn on lock monitor to help debug deadlocks.
final public static String	DEADLOCK_TIMEOUT Configuration parameter for deadlock timeouts, set in seconds.
final public static int	DEADLOCK_TIMEOUT_DEFAULT
final public static String	DEADLOCK_TRACE Turn on deadlock trace to help debug deadlocks. Effect 1: This property only takes effect if DEADLOCK_MONITOR is turned ON for deadlock trace.
final public static String	DEFAULT_ACCESS
final public static String	DEFAULT_CONNECTION_MODE_PROPERTY
int	DEFAULT_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
int	DEFAULT_LOCKS_ESCALATION_THRESHOLD
final public static String	DEFAULT_USER_NAME
String	DELETE_ON_CREATE derby.__deleteOnCreate Before creating this service delete any remenants (e.g.
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.
final public static String	DRDA_PROP_HOSTNAME
final public static String	DRDA_PROP_KEEPALIVE
final public static String	DRDA_PROP_LOGCONNECTIONS derby.drda.logConnections Indicates whether to log connections and disconnections.
final public static String	DRDA_PROP_MAXTHREADS
final public static String	DRDA_PROP_MINTHREADS
final public static String	DRDA_PROP_PORTNUMBER derby.drda.portNumber The port number used by the network server.
final public static 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.
final public static String	DRDA_PROP_STREAMOUTBUFFERSIZE derby.drda.streamOutBufferSize size of buffer used when stream out for client.
final public static String	DRDA_PROP_TIMESLICE
final public static String	DRDA_PROP_TRACE
final public static String	DRDA_PROP_TRACEALL derby.drda.traceAll Turns tracing on for all sessions.
final public static String	DRDA_PROP_TRACEDIRECTORY derby.drda.traceDirectory The directory used for network server tracing files. Default: if the derby.system.home property has been set, it is the default.
final public static 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. 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.
final public static 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.
String	ERRORLOG_FIELD_PROPERTY
String	ERRORLOG_FILE_PROPERTY derby.stream.error.file=absolute or relative error log filename Takes precendence over derby.stream.error.method.
String	ERRORLOG_METHOD_PROPERTY
final public static 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.
String	FORCE_DATABASE_LOCK derby.database.forceDatabaseLock Cloudscape attempts to prevent two instances of Cloudscape from booting the same database with the use of a file called db.lck inside the database directory. On some platforms, Cloudscape can successfully prevent a second instance of Cloudscape from booting the database, and thus prevents corruption.
final public static String	FULL_ACCESS
final public static String	FULL_ACCESS_USERS_PROPERTY
final public static String	HTTP_DB_FILE_LENGTH
final public static String	HTTP_DB_FILE_NAME
final public static String	HTTP_DB_FILE_OFFSET
final public static int	IDX_PAGE_SIZE_BUMP_THRESHOLD The bump threshold for pages size for index.
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.
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.
String	LANG_PERMISSIONS_CACHE_SIZE The size of the permissions cache used by the data dictionary. Database.
int	LANG_PERMISSIONS_CACHE_SIZE_DEFAULT
String	LANG_SPS_CACHE_SIZE The size of the stored prepared statment descriptor cache used by the data dictionary.
int	LANG_SPS_CACHE_SIZE_DEFAULT
String	LANG_TD_CACHE_SIZE The size of the table descriptor cache used by the data dictionary.
int	LANG_TD_CACHE_SIZE_DEFAULT
String	LOCKS_ESCALATION_THRESHOLD derby.locks.escalationThreshold The number of row locks on a table after which we escalate to table locking.
String	LOCKS_INTRO
final public static String	LOCKWAIT_TIMEOUT Configuration parameter for lock wait timeouts, set in seconds.
final public static String	LOG_ARCHIVAL_DIRECTORY
String	LOG_ARCHIVE_MODE derby.storage.logArchiveMode used to identify whether the log is being archived for the database or not. It Is stored in the service.properties file. This property can be set to the boolean values "true" or "false".
final public static String	LOG_BUFFER_SIZE
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.
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.
String	LOG_SEVERITY_LEVEL derby.stream.error.logSeverityLevel=integerValue Indicates the minimum level of severity for errors that are reported to the error stream.
final public static String	LOG_SWITCH_INTERVAL
int	MIN_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
int	MIN_LOCKS_ESCALATION_THRESHOLD
String	MODULE_ENV_CLASSES_PREFIX Declare a set of classes that the class for a module or sub sub protocol requires. Value is a comma separated list of classes.
String	MODULE_ENV_JDK_PREFIX Declare a minimum JDK level the class for a module or sub sub protocol supports. Set to an integer value from the JVMInfo class to represent a JDK. If the JDK is running at a lower level than the class requires then the class will not be loaded and will not be used. If there are multiple modules classes implementing the same functionality and supported by the JVM, then the one with the highest JDK requirements will be selected.
String	MODULE_PREFIX derby.module.modulename Defines a new module.
final public static String	NO_ACCESS
String	NO_AUTO_BOOT derby.database.noAutoBoot Don't automatically boot this service at start up time.
final public static String	PAGE_SIZE_DEFAULT_LONG The default page size to use for tables that contain a long column.
final public static String	PAGE_SIZE_PARAMETER The page size to create a table or index with.
String	PROPERTIES_CONGLOM_ID derby.storage.propertiesId Stores the id of the conglomerate that holds the per-database properties.
final public static String	PROPERTIES_FILE Name of the file that contains system wide properties.
final public static String	PROPERTY_RUNTIME_PREFIX By convention properties that must not be stored any persistent form of service properties start with this prefix.
final public static String	READ_ONLY_ACCESS
final public static String	READ_ONLY_ACCESS_USERS_PROPERTY
final public static String	REQUIRE_AUTHENTICATION_PARAMETER
final public static String	ROW_LOCKING In cloudscape products which support Row Level Locking (rll), use this property to disable rll.
final public static String	SERVICE_LOCALE
final public static String	SERVICE_PROTOCOL
final public static String	SQL_AUTHORIZATION_PROPERTY
final public static String	START_DRDA derby.drda.startNetworkServer If true then we will attempt to start a DRDA network server when Cloudscape boots, turning the current JVM into a server.
String	STATEMENT_CACHE_SIZE
int	STATEMENT_CACHE_SIZE_DEFAULT
final public static 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. An internal debug system only flag.
final public static 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. An internal debug system only flag.
final public static String	STORAGE_LOG_NOT_SYNCED db2j.storage.logNotSynced When set, the store system will not force a sync() call on the log at commit. An internal debug system only flag.
String	STORAGE_TEMP_DIRECTORY derby.storage.tempDirectory Sets the temp directory for a database.
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 org.apache.derby.io.StorageFactory StorageFactory or org.apache.derby.io.WritableStorageFactory WritableStorageFactory interface.
String	SYSTEM_HOME_PROPERTY derby.system.home Property name for the home directory.
final public static int	TBL_PAGE_SIZE_BUMP_THRESHOLD
final public static String	USER_PROPERTY_PREFIX
final public static int	WAIT_TIMEOUT_DEFAULT

Field Detail

ALPHA_BETA_ALLOW_UPGRADE
String ALPHA_BETA_ALLOW_UPGRADE(Code)
	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.

AUTHENTICATION_PROVIDER_BUILTIN
final public static String AUTHENTICATION_PROVIDER_BUILTIN(Code)

AUTHENTICATION_PROVIDER_LDAP
final public static String AUTHENTICATION_PROVIDER_LDAP(Code)

AUTHENTICATION_PROVIDER_PARAMETER
final public static String AUTHENTICATION_PROVIDER_PARAMETER(Code)

AUTHENTICATION_SERVER_PARAMETER
final public static String AUTHENTICATION_SERVER_PARAMETER(Code)

BOOT_ALL
String BOOT_ALL(Code)
	derby.system.bootAll Automatically boot any services at start up time. When set to true this services will be booted at startup, otherwise services will be booted on demand.

BOOT_DB_CLASSPATH
String BOOT_DB_CLASSPATH(Code)
	internal use only, passes the database classpathinto the class manager

CHECKPOINT_INTERVAL
final public static String CHECKPOINT_INTERVAL(Code)
	Property name for specifying checkpoint interval

CREATE_WITH_NO_LOG
final public static String CREATE_WITH_NO_LOG(Code)
	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.

DATABASE_CLASSPATH
String DATABASE_CLASSPATH(Code)
	derby.database.classpath Consists of a series of two part jar names.

DATABASE_MODULE
final public static String DATABASE_MODULE(Code)

DATABASE_PROPERTIES_ONLY
String DATABASE_PROPERTIES_ONLY(Code)
	derby.database.propertiesOnly

DEADLOCK_MONITOR
final public static String DEADLOCK_MONITOR(Code)
	Turn on lock monitor to help debug deadlocks. Default value is OFF. With this property turned on, all deadlocks will cause a tracing to be output to the db2j.LOG file. This property takes effect dynamically.

DEADLOCK_TIMEOUT
final public static String DEADLOCK_TIMEOUT(Code)
	Configuration parameter for deadlock timeouts, set in seconds.

DEADLOCK_TIMEOUT_DEFAULT
final public static int DEADLOCK_TIMEOUT_DEFAULT(Code)
	Default value for deadlock timesouts (20 seconds)

DEADLOCK_TRACE
final public static String DEADLOCK_TRACE(Code)
	Turn on deadlock trace to help debug deadlocks. Effect 1: This property only takes effect if DEADLOCK_MONITOR is turned ON for deadlock trace. With this property turned on, each lock object involved in a deadlock will output its stack trace to db2j.LOG. Effect 2: When a timeout occurs, a lockTable dump will also be output to db2j.LOG. This acts independent of DEADLOCK_MONITOR. This property takes effect dynamically.

DEFAULT_ACCESS
final public static String DEFAULT_ACCESS(Code)

DEFAULT_CONNECTION_MODE_PROPERTY
final public static String DEFAULT_CONNECTION_MODE_PROPERTY(Code)

DEFAULT_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
int DEFAULT_LANGUAGE_STALE_PLAN_CHECK_INTERVAL(Code)
	Default value for above

DEFAULT_LOCKS_ESCALATION_THRESHOLD
int DEFAULT_LOCKS_ESCALATION_THRESHOLD(Code)
	The default value for LOCKS_ESCALATION_THRESHOLD

DEFAULT_USER_NAME
final public static String DEFAULT_USER_NAME(Code)

DELETE_ON_CREATE
String DELETE_ON_CREATE(Code)
	derby.__deleteOnCreate Before creating this service delete any remenants (e.g. the directory) of a previous service at the same location. INTERNAL USE ONLY

DELETE_ROOT_ON_ERROR
String DELETE_ROOT_ON_ERROR(Code)
	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. INTERNAL USE ONLY

DRDA_PROP_HOSTNAME
final public static String DRDA_PROP_HOSTNAME(Code)

DRDA_PROP_KEEPALIVE
final public static String DRDA_PROP_KEEPALIVE(Code)
	derby.drda.keepAlive client socket setKeepAlive value

DRDA_PROP_LOGCONNECTIONS
final public static String DRDA_PROP_LOGCONNECTIONS(Code)
	derby.drda.logConnections Indicates whether to log connections and disconnections. Default: false

DRDA_PROP_MAXTHREADS
final public static String DRDA_PROP_MAXTHREADS(Code)

DRDA_PROP_MINTHREADS
final public static String DRDA_PROP_MINTHREADS(Code)

DRDA_PROP_PORTNUMBER
final public static String DRDA_PROP_PORTNUMBER(Code)
	derby.drda.portNumber The port number used by the network server.

DRDA_PROP_SECURITYMECHANISM
final public static String DRDA_PROP_SECURITYMECHANISM(Code)
	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. No other types of connections are accepted. if the derby.drda.securityMechanism is not set at all, then the Network Server accepts any connection which uses a valid security mechanism. E.g derby.drda.securityMechanism=USER_ONLY_SECURITY This property is static. Server must be restarted for the property to take effect. Default value for this property is as though it is not set - in which case the server will allow clients with supported security mechanisms to connect

DRDA_PROP_STREAMOUTBUFFERSIZE
final public static String DRDA_PROP_STREAMOUTBUFFERSIZE(Code)
	derby.drda.streamOutBufferSize size of buffer used when stream out for client.

DRDA_PROP_TIMESLICE
final public static String DRDA_PROP_TIMESLICE(Code)

DRDA_PROP_TRACE
final public static String DRDA_PROP_TRACE(Code)

DRDA_PROP_TRACEALL
final public static String DRDA_PROP_TRACEALL(Code)
	derby.drda.traceAll Turns tracing on for all sessions. Default: false

DRDA_PROP_TRACEDIRECTORY
final public static String DRDA_PROP_TRACEDIRECTORY(Code)
	derby.drda.traceDirectory The directory used for network server tracing files. Default: if the derby.system.home property has been set, it is the default. Otherwise, the default is the current directory.

DURABILITY_PROPERTY

final public static String DURABILITY_PROPERTY(Code)

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.
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.

DURABILITY_TESTMODE_NO_SYNC
final public static String DURABILITY_TESTMODE_NO_SYNC(Code)
	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. It is also possible that the database might be in an inconsistent state See Also: Property.DURABILITY_PROPERTY

ERRORLOG_FIELD_PROPERTY
String ERRORLOG_FIELD_PROPERTY(Code)
	derby.stream.error.field= . returning an OutputStream or Writer object>

ERRORLOG_FILE_PROPERTY
String ERRORLOG_FILE_PROPERTY(Code)
	derby.stream.error.file=absolute or relative error log filename Takes precendence over derby.stream.error.method. Takes precendence over derby.stream.error.field

ERRORLOG_METHOD_PROPERTY
String ERRORLOG_METHOD_PROPERTY(Code)
	derby.stream.error.method= . returning an OutputStream or Writer object Takes precendence over derby.stream.error.field

FILESYNC_TRANSACTION_LOG

final public static String FILESYNC_TRANSACTION_LOG(Code)

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.

FORCE_DATABASE_LOCK
String FORCE_DATABASE_LOCK(Code)
	derby.database.forceDatabaseLock Cloudscape attempts to prevent two instances of Cloudscape from booting the same database with the use of a file called db.lck inside the database directory. On some platforms, Cloudscape can successfully prevent a second instance of Cloudscape from booting the database, and thus prevents corruption. If this is the case, you will see an SQLException like the following: ERROR XJ040: Failed to start database 'toursDB', see the next exception for details. ERROR XSDB6: Another instance of Cloudscape may have already booted the database C:\databases\toursDB. The error is also written to the information log. On other platforms, Cloudscape issues a warning message if an instance of Cloudscape attempts to boot a database that may already have a running instance of Cloudscape attached to it. However, it does not prevent the second instance from booting, and thus potentially corrupting, the database. If a warning message has been issued, corruption may already have occurred. NOTE: When you are using Cloudview, error messages appear in the console or operating system window from which Cloudview was started. The warning message looks like this: WARNING: Cloudscape (instance 80000000-00d2-3265-de92-000a0a0a0200) is attempting to boot the database /export/home/sky/wombat even though Cloudscape (instance 80000000-00d2-3265-8abf-000a0a0a0200) may still be active. Only one instance of Cloudscape should boot a database at a time. Severe and non-recoverable corruption can result and may have already occurred. The warning is also written to the information log. This warning is primarily a Technical Support aid to determine the cause of corruption. However, if you see this warning, your best choice is to close the connection and exit the JVM. This minimizes the risk of a corruption. Close all instances of Cloudscape, then restart one instance of Cloudscape and shut down the database properly so that the db.lck file can be removed. The warning message continues to appear until a proper shutdown of the Cloudscape system can delete the db.lck file. If the "derby.database.forceDatabaseLock" property is set to true then this default behavior is altered on systems where cloudscape cannot prevent this dual booting. If the to true, then if the platform does not provide the ability for cloudscape to guarantee no double boot, and if cloudscape finds a db.lck file when it boots, it will throw an exception (TODO - mikem - add what exception), leave the db.lck file in place and not boot the system. At this point the system will not boot until the db.lck file is removed by hand. Note that this situation can arise even when 2 VM's are not accessing the same cloudscape system. Also note that if the db.lck file is removed by hand while a VM is still accessing a derby.database, then there is no way for cloudscape to prevent a second VM from starting up and possibly corrupting the database. In this situation no warning message will be logged to the error log. To disable the default behavior of the db.lck file set property as follows: derby.database.forceDatabaseLock=true

FULL_ACCESS
final public static String FULL_ACCESS(Code)

FULL_ACCESS_USERS_PROPERTY
final public static String FULL_ACCESS_USERS_PROPERTY(Code)

HTTP_DB_FILE_LENGTH
final public static String HTTP_DB_FILE_LENGTH(Code)

HTTP_DB_FILE_NAME
final public static String HTTP_DB_FILE_NAME(Code)

HTTP_DB_FILE_OFFSET
final public static String HTTP_DB_FILE_OFFSET(Code)

IDX_PAGE_SIZE_BUMP_THRESHOLD
final public static int IDX_PAGE_SIZE_BUMP_THRESHOLD(Code)
	The bump threshold for pages size for index. If the approximate key columns of an index is greater than this threshold, the page size for the index is bumped to PAGE_SIZE_DEFAULT_LONG provided the page size is not already specified as a property

IN_RESTORE_FROM_BACKUP
String IN_RESTORE_FROM_BACKUP(Code)
	db2j.inRestore This Property is used to indicate that we are in restore mode if if the system is doing a restore from backup. Used internally to set flags to indicate that service is not booted. INTERNAL USE ONLY

LANGUAGE_STALE_PLAN_CHECK_INTERVAL

String LANGUAGE_STALE_PLAN_CHECK_INTERVAL(Code)

derby.language.stalePlanCheckInterval

This property tells the number of times a prepared statement should be executed before checking whether its plan is stale. Database. Dynamic.

Externally visible.

LANG_PERMISSIONS_CACHE_SIZE
String LANG_PERMISSIONS_CACHE_SIZE(Code)
	The size of the permissions cache used by the data dictionary. Database. Static. Undocumented.

LANG_PERMISSIONS_CACHE_SIZE_DEFAULT
int LANG_PERMISSIONS_CACHE_SIZE_DEFAULT(Code)

LANG_SPS_CACHE_SIZE
String LANG_SPS_CACHE_SIZE(Code)
	The size of the stored prepared statment descriptor cache used by the data dictionary. Database. Static. Externally visible.

LANG_SPS_CACHE_SIZE_DEFAULT
int LANG_SPS_CACHE_SIZE_DEFAULT(Code)

LANG_TD_CACHE_SIZE
String LANG_TD_CACHE_SIZE(Code)
	The size of the table descriptor cache used by the data dictionary. Database. Static. Undocumented.

LANG_TD_CACHE_SIZE_DEFAULT
int LANG_TD_CACHE_SIZE_DEFAULT(Code)

LOCKS_ESCALATION_THRESHOLD
String LOCKS_ESCALATION_THRESHOLD(Code)
	derby.locks.escalationThreshold The number of row locks on a table after which we escalate to table locking. Also used by the optimizer to decide when to start with table locking. The String value must be convertible to an int.

LOCKS_INTRO
String LOCKS_INTRO(Code)

LOCKWAIT_TIMEOUT
final public static String LOCKWAIT_TIMEOUT(Code)
	Configuration parameter for lock wait timeouts, set in seconds.

LOG_ARCHIVAL_DIRECTORY
final public static String LOG_ARCHIVAL_DIRECTORY(Code)
	Property name for specifying log archival location

LOG_ARCHIVE_MODE
String LOG_ARCHIVE_MODE(Code)
	derby.storage.logArchiveMode used to identify whether the log is being archived for the database or not. It Is stored in the service.properties file. This property can be set to the boolean values "true" or "false". Setting the property to true means log is being archived, which could be used for roll-forward recovery. Setting the property to false disables log archive mode. INTERNAL USE ONLY

LOG_BUFFER_SIZE
final public static String LOG_BUFFER_SIZE(Code)
	Property name for specifying log Buffer Size

LOG_DEVICE_AT_BACKUP
String LOG_DEVICE_AT_BACKUP(Code)
	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. INTERNAL USE ONLY

LOG_FILE_APPEND
String LOG_FILE_APPEND(Code)
	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. User can specifiy whether info log file should append or not by setting derby.infolog.append={true/false} The default behavior is that the exiting file will be deleted when a new info stream is started.

LOG_SEVERITY_LEVEL
String LOG_SEVERITY_LEVEL(Code)
	derby.stream.error.logSeverityLevel=integerValue Indicates the minimum level of severity for errors that are reported to the error stream. Default to 0 in a "sane" server, and SESSION_SEVERITY in the insane (and product) server. See Also: org.apache.derby.iapi.error.ExceptionSeverity.SESSION_SEVERITY

LOG_SWITCH_INTERVAL
final public static String LOG_SWITCH_INTERVAL(Code)
	Property name for specifying log switch interval

MIN_LANGUAGE_STALE_PLAN_CHECK_INTERVAL
int MIN_LANGUAGE_STALE_PLAN_CHECK_INTERVAL(Code)
	Minimum value for above

MIN_LOCKS_ESCALATION_THRESHOLD
int MIN_LOCKS_ESCALATION_THRESHOLD(Code)
	The minimum value for LOCKS_ESCALATION_THRESHOLD

MODULE_ENV_CLASSES_PREFIX
String MODULE_ENV_CLASSES_PREFIX(Code)
	Declare a set of classes that the class for a module or sub sub protocol requires. Value is a comma separated list of classes. If the classes listed are not loadable by the virtual machine then the module class will not be loaded and will not be used.

MODULE_ENV_JDK_PREFIX
String MODULE_ENV_JDK_PREFIX(Code)
	Declare a minimum JDK level the class for a module or sub sub protocol supports. Set to an integer value from the JVMInfo class to represent a JDK. If the JDK is running at a lower level than the class requires then the class will not be loaded and will not be used. If there are multiple modules classes implementing the same functionality and supported by the JVM, then the one with the highest JDK requirements will be selected. This functionality is not present for sub sub protocol classes yet. See org.apache.derby.iapi.services.info.JVMInfo.JDK_ID

MODULE_PREFIX

String MODULE_PREFIX(Code)

derby.module.modulename

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.

org.apache.derby.iapi.services.monitor.ModuleControl
org.apache.derby.iapi.services.monitor.ModuleSupportable

NO_ACCESS
final public static String NO_ACCESS(Code)

NO_AUTO_BOOT
String NO_AUTO_BOOT(Code)
	derby.database.noAutoBoot Don't automatically boot this service at start up time. When set to true this service will only be booted on demand, otherwise the service will be booted at startup time if possible.

PAGE_SIZE_DEFAULT_LONG
final public static String PAGE_SIZE_DEFAULT_LONG(Code)
	The default page size to use for tables that contain a long column.

PAGE_SIZE_PARAMETER
final public static String PAGE_SIZE_PARAMETER(Code)
	The page size to create a table or index with. Must be a multiple of 2k, usual choices are: 2k, 4k, 8k, 16k, 32k, 64k. The default if property is not set is 4k.

PROPERTIES_CONGLOM_ID
String PROPERTIES_CONGLOM_ID(Code)
	derby.storage.propertiesId Stores the id of the conglomerate that holds the per-database properties. Is stored in the service.properties file. INTERNAL USE ONLY

PROPERTIES_FILE
final public static String PROPERTIES_FILE(Code)
	Name of the file that contains system wide properties. Has to be located in ${derby.system.home} if set, otherwise ${user.dir}

PROPERTY_RUNTIME_PREFIX
final public static String PROPERTY_RUNTIME_PREFIX(Code)
	By convention properties that must not be stored any persistent form of service properties start with this prefix.

READ_ONLY_ACCESS
final public static String READ_ONLY_ACCESS(Code)

READ_ONLY_ACCESS_USERS_PROPERTY
final public static String READ_ONLY_ACCESS_USERS_PROPERTY(Code)

REQUIRE_AUTHENTICATION_PARAMETER
final public static String REQUIRE_AUTHENTICATION_PARAMETER(Code)

ROW_LOCKING
final public static String ROW_LOCKING(Code)
	In cloudscape products which support Row Level Locking (rll), use this property to disable rll. Application's which use rll will use more system resources, so if an application knows that it does not need rll then it can use this system property to force all locking in the system to lock at the table level. This property can be set to the boolean values "true" or "false". Setting the property to true is the same as not setting the property at all, and will result in rll being enabled. Setting the property to false disables rll.

SERVICE_LOCALE
final public static String SERVICE_LOCALE(Code)

SERVICE_PROTOCOL
final public static String SERVICE_PROTOCOL(Code)

SQL_AUTHORIZATION_PROPERTY
final public static String SQL_AUTHORIZATION_PROPERTY(Code)

START_DRDA
final public static String START_DRDA(Code)
	derby.drda.startNetworkServer If true then we will attempt to start a DRDA network server when Cloudscape boots, turning the current JVM into a server. Default: false

STATEMENT_CACHE_SIZE
String STATEMENT_CACHE_SIZE(Code)

STATEMENT_CACHE_SIZE_DEFAULT
int STATEMENT_CACHE_SIZE_DEFAULT(Code)

STORAGE_DATA_NOT_SYNCED_AT_ALLOCATION

final public static String STORAGE_DATA_NOT_SYNCED_AT_ALLOCATION(Code)

db2j.storage.dataNotSyncedAtAllocation

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.

STORAGE_DATA_NOT_SYNCED_AT_CHECKPOINT

final public static String STORAGE_DATA_NOT_SYNCED_AT_CHECKPOINT(Code)

db2j.storage.dataNotSyncedAtCheckPoint

When set, the store system will not force a sync() call on the containers during a checkpoint.

STORAGE_LOG_NOT_SYNCED

final public static String STORAGE_LOG_NOT_SYNCED(Code)

db2j.storage.logNotSynced

When set, the store system will not force a sync() call on the log at commit.

STORAGE_TEMP_DIRECTORY
String STORAGE_TEMP_DIRECTORY(Code)
	derby.storage.tempDirectory Sets the temp directory for a database.

SUB_SUB_PROTOCOL_PREFIX

String SUB_SUB_PROTOCOL_PREFIX(Code)

derby.subSubProtocol.xxx

A new subsubprotocol can be defined by specifying the class that handles storage for the subsubprotocol by implementing the org.apache.derby.io.StorageFactory StorageFactory or org.apache.derby.io.WritableStorageFactory 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.

SYSTEM_HOME_PROPERTY
String SYSTEM_HOME_PROPERTY(Code)
	derby.system.home Property name for the home directory. Any relative path in the system should be accessed though this property

TBL_PAGE_SIZE_BUMP_THRESHOLD
final public static int TBL_PAGE_SIZE_BUMP_THRESHOLD(Code)
	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

USER_PROPERTY_PREFIX
final public static String USER_PROPERTY_PREFIX(Code)

WAIT_TIMEOUT_DEFAULT
final public static int WAIT_TIMEOUT_DEFAULT(Code)
	Default value for wait timeouts (60 seconds)

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.