Package com.microsoft.sqlserver.jdbc
Interface ISQLServerStatement
- All Superinterfaces:
java.lang.AutoCloseable
,java.io.Serializable
,java.sql.Statement
,java.sql.Wrapper
- All Known Subinterfaces:
ISQLServerCallableStatement
,ISQLServerPreparedStatement
- All Known Implementing Classes:
SQLServerCallableStatement
,SQLServerPreparedStatement
,SQLServerStatement
public interface ISQLServerStatement
extends java.sql.Statement, java.io.Serializable
Provides an interface to the
SQLServerStatement
class.-
Field Summary
-
Method Summary
Modifier and Type Method Description int
getCancelQueryTimeout()
Returns thecancelQueryTimeout
property set on this SQLServerStatement object.java.lang.String
getResponseBuffering()
Returns the response buffering mode for this SQLServerStatement object.void
setCancelQueryTimeout(int seconds)
Sets thecancelQueryTimeout
property on this SQLServerStatement object to cancelqueryTimeout
set onConnection
orStatement
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
-
Method Details
-
setResponseBuffering
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
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
Returns thecancelQueryTimeout
property set on this SQLServerStatement object.- Returns:
- cancelQueryTimeout Time duration in seconds.
- Throws:
SQLServerException
- if any error occurs
-
setCancelQueryTimeout
Sets thecancelQueryTimeout
property on this SQLServerStatement object to cancelqueryTimeout
set onConnection
orStatement
level.- Parameters:
seconds
- Time duration in seconds.- Throws:
SQLServerException
- if any error occurs
-