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.