skip to main content
Using the JDBC Client : Using DataDirect Bulk Load
 

Using DataDirect Bulk Load

DataDirect Bulk Load is a feature that allows your application to send large numbers of rows of data to a database. Similar to batch operations, using bulk load improves performance because far fewer network round trips are required. Bulk load bypasses the data parsing usually done by the database, providing an additional performance gain over batch operations. You can perform bulk load operations by creating a DDBulkLoad object and using the methods provided by the DDBulkLoad interface in the com.ddtek.jdbc.extensions package for bulk load.
Important: Because a bulk load operation may bypass data integrity checks, your application must ensure that the data it is transferring does not violate integrity constraints in the database. For example, suppose you are bulk loading data into a database table and some of that data duplicates data stored as a primary key, which must be unique. The driver will not throw an exception to alert you to the error; your application must provide its own data integrity checks.