Configuring Bulk Load
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The driver supports DataDirect Bulk Load, a feature that allows your application to send large numbers of rows of data to a database. See Using DataDirect Bulk Load for more information. See Permissions for Bulk Load from a CSV File for information about granting permissions for bulk loading from a CSV file.
The following table summarizes the connection properties that affect how bulk load works with the Sybase driver.
| Property | Description |
|---|---|
| BulkLoadBatchSize | Provides a suggestion to the driver for the number of rows to load
to the database at a time when bulk loading data. The default is
2048. |
| EnableBulkLoad | Specifies whether the driver uses the native bulk load protocols in
the database instead of the batch mechanism for batch inserts. The default is
false. |