Is your feature request related to a problem? If so, please give a short summary of the problem and how the feature would resolve it
Using useBulkCopyForBatchInsert is super convinient, when we need to enable bulk insert while using 3rd party tools integrated via standard JDBC API (prepared statements). Unfortunately we faced a situation, where target tables have some constraints. The only option in this case is to use non-standard SQLServerBulkCopy+ SQLServerBulkCopyOptions APIs that is not available for us.
Describe the preferred solution
It would be great if SQLServerPreparedStatement could parse SQLServerBulkCopyOptions properties from connection string.
Describe alternatives you've considered
Request 3rd party tool developers to create separate implementation for MS SQL server databases that would be integrated with low-level bulk copy API.
Additional context
N/A
Reference Documentations/Specifications
N/A
Reference Implementation
N/A
Is your feature request related to a problem? If so, please give a short summary of the problem and how the feature would resolve it
Using
useBulkCopyForBatchInsertis super convinient, when we need to enable bulk insert while using 3rd party tools integrated via standard JDBC API (prepared statements). Unfortunately we faced a situation, where target tables have some constraints. The only option in this case is to use non-standardSQLServerBulkCopy+SQLServerBulkCopyOptionsAPIs that is not available for us.Describe the preferred solution
It would be great if
SQLServerPreparedStatementcould parseSQLServerBulkCopyOptionsproperties from connection string.Describe alternatives you've considered
Request 3rd party tool developers to create separate implementation for MS SQL server databases that would be integrated with low-level bulk copy API.
Additional context
N/A
Reference Documentations/Specifications
N/A
Reference Implementation
N/A