Purpose

Determines the method that is used to execute batch operations.

Valid Values

true | false

Behavior

If set to true, the driver uses the native Oracle batch mechanism. The native batch mechanism does not return individual update counts for each statement or parameter set in the batch. For this reason, the driver returns a value of SUCCESS_NO_INFO (-2) for each entry in the returned update count array. If an application can accept not receiving update count information, setting this property to true can significantly improve performance.

If set to false, the driver uses the JDBC 3.0-compliant batch mechanism.

Default

false

Data Type

boolean

See also

Batch Inserts and Updates

Performance Considerations