The driver throws an exception if either of the following circumstances occur:
• If the driver performs a data export and the CSV file cannot be created
• If the driver performs a bulk load operation and the driver detects that the CSV file does not comply with the XML Schema described in the bulk load configuration file
Verifying the Bulk Load Configuration File for Database Connections
Before performing a bulk load operation, your application can verify the metadata in the bulk load configuration file against the structure of the target table using the validateTableFromFile() method. This ensures that the data in the CSV file is compatible with the target table structure.
Because the verification does not check the actual data in the CSV file, it is possible that the load can fail even if the verification succeeds. For example, suppose your bulk load configuration file has an Integer column that matches an Integer column in the target database. if you modified the data for the Integer column in the CSV file to contain non-digit characters, the bulk load operation would fail even though a verification using validateTableFromFile() would succeed.
Not all error messages or warnings generated by the verification process mean that the load will fail. Some messages notify you about possible incompatibilities between the source and target tables. For example, if the CSV file has a column defined as an integer and the column in the target table is defined as smallint, the load may still succeed if the values in the source column are small enough to fit in a smallint column.
