Skip to content

[FEATURE REQUEST] Set Bulk Copy options via connection string #2465

@typhoon2k

Description

@typhoon2k

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

Metadata

Metadata

Assignees

Labels

BacklogThe topic in question has been recognized and added to development backlogEnhancementAn enhancement to the driver. Lower priority than bugs.

Type

No type

Projects

Status

Closed Issues

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions