skip to main content
Using the JDBC Client : JDBC Connection Properties : BlockFetchForUpdate
 

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