Edit

SQLServerConnection Members

  • Article

Download JDBC driver

The following tables list the members that are exposed by the SQLServerConnection class.

Constructors

None.

Fields

Name Description
TRANSACTION_SNAPSHOT Used to specify the snapshot transaction isolation level.

Inherited Fields

Class inherited from: Description
java.sql.Connection TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Methods

Name Description
clearWarnings Clears all warnings reported for this SQLServerConnection object.
close Releases the database for this SQLServerConnection object and JDBC resources immediately instead of waiting for them to be automatically released.
closeUnreferencedPreparedStatementHandles Forces the un-prepare requests for any outstanding discarded prepared statements to be executed.
commit Makes all changes made since the previous commit or rollback permanent, and releases any database locks that are currently held by this SQLServerConnection object.
createBlob Creates a java.sql.Blob object without any data.
createClob Creates a java.sql.Clob object without any data.
createNClob Creates a java.sql.NClob object without any data.
createStatement Creates a SQLServerStatement object for sending SQL statements to the database.
createSQLXML Creates a java.sql.SQLXML object without any data.
getAutoCommit Retrieves the current auto-commit mode for this SQLServerConnection object.
getCatalog Retrieves the current catalog name for this SQLServerConnection object.
getClientConnectionID Method (SQLServerConnection) Gets the connection ID of the most recent connection attempt, regardless of whether the attempt succeeded or failed.
getClientInfo Retrieves information regarding the client information properties supported by the JDBC driver.
getDisableStatementPooling Returns the value of disableStatementPooling connection property. This setting controls whether statement pooling is enabled or not for this connection.
getDiscardedServerPreparedStatementCount Returns the number of currently outstanding prepared statement unprepare actions.
getEnablePrepareOnFirstPreparedStatementCall Returns the value of enablePrepareOnFirstPreparedStatementCall connection property.
getHoldability Retrieves the current holdability of SQLServerResultSet objects that are created by using this SQLServerConnection object.
getMetaData Retrieves a SQLServerDatabaseMetaData object that contains metadata about the database to which this SQLServerConnection object represents a connection.
getServerPreparedStatementDiscardThreshold Returns the value of serverPreparedStatementDiscardThreshold connection property.
getStatementHandleCacheEntryCount Returns the current number of pooled prepared statement handles.
getStatementPoolingCacheSize Returns the size of the prepared statement cache for this connection.
getTransactionIsolation Retrieves the current transaction isolation level for this SQLServerConnection object.
getTypeMap Retrieves the Map object that is associated with this SQLServerConnection object.
getWarnings Retrieves the first warning reported by calls on this SQLServerConnection object.
isClosed Indicates whether this SQLServerConnection object has been closed.
isReadOnly Indicates whether this SQLServerConnection object is in read-only mode.
isStatementPoolingEnabled Returns whether statement pooling is enabled or not for this connection.
isValid Indicates whether this SQLServerConnection object has not been closed and is still valid.
nativeSQL Converts the given SQL statement into the native SQL grammar of the database server.
prepareCall Creates a SQLServerCallableStatement object for calling database stored procedures.
prepareStatement Creates a SQLServerPreparedStatement object for sending parameterized SQL statements to the database.
releaseSavepoint Removes the specified SQLServerSavepoint object from the current transaction.
rollback Undoes all changes made in the current transaction and releases any database locks currently held by this SQLServerConnection object.
setAutoCommit Sets the auto-commit mode for this SQLServerConnection object to the given state.
setCatalog Sets the specified catalog name to select a subspace of this SQLServerConnection object's database in which to work.
setClientInfo Sets the value of the client information properties.
setDisableStatementPooling Sets statement pooling to true or false.
setEnablePrepareOnFirstPreparedStatementCall Specifies the new value of the enablePrepareOnFirstPreparedStatementCall connection property.
setHoldability Changes the holdability of SQLServerResultSet objects that are created by using this SQLServerSavepoint object to the given holdability.
setReadOnly Puts this SQLServerConnection object in read-only mode as a hint to the JDBC driver to enable database optimizations.
setSavepoint Creates an unnamed savepoint in the current transaction and returns the new SQLServerSavepoint object that represents it.
setServerPreparedStatementDiscardThreshold Sets the new value of the serverPreparedStatementDiscardThreshold connection property.
setStatementPoolingCacheSize Sets the size of the prepared statement cache for this connection.
setTransactionIsolation Tries to change the transaction isolation level for this SQLServerConnection object to the one given.
setTypeMap Installs the given TypeMap object as the type map for this SQLServerConnection object.

Inherited Methods

Class inherited from: Methods
java.lang.Object clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait
java.lang.Wrapper isWrapperFor, unwrap

See Also

SQLServerConnection Class