This section discusses topics pertinent to multi-user systems,
in which concurrency is important.
Derby is configured
by default to work well for multi-user systems. For single-user systems, you
might want to tune your system so that it uses fewer resources; see Lock granularity.
Isolation levels and concurrency
Derby provides four transaction isolation levels. Setting the transaction isolation level for a connection allows a user to specify how severely the user's transaction should be isolated from other transactions.
Configuring isolation levels
If a connection does not specify its isolation level, it inherits the default isolation level for the Derby system. The default value is CS.
Derby can be configured for table-level locking. With table-level locking, when a transaction locks data in order to prevent any transaction anomalies, it always locks the entire table, not just those rows being accessed.