The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs).
true: driver will cache the metadata at the connection level
false: driver will not do any connection level metadata caching
Caveat: If the table changes in any way (column definition, new columns, deleted columns, etc..), then during a bulk copy the operation may or may not error out when caching is enabled. Just a note that there could be unintended consequences without warning.
cacheBulkCopyMetadata
boolean connection property.Caveat: If the table changes in any way (column definition, new columns, deleted columns, etc..), then during a bulk copy the operation may or may not error out when caching is enabled. Just a note that there could be unintended consequences without warning.