Module com.microsoft.sqlserver.jdbc
Package com.microsoft.sqlserver.jdbc
Interface ISQLServerBulkRecord
-
- All Superinterfaces:
ISQLServerBulkData
,Serializable
- All Known Implementing Classes:
SQLServerBulkCSVFileRecord
@Deprecated(since="8.1.0") public interface ISQLServerBulkRecord extends ISQLServerBulkData
Deprecated.as of 8.1.0, because the interface contains methods which are not called as part of actual bulk copy process. UseISQLServerBulkData
} instead.Provides an interface used to create classes that read in data from any source (such as a file) and allows a SQLServerBulkCopy class to write the data to SQL Server tables. This interface is implemented bySQLServerBulkRecord
Class
-
-
Method Summary
All Methods Instance Methods Abstract Methods Deprecated Methods Modifier and Type Method Description void
addColumnMetadata(int positionInFile, String name, int jdbcType, int precision, int scale)
Deprecated.Adds metadata for the given column in the file.void
addColumnMetadata(int positionInFile, String name, int jdbcType, int precision, int scale, DateTimeFormatter dateTimeFormatter)
Deprecated.Adds metadata for the given column in the file.DateTimeFormatter
getColumnDateTimeFormatter(int column)
Deprecated.Returns thedateTimeFormatter
for the given column.boolean
isAutoIncrement(int column)
Deprecated.Returns whether the column represents an identity column.void
setTimestampWithTimezoneFormat(String dateTimeFormat)
Deprecated.Sets the format for reading in dates from the file.void
setTimestampWithTimezoneFormat(DateTimeFormatter dateTimeFormatter)
Deprecated.Sets the format for reading in dates from the file.void
setTimeWithTimezoneFormat(String timeFormat)
Deprecated.Sets the format for reading in dates from the file.void
setTimeWithTimezoneFormat(DateTimeFormatter dateTimeFormatter)
Deprecated.Sets the format for reading in dates from the file.-
Methods inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerBulkData
getColumnName, getColumnOrdinals, getColumnType, getPrecision, getRowData, getScale, next
-
-
-
-
Method Detail
-
isAutoIncrement
boolean isAutoIncrement(int column)
Deprecated.Returns whether the column represents an identity column.- Parameters:
column
- Column ordinal- Returns:
- True if the column is an identity column; false otherwise.
-
addColumnMetadata
void addColumnMetadata(int positionInFile, String name, int jdbcType, int precision, int scale, DateTimeFormatter dateTimeFormatter) throws SQLServerException
Deprecated.Adds metadata for the given column in the file.- Parameters:
positionInFile
- Indicates which column the metadata is for. Columns start at 1.name
- Name for the column (optional if only using column ordinal in a mapping for SQLServerBulkCopy operation)jdbcType
- JDBC data type of the columnprecision
- Precision for the column (ignored for the appropriate data types)scale
- Scale for the column (ignored for the appropriate data types)dateTimeFormatter
- format to parse data that is sent- Throws:
SQLServerException
- when an error occurs
-
addColumnMetadata
void addColumnMetadata(int positionInFile, String name, int jdbcType, int precision, int scale) throws SQLServerException
Deprecated.Adds metadata for the given column in the file.- Parameters:
positionInFile
- Indicates which column the metadata is for. Columns start at 1.name
- Name for the column (optional if only using column ordinal in a mapping for SQLServerBulkCopy operation)jdbcType
- JDBC data type of the columnprecision
- Precision for the column (ignored for the appropriate data types)scale
- Scale for the column (ignored for the appropriate data types)- Throws:
SQLServerException
- when an error occurs
-
setTimestampWithTimezoneFormat
void setTimestampWithTimezoneFormat(String dateTimeFormat)
Deprecated.Sets the format for reading in dates from the file.- Parameters:
dateTimeFormat
- format to parse data sent as java.sql.Types.TIMESTAMP_WITH_TIMEZONE
-
setTimestampWithTimezoneFormat
void setTimestampWithTimezoneFormat(DateTimeFormatter dateTimeFormatter)
Deprecated.Sets the format for reading in dates from the file.- Parameters:
dateTimeFormatter
- format to parse data sent as java.sql.Types.TIMESTAMP_WITH_TIMEZONE
-
setTimeWithTimezoneFormat
void setTimeWithTimezoneFormat(String timeFormat)
Deprecated.Sets the format for reading in dates from the file.- Parameters:
timeFormat
- format to parse data sent as java.sql.Types.TIME_WITH_TIMEZONE
-
setTimeWithTimezoneFormat
void setTimeWithTimezoneFormat(DateTimeFormatter dateTimeFormatter)
Deprecated.Sets the format for reading in dates from the file.- Parameters:
dateTimeFormatter
- format to parse data sent as java.sql.Types.TIME_WITH_TIMEZONE
-
getColumnDateTimeFormatter
DateTimeFormatter getColumnDateTimeFormatter(int column)
Deprecated.Returns thedateTimeFormatter
for the given column.- Parameters:
column
- Column ordinal- Returns:
- dateTimeFormatter
-
-