Muokkaa

Jaa


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