SQLServerConnection Members

DownloadDownload 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.
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.
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.
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.
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.
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.
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