Locking a table for the duration of a transaction

You can explicitly lock a table for the duration of a transaction with the LOCK TABLE statement.

This is useful if you know in advance that an entire table should be locked and you want to save the resources required for obtaining row locks until the system escalates the locking. For information about this feature, see "LOCK TABLE statement" in the Derby Reference Manual.

Related concepts
Transaction-based lock escalation