Class SQLServerConnection43
- All Implemented Interfaces:
ISQLServerConnection
,ISQLServerConnection43
,Serializable
,AutoCloseable
,Connection
,Wrapper
SQLServerConnection43
and implements ISQLServerConnection43
with methods introduced in JDBC
4.3 Specifications. This class is used by the driver when initializing a class with with JDBC 4.3 Specs supported
JVM.- See Also:
-
Field Summary
Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
Fields inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerConnection
TRANSACTION_SNAPSHOT
-
Method Summary
Modifier and TypeMethodDescriptionvoid
Hints to the driver that a request, an independent unit of work, is beginning on this connection.void
Hints to the driver that a request, an independent unit of work, has completed.void
setShardingKey
(ShardingKey shardingKey) void
setShardingKey
(ShardingKey shardingKey, ShardingKey superShardingKey) boolean
setShardingKeyIfValid
(ShardingKey shardingKey, int timeout) boolean
setShardingKeyIfValid
(ShardingKey shardingKey, ShardingKey superShardingKey, int timeout) Methods inherited from class com.microsoft.sqlserver.jdbc.SQLServerConnection
abort, clearUserTokenCache, clearWarnings, close, closeUnreferencedPreparedStatementHandles, commit, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientConnectionId, getClientInfo, getClientInfo, getColumnEncryptionTrustedMasterKeyPaths, getDelayLoadingLobs, getDisableStatementPooling, getDiscardedServerPreparedStatementCount, getEnablePrepareOnFirstPreparedStatementCall, getHoldability, getMetaData, getNetworkTimeout, getSchema, getSendTimeAsDatetime, getServerPreparedStatementDiscardThreshold, getStatementHandleCacheEntryCount, getStatementPoolingCacheSize, getTransactionIsolation, getTypeMap, getUseBulkCopyForBatchInsert, getUseFmtOnly, getWarnings, isClosed, isReadOnly, isStatementPoolingEnabled, isValid, isWrapperFor, nativeSQL, needsReconnect, prepareCall, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, registerColumnEncryptionKeyStoreProviders, registerColumnEncryptionKeyStoreProvidersOnConnection, releaseSavepoint, removeColumnEncryptionTrustedMasterKeyPaths, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setColumnEncryptionKeyCacheTtl, setColumnEncryptionTrustedMasterKeyPaths, setDelayLoadingLobs, setDisableStatementPooling, setEnablePrepareOnFirstPreparedStatementCall, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setSendTimeAsDatetime, setServerPreparedStatementDiscardThreshold, setStatementPoolingCacheSize, setTransactionIsolation, setTypeMap, setUseBulkCopyForBatchInsert, setUseFmtOnly, toString, unregisterColumnEncryptionKeyStoreProviders, unwrap, updateColumnEncryptionTrustedMasterKeyPaths
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface java.sql.Connection
abort, clearWarnings, close, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMetaData, getNetworkTimeout, getSchema, getTransactionIsolation, getTypeMap, getWarnings, isClosed, isReadOnly, isValid, nativeSQL, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setTransactionIsolation, setTypeMap
Methods inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerConnection
closeUnreferencedPreparedStatementHandles, createStatement, getClientConnectionId, getDelayLoadingLobs, getDisableStatementPooling, getDiscardedServerPreparedStatementCount, getEnablePrepareOnFirstPreparedStatementCall, getSendTimeAsDatetime, getServerPreparedStatementDiscardThreshold, getStatementHandleCacheEntryCount, getStatementPoolingCacheSize, getUseFmtOnly, isStatementPoolingEnabled, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, setDelayLoadingLobs, setDisableStatementPooling, setEnablePrepareOnFirstPreparedStatementCall, setSendTimeAsDatetime, setServerPreparedStatementDiscardThreshold, setStatementPoolingCacheSize, setUseFmtOnly
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
Method Details
-
beginRequest
Description copied from interface:ISQLServerConnection43
Hints to the driver that a request, an independent unit of work, is beginning on this connection. It backs up the values of the connection properties that are modifiable through public methods. Each request is independent of all other requests with regard to state local to the connection either on the client or the server. Work done betweenbeginRequest
,endRequest
pairs does not depend on any other work done on the connection either as part of another request or outside of any request. A request may include multiple transactions. There may be dependencies on committed database state as that is not local to the connection.beginRequest
marks the beginning of the work unit.Local state is defined as any state associated with a Connection that is local to the current Connection either in the client or the database that is not transparently reproducible.
Calls to
beginRequest
andendRequest
are not nested. Multiple calls tobeginRequest
without an intervening call toendRequest
is not an error. The firstbeginRequest
call marks the start of the request and subsequent calls are treated as a no-op It is recommended to enclose each unit of work inbeginRequest
,endRequest
pairs such that there is no open transaction at the beginning or end of the request and no dependency on local state that crosses request boundaries. Committed database state is not local. This method is to be used by Connection pooling managers.The pooling manager should call
beginRequest
on the underlying connection prior to returning a connection to the caller.- Specified by:
beginRequest
in interfaceConnection
- Specified by:
beginRequest
in interfaceISQLServerConnection43
- Throws:
SQLException
- if an error occurs- See Also:
-
endRequest
Description copied from interface:ISQLServerConnection43
Hints to the driver that a request, an independent unit of work, has completed. It rolls back the open transactions. Resets the connection properties that are modifiable through public methods back to their original values. Calls tobeginRequest
andendRequest
are not nested. Multiple calls toendRequest
without an intervening call tobeginRequest
is not an error. The firstendRequest
call marks the request completed and subsequent calls are treated as a no-op. IfendRequest
is called without an initial call tobeginRequest
is a no-op. This method is to be used by Connection pooling managers.- Specified by:
endRequest
in interfaceConnection
- Specified by:
endRequest
in interfaceISQLServerConnection43
- Throws:
SQLException
- if an error occurs- See Also:
-
setShardingKey
- Specified by:
setShardingKey
in interfaceConnection
- Throws:
SQLException
-
setShardingKey
public void setShardingKey(ShardingKey shardingKey, ShardingKey superShardingKey) throws SQLException - Specified by:
setShardingKey
in interfaceConnection
- Throws:
SQLException
-
setShardingKeyIfValid
- Specified by:
setShardingKeyIfValid
in interfaceConnection
- Throws:
SQLException
-
setShardingKeyIfValid
public boolean setShardingKeyIfValid(ShardingKey shardingKey, ShardingKey superShardingKey, int timeout) throws SQLException - Specified by:
setShardingKeyIfValid
in interfaceConnection
- Throws:
SQLException
-