skip to main content
DataDirect Connect Drivers : Sybase Driver : Batch Inserts and Updates
  
Batch Inserts and Updates
The Sybase driver provides the following batch mechanisms:
*A JDBC-compliant mechanism that uses code in the driver to execute batch operations. This is the default mechanism used by the Sybase driver.
*A mechanism that uses the Sybase native batch functionality. This mechanism may be faster than the standard mechanism, particularly when performance-expensive network roundtrips are an issue. Be aware that if the execution of the batch results in an error, the driver cannot determine which statement in the batch caused the error. In addition, if the batch contained a statement that called a stored procedure or executed a trigger, multiple update counts for each batch statement or parameter set are generated.
To use the Sybase native batch mechanism, set the BatchPerformanceWorkaround property to true.