BlockFetchForUpdate

Description

Specifies a workaround connection attribute. When the isolation level is Read Committed and a SELECT FOR UPDATE statement is issued against some data stores, the JDBC Client does not lock the expected row.

This property can be specified using:

• JDBC data source
• URL
• java.util.properties
• server data source

Valid Values

0 | 1

When set to 0, the appropriate row is locked.

When set to 1, the appropriate row is not locked.

Important: Specifying 0 degrades performance for SELECT FOR UPDATE statements because rows are fetched one at a time.

Default

1

Data type

boolean