Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaySQLServerConnection Members
The following tables list the members that are exposed by the SQLServerConnection class.
None.
| Name | Description |
|---|---|
| TRANSACTION_SNAPSHOT | Used to specify the snapshot transaction isolation level. |
| Class inherited from: | Description |
|---|---|
| java.sql.Connection | TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE |
| 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. |
| Class inherited from: | Methods |
|---|---|
| java.lang.Object | clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait |
| java.lang.Wrapper | isWrapperFor, unwrap |