java.io.Serializable
, java.lang.AutoCloseable
public class SQLServerBulkCopy
extends java.lang.Object
implements java.lang.AutoCloseable, java.io.Serializable
Constructor | Description |
---|---|
SQLServerBulkCopy(java.lang.String connectionUrl) |
Constructs a SQLServerBulkCopy based on the supplied connectionString.
|
SQLServerBulkCopy(java.sql.Connection connection) |
Constructs a SQLServerBulkCopy using the specified open instance of SQLServerConnection.
|
Modifier and Type | Method | Description |
---|---|---|
void |
addColumnMapping(int sourceColumn,
int destinationColumn) |
Adds a new column mapping, using ordinals to specify both the source and destination columns.
|
void |
addColumnMapping(int sourceColumn,
java.lang.String destinationColumn) |
Adds a new column mapping, using an ordinal for the source column and a string for the destination column.
|
void |
addColumnMapping(java.lang.String sourceColumn,
int destinationColumn) |
Adds a new column mapping, using a column name to describe the source column and an ordinal to specify the
destination column.
|
void |
addColumnMapping(java.lang.String sourceColumn,
java.lang.String destinationColumn) |
Adds a new column mapping, using column names to specify both source and destination columns.
|
void |
clearColumnMappings() |
Clears the contents of the column mappings
|
void |
close() |
Closes the SQLServerBulkCopy instance
|
SQLServerBulkCopyOptions |
getBulkCopyOptions() |
Returns the current SQLServerBulkCopyOptions.
|
java.lang.String |
getDestinationTableName() |
Returns the name of the destination table on the server.
|
protected java.lang.Object |
getTemporalObjectFromCSVWithFormatter(java.lang.String valueStrUntrimmed,
int srcJdbcType,
int srcColOrdinal,
java.time.format.DateTimeFormatter dateTimeFormatter) |
Returns the temporal object from CSV This method is called against jdbc41, but it require jdbc42 to work
therefore, we will throw exception.
|
void |
setBulkCopyOptions(SQLServerBulkCopyOptions copyOptions) |
Update the behavior of the SQLServerBulkCopy instance according to the options supplied, if supplied
SQLServerBulkCopyOption is not null.
|
protected void |
setDestinationTableMetadata(SQLServerResultSet rs) |
|
void |
setDestinationTableName(java.lang.String tableName) |
Sets the name of the destination table on the server.
|
protected void |
setStmtColumnEncriptionSetting(SQLServerStatementColumnEncryptionSetting stmtColumnEncriptionSetting) |
|
void |
writeToServer(ISQLServerBulkRecord sourceData) |
Copies all rows from the supplied ISQLServerBulkRecord to a destination table specified by the
destinationTableName property of the SQLServerBulkCopy object.
|
void |
writeToServer(java.sql.ResultSet sourceData) |
Copies all rows in the supplied ResultSet to a destination table specified by the destinationTableName property
of the SQLServerBulkCopy object.
|
void |
writeToServer(javax.sql.RowSet sourceData) |
Copies all rows in the supplied RowSet to a destination table specified by the destinationTableName property of
the SQLServerBulkCopy object.
|
public SQLServerBulkCopy(java.sql.Connection connection) throws SQLServerException
connection
- Open instance of Connection to destination server. Must be from the Microsoft JDBC driver for SQL Server.SQLServerException
- If the supplied type is not a connection from the Microsoft JDBC driver for SQL Server.public SQLServerBulkCopy(java.lang.String connectionUrl) throws SQLServerException
connectionUrl
- Connection string for the destination server.SQLServerException
- If a connection cannot be established.public void addColumnMapping(int sourceColumn, int destinationColumn) throws SQLServerException
sourceColumn
- Source column ordinal.destinationColumn
- Destination column ordinal.SQLServerException
- If the column mapping is invalidpublic void addColumnMapping(int sourceColumn, java.lang.String destinationColumn) throws SQLServerException
sourceColumn
- Source column ordinal.destinationColumn
- Destination column name.SQLServerException
- If the column mapping is invalidpublic void addColumnMapping(java.lang.String sourceColumn, int destinationColumn) throws SQLServerException
sourceColumn
- Source column name.destinationColumn
- Destination column ordinal.SQLServerException
- If the column mapping is invalidpublic void addColumnMapping(java.lang.String sourceColumn, java.lang.String destinationColumn) throws SQLServerException
sourceColumn
- Source column name.destinationColumn
- Destination column name.SQLServerException
- If the column mapping is invalidpublic void clearColumnMappings()
public void close()
close
in interface java.lang.AutoCloseable
public java.lang.String getDestinationTableName()
public void setDestinationTableName(java.lang.String tableName) throws SQLServerException
tableName
- Destination table name.SQLServerException
- If the table name is nullpublic SQLServerBulkCopyOptions getBulkCopyOptions()
public void setBulkCopyOptions(SQLServerBulkCopyOptions copyOptions) throws SQLServerException
copyOptions
- Settings to change how the WriteToServer methods behave.SQLServerException
- If the SQLServerBulkCopyOption class was constructed using an existing Connection and the
UseInternalTransaction option is specified.public void writeToServer(java.sql.ResultSet sourceData) throws SQLServerException
sourceData
- ResultSet to read data rows from.SQLServerException
- If there are any issues encountered when performing the bulk copy operationpublic void writeToServer(javax.sql.RowSet sourceData) throws SQLServerException
sourceData
- RowSet to read data rows from.SQLServerException
- If there are any issues encountered when performing the bulk copy operationpublic void writeToServer(ISQLServerBulkRecord sourceData) throws SQLServerException
sourceData
- SQLServerBulkReader to read data rows from.SQLServerException
- If there are any issues encountered when performing the bulk copy operationprotected java.lang.Object getTemporalObjectFromCSVWithFormatter(java.lang.String valueStrUntrimmed, int srcJdbcType, int srcColOrdinal, java.time.format.DateTimeFormatter dateTimeFormatter) throws SQLServerException
valueStrUntrimmed
- valueStrUntrimmedsrcJdbcType
- srcJdbcTypesrcColOrdinal
- srcColOrdinaldateTimeFormatter
- dateTimeFormatterSQLServerException
- if parsing errorprotected void setStmtColumnEncriptionSetting(SQLServerStatementColumnEncryptionSetting stmtColumnEncriptionSetting)
protected void setDestinationTableMetadata(SQLServerResultSet rs)
Copyright © 2018 Microsoft Corporation. All rights reserved.