Package com.microsoft.sqlserver.jdbc

Interface ISQLServerStatement

    • Field Summary

      • Fields inherited from interface java.sql.Statement

        CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      int getCancelQueryTimeout()
      Returns the cancelQueryTimeout property set on this SQLServerStatement object.
      java.lang.String getResponseBuffering()
      Returns the response buffering mode for this SQLServerStatement object.
      void setCancelQueryTimeout​(int seconds)
      Sets the cancelQueryTimeout property on this SQLServerStatement object to cancel queryTimeout set on Connection or Statement level.
      void setResponseBuffering​(java.lang.String value)
      Sets the response buffering mode for this SQLServerStatement object to case-insensitive String full or adaptive.

      • Methods inherited from interface java.sql.Statement

        addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

      • Methods inherited from interface java.sql.Wrapper

        isWrapperFor, unwrap

    • Method Detail

      • setResponseBuffering

        void setResponseBuffering​(java.lang.String value)
                   throws SQLServerException
        Sets the response buffering mode for this SQLServerStatement object to case-insensitive String full or adaptive.

        Response buffering controls the driver's buffering of responses from SQL Server.

        Possible values are:

        "full" - Fully buffer the response at execution time.

        "adaptive" - Data Pipe adaptive buffering

        Parameters:
        value - A String that contains the response buffering mode. The valid mode can be one of the following case-insensitive Strings: full or adaptive.
        Throws:
        SQLServerException - If there are any errors in setting the response buffering mode.

      • getResponseBuffering

        java.lang.String getResponseBuffering()
                               throws SQLServerException
        Returns the response buffering mode for this SQLServerStatement object.
        Returns:
        A String that contains a lower-case full or adaptive.
        Throws:
        SQLServerException - If there are any errors in retrieving the response buffering mode.

      • getCancelQueryTimeout

        int getCancelQueryTimeout()
                   throws SQLServerException
        Returns the cancelQueryTimeout property set on this SQLServerStatement object.
        Returns:
        cancelQueryTimeout Time duration in seconds.
        Throws:
        SQLServerException - if any error occurs

      • setCancelQueryTimeout

        void setCancelQueryTimeout​(int seconds)
                    throws SQLServerException
        Sets the cancelQueryTimeout property on this SQLServerStatement object to cancel queryTimeout set on Connection or Statement level.
        Parameters:
        seconds - Time duration in seconds.
        Throws:
        SQLServerException - if any error occurs