Package com.microsoft.sqlserver.jdbc

Class SQLServerConnection43

java.lang.Object

com.microsoft.sqlserver.jdbc.SQLServerConnection

com.microsoft.sqlserver.jdbc.SQLServerConnection43

All Implemented Interfaces:

ISQLServerConnection, ISQLServerConnection43, Serializable, AutoCloseable, Connection, Wrapper

public class SQLServerConnection43
extends SQLServerConnection
implements ISQLServerConnection43

SQLServerConnection43 extends SQLServerConnection43 class and implements ISQLServerConnection43 with methods introduced in JDBC 4.3 Specifications. This class is used by the drdiver when initializing a class with 43 driver version

See Also:

Serialized Form

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 Type	Method	Description
void	beginRequest()	Hints to the driver that a request, an independent unit of work, is beginning on this connection.
void	endRequest()	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 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, getDisableStatementPooling, getDiscardedServerPreparedStatementCount, getEnablePrepareOnFirstPreparedStatementCall, getSendTimeAsDatetime, getServerPreparedStatementDiscardThreshold, getStatementHandleCacheEntryCount, getStatementPoolingCacheSize, isStatementPoolingEnabled, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, setDisableStatementPooling, setEnablePrepareOnFirstPreparedStatementCall, setSendTimeAsDatetime, setServerPreparedStatementDiscardThreshold, setStatementPoolingCacheSize

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from class com.microsoft.sqlserver.jdbc.SQLServerConnection

abort, beginRequestInternal, clearWarnings, close, closeUnreferencedPreparedStatementHandles, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStatement, createStruct, endRequestInternal, getAutoCommit, getCatalog, getClientConnectionId, getClientInfo, getClientInfo, getColumnEncryptionTrustedMasterKeyPaths, getDisableStatementPooling, getDiscardedServerPreparedStatementCount, getEnablePrepareOnFirstPreparedStatementCall, getHoldability, getMetaData, getNetworkTimeout, getSchema, getSendTimeAsDatetime, getServerPreparedStatementDiscardThreshold, getStatementHandleCacheEntryCount, getStatementPoolingCacheSize, getTransactionIsolation, getTypeMap, getUseBulkCopyForBatchInsert, getWarnings, isClosed, isReadOnly, isStatementPoolingEnabled, isValid, isWrapperFor, nativeSQL, prepareCall, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, registerColumnEncryptionKeyStoreProviders, releaseSavepoint, removeColumnEncryptionTrustedMasterKeyPaths, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setColumnEncryptionKeyCacheTtl, setColumnEncryptionTrustedMasterKeyPaths, setDisableStatementPooling, setEnablePrepareOnFirstPreparedStatementCall, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setSendTimeAsDatetime, setServerPreparedStatementDiscardThreshold, setStatementPoolingCacheSize, setTransactionIsolation, setTypeMap, setUseBulkCopyForBatchInsert, toString, unwrap, updateColumnEncryptionTrustedMasterKeyPaths

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

beginRequest

public void beginRequest()
                  throws SQLException

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 between beginRequest, 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 and endRequest are not nested. Multiple calls to beginRequest without an intervening call to endRequest is not an error. The first beginRequest 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 in beginRequest, 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 interface Connection

Specified by:

beginRequest in interface ISQLServerConnection43

Throws:

SQLException - if an error occurs

See Also:

ISQLServerConnection43.endRequest()

endRequest

public void endRequest()
                throws SQLException

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 to beginRequest and endRequest are not nested. Multiple calls to endRequest without an intervening call to beginRequest is not an error. The first endRequest call marks the request completed and subsequent calls are treated as a no-op. If endRequest is called without an initial call to beginRequest is a no-op. This method is to be used by Connection pooling managers.

Specified by:

endRequest in interface Connection

Specified by:

endRequest in interface ISQLServerConnection43

Throws:

SQLException - if an error occurs

See Also:

ISQLServerConnection43.beginRequest()

setShardingKey

public void setShardingKey(ShardingKey shardingKey)
                    throws SQLException

Specified by:

setShardingKey in interface Connection

Throws:

SQLException

setShardingKey

public void setShardingKey(ShardingKey shardingKey,
                           ShardingKey superShardingKey)
                    throws SQLException

Specified by:

setShardingKey in interface Connection

Throws:

SQLException

setShardingKeyIfValid

public boolean setShardingKeyIfValid(ShardingKey shardingKey,
                                     int timeout)
                              throws SQLException

Specified by:

setShardingKeyIfValid in interface Connection

Throws:

SQLException

setShardingKeyIfValid

public boolean setShardingKeyIfValid(ShardingKey shardingKey,
                                     ShardingKey superShardingKey,
                                     int timeout)
                              throws SQLException

Specified by:

setShardingKeyIfValid in interface Connection

Throws:

SQLException