Package com.microsoft.sqlserver.jdbc

Interface ISQLServerBulkData

  • All Superinterfaces:
    java.io.Serializable
    All Known Subinterfaces:
    ISQLServerBulkRecord
    All Known Implementing Classes:
    SQLServerBulkBatchInsertRecord, SQLServerBulkCSVFileRecord
    public interface ISQLServerBulkData
extends java.io.Serializable
    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.

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      java.lang.String getColumnName​(int column)
      Returns the name of the given column.
      java.util.Set<java.lang.Integer> getColumnOrdinals()
      Returns the ordinals for each of the columns represented in this data record.
      int getColumnType​(int column)
      Returns the JDBC data type of the given column.
      int getPrecision​(int column)
      Returns the precision for the given column.
      java.lang.Object[] getRowData()
      Returns the data for the current row as an array of Objects.
      int getScale​(int column)
      Returns the scale for the given column.
      boolean next()
      Advances to the next data row.

    • Method Detail

      • getColumnOrdinals

        java.util.Set<java.lang.Integer> getColumnOrdinals()
        Returns the ordinals for each of the columns represented in this data record.
        Returns:
        Set of ordinals for the columns.

      • getColumnName

        java.lang.String getColumnName​(int column)
        Returns the name of the given column.
        Parameters:
        column - Column ordinal
        Returns:
        Name of the column

      • getColumnType

        int getColumnType​(int column)
        Returns the JDBC data type of the given column.
        Parameters:
        column - Column ordinal
        Returns:
        JDBC data type of the column

      • getPrecision

        int getPrecision​(int column)
        Returns the precision for the given column.
        Parameters:
        column - Column ordinal
        Returns:
        Precision of the column

      • getScale

        int getScale​(int column)
        Returns the scale for the given column.
        Parameters:
        column - Column ordinal
        Returns:
        Scale of the column

      • getRowData

        java.lang.Object[] getRowData()
                       throws java.sql.SQLException
        Returns the data for the current row as an array of Objects. Each Object must match the Java language Type that is used to represent the indicated JDBC data type for the given column. For more information, see 'Understanding the JDBC Driver Data Types' for the appropriate mappings.
        Returns:
        The data for the row.
        Throws:
        SQLServerException - If there are any errors in obtaining the data.
        java.sql.SQLException

      • next

        boolean next()
      throws java.sql.SQLException
        Advances to the next data row.
        Returns:
        True if rows are available; false if there are no more rows
        Throws:
        SQLServerException - If there are any errors in advancing to the next row.
        java.sql.SQLException