SQLServerDataSource Members

Download JDBC driver

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

See Also

SQLServerDataSource Class