Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following tables list the members exposed by the SQLServerDataSource class.
Constructors
| Name | Description |
|---|---|
| SQLServerDataSource () | Initializes a new instance of the SQLServerDataSource class. |
Fields
None.
Inherited Fields
None.
Methods
| Name | Description |
|---|---|
| getApplicationIntent | Returns the value of the applicationIntent connection property. |
| getApplicationName | Returns the application name. |
| getConnection | Tries to establish a connection with the data source that this SQLServerDataSource object represents. |
| getDatabaseName | Returns the database name. |
| getDisableStatementPooling | Returns the value of disableStatementPooling connection property. This setting controls whether statement pooling is enabled or not for this connection. |
| getEnablePrepareOnFirstPreparedStatementCall | Returns the value of enablePrepareOnFirstPreparedStatementCall connection property. |
| getEncrypt | Returns a Boolean value indicating whether the encrypt property is enabled. |
| getDescription | Returns a description of the data source. |
| getFailoverPartner | Returns the name of the failover server used in a database mirroring configuration. |
| getHostNameInCertificate | Returns the host name used in validating the SQL Server Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL), certificate. |
| getInstanceName | Returns the SQL Server instance name. |
| getLastUpdateCount | Returns a boolean value indicating whether the lastUpdateCount property is enabled. |
| getLockTimeout | Returns an int value indicating the number of milliseconds the database waits before reporting a lock time out. |
| getLoginTimeout | Returns the number of seconds this SQLServerDataSource object waits while trying to make a connection. |
| getLogWriter | Returns a character output stream to be used for all logging and tracing messages. |
| getMultiSubnetFailover | Returns the value of the multiSubnetFailover connection property. |
| getPacketSize | Returns the current network packet size used to communicate with SQL Server, specified in bytes. |
| getPortNumber | Returns the current port number used to communicate with SQL Server. |
| getReference | Returns a reference to this SQLServerDataSource object. |
| getResponseBuffering | Returns the response buffering mode for this SQLServerDataSource object. |
| getSelectMethod | Returns the default cursor type used for all result sets created by using this SQLServerDataSource object. |
| getSendStringParametersAsUnicode | Returns a Boolean value indicating whether sending string parameters to the server in UNICODE format is enabled. |
| getSendTimeAsDatetime | Returns the setting of the SendTimeAsDatetime connection property. |
| getServerName | Returns the name of the computer running SQL Server. |
| getServerPreparedStatementDiscardThreshold | Returns the value of serverPreparedStatementDiscardThreshold connection property. |
| getStatementPoolingCacheSize | Returns the size of the prepared statement cache for this connection. |
| getTrustManagerClass | Returns the string value of the TrustManagerClass connection property. |
| getTrustManagerConstructorArg | Returns the string value of the TrustManagerConstructorArg connection property. |
| getTrustServerCertificate | Returns a Boolean value indicating whether the trustServerCertificate property is enabled. |
| getTrustStore | Returns the path (including file name) to the certificate trustStore file. |
| getURL | Returns the URL used to connect to the data source. |
| getUser | Returns the user name used to connect the data source. |
| getUseSQLServerBaseDate | Returns the setting of the useSQLServerBaseDate connection property. |
| getWorkstationID | Returns the name of the client computer name used to connect to the data source. |
| getXopenStates | Returns a Boolean value indicating whether converting SQL states to XOPEN compliant states is enabled. |
| isWrapperFor | Indicates whether this data source object is a wrapper for the specified interface. |
| setApplicationIntent | Sets the value of the applicationIntent connection property. |
| setApplicationName | Sets the application name. |
| setAuthenticationScheme | Indicates the kind of integrated security you want your application to use. |
| setDatabaseName | Sets the database name to connect to. |
| setDescription | Sets the description of the data source. |
| setDisableStatementPooling | Sets statement pooling to true or false. |
| setEnablePrepareOnFirstPreparedStatementCall | Specifies the new value of the enablePrepareOnFirstPreparedStatementCall connection property. |
| setEncrypt | Sets a Boolean value indicating whether the encrypt property is enabled. |
| setFailoverPartner | Sets the name of the failover server used in a database mirroring configuration. |
| setHostNameInCertificate | Sets the host name to be used in validating the SQL Server Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL), certificate. |
| setInstanceName | Sets the SQL Server instance name. |
| setIntegratedSecurity | Sets a Boolean value indicating whether the integratedSecurity property is enabled. |
| setLastUpdateCount | Sets a Boolean value indicating whether the lastUpdateCount property is enabled. |
| setLockTimeout | Sets an int value indicating the number of milliseconds to wait before the database reports a lock time out. |
| setLoginTimeout | Sets the number of seconds that this SQLServerDataSource object waits while trying to make a connection. |
| setLogWriter | Sets a character output stream to be used for all logging and tracing messages. |
| setMultiSubnetFailover | Sets the value of the multiSubnetFailover connection property. |
| setPacketSize | Sets the current network packet size used to communicate with SQL Server, specified in bytes. |
| setPassword | Sets the password used to connect to SQL Server. |
| setPortNumber | Sets the port number used to communicate with SQL Server. |
| setResponseBuffering | Sets the response buffering mode for connections created by using this SQLServerDataSource object. |
| setSelectMethod | Sets the default cursor type used for all result sets created by using this SQLServerDataSource object. |
| setSendStringParametersAsUnicode | Sets a Boolean value indicating whether sending string parameters to the server in UNICODE format is enabled. |
| setSendTimeAsDatetime | Specifies how to send java.sql.Time values to the server. |
| setServerName | Sets the name of the computer running SQL Server. |
| setServerPreparedStatementDiscardThreshold | Sets the new value of the serverPreparedStatementDiscardThreshold connection property. |
| setStatementPoolingCacheSize | Sets the size of the prepared statement cache for this connection. |
| setTrustManagerClass | Sets the string value of the TrustManagerClass connection property. |
| setTrustManagerConstructorArg | Sets the string value of the TrustManagerConstructorArg connection property. |
| setTrustServerCertificate | Sets a Boolean value indicating whether the trustServerCertificate property is enabled. |
| setTrustStore | Sets the path (including file name) to the certificate trustStore file. |
| setTrustStorePassword | Sets the password that is used to check the integrity of the trustStore data. |
| setURL | Sets the URL used to connect to the data source. |
| setUser | Sets the user name used to connect the data source. |
| setWorkstationID | Sets the name of the client computer used to connect to the data source. |
| setXopenStates | Sets a Boolean value indicating whether converting SQL states to XOPEN compliant states is enabled. |
| unwrap | Returns an object that implements the specified interface to allow access to the Microsoft JDBC Driver for SQL Server-specific methods. |
Inherited Methods
| Class inherited from: | Methods |
|---|---|
| java.lang.Object | clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait |
| java.sql.Wrapper | isWrapperFor, unwrap |