Purpose

Determines the mechanism that is used to execute batch operations.

Valid Values

nativeBatch | singleStatement

Behavior

If set to nativeBatch, 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 singleStatement, the driver uses the JDBC 3.0-compliant batch mechanism.

Notes

  • This connection property can affect performance.

Data Source Method

setBatchMechanism

Default

None

Data Type

String

See also