skip to main content
DataDirect Connect Drivers : Oracle Driver : Connection Properties : BatchPerformanceWorkaround
  
BatchPerformanceWorkaround
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