Share via


SQLServerConnection Members

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.

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

Reference

SQLServerConnection Class