public interface ISQLServerDataSource extends CommonDataSource
Modifier and Type | Method and Description |
---|---|
String |
getApplicationIntent()
Returns the application intent.
|
String |
getApplicationName()
Returns the application name.
|
String |
getDatabaseName()
Returns the database name.
|
String |
getDescription()
Returns a description of the data source.
|
boolean |
getEncrypt()
Returns a Boolean value that indicates if the encrypt property is enabled.
|
String |
getFailoverPartner()
Returns the name of the failover server that is used in a database mirroring configuration.
|
String |
getHostNameInCertificate()
Returns the host name used in validating the SQL Server Secure Sockets Layer (SSL) certificate.
|
String |
getInstanceName()
Returns the SQL Server instance name.
|
boolean |
getLastUpdateCount()
Returns a Boolean value that indicates if the lastUpdateCount property is enabled.
|
int |
getLockTimeout()
Returns an int value that indicates the number of milliseconds that the database will wait before reporting a lock time out.
|
boolean |
getMultiSubnetFailover()
Returns the value of the multiSubnetFailover connection property.
|
int |
getPacketSize()
Returns the current network packet size used to communicate with SQL Server, specified in bytes.
|
int |
getPortNumber()
Returns the current port number that is used to communicate with SQL Server.
|
String |
getResponseBuffering()
Returns the response buffering mode for this SQLServerDataSource object.
|
String |
getSelectMethod()
Returns the default cursor type used for all result sets that are created by using this SQLServerDataSource object.
|
boolean |
getSendStringParametersAsUnicode()
Returns a boolean value that indicates if sending string parameters to the server in UNICODE format is enabled.
|
boolean |
getSendTimeAsDatetime()
This method was added in SQL Server JDBC Driver 3.0.
|
String |
getServerName()
Returns the name of the SQL Server instance.
|
String |
getServerSpn()
Returns the server spn
|
boolean |
getTrustServerCertificate()
Returns a Boolean value that indicates if the trustServerCertificate property is enabled.
|
String |
getTrustStore()
Returns the path (including file name) to the certificate trustStore file.
|
String |
getURL()
Returns the URL that is used to connect to the data source.
|
String |
getUser()
Returns the user name that is used to connect the data source.
|
String |
getWorkstationID()
Returns the name of the client computer name that is used to connect to the data source.
|
boolean |
getXopenStates()
Returns a boolean value that indicates if converting SQL states to XOPEN compliant states is enabled.
|
void |
setApplicationIntent(String applicationIntent)
Sets the application intent.
|
void |
setApplicationName(String applicationName)
Sets the application name.
|
void |
setAuthenticationScheme(String authenticationScheme)
Indicates the kind of integrated security you want your application to use.
|
void |
setDatabaseName(String databaseName)
Sets the database name to connect to.
|
void |
setDescription(String description)
Sets the description of the data source.
|
void |
setEncrypt(boolean encrypt)
Sets a Boolean value that indicates if the encrypt property is enabled.
|
void |
setFailoverPartner(String serverName)
Sets the name of the failover server that is used in a database mirroring configuration.
|
void |
setHostNameInCertificate(String host)
Sets the host name to be used in validating the SQL Server Secure Sockets Layer (SSL) certificate.
|
void |
setInstanceName(String instanceName)
Sets the SQL Server instance name.
|
void |
setIntegratedSecurity(boolean enable)
Sets a Boolean value that indicates if the integratedSecurity property is enabled.
|
void |
setLastUpdateCount(boolean lastUpdateCount)
Sets a Boolean value that indicates if the lastUpdateCount property is enabled.
|
void |
setLockTimeout(int lockTimeout)
Sets an int value that indicates the number of milliseconds to wait before the database reports a lock time out.
|
void |
setMultiSubnetFailover(boolean multiSubnetFailover)
Sets the value of the multiSubnetFailover connection property.
|
void |
setPacketSize(int packetSize)
Sets the current network packet size used to communicate with SQL Server, specified in bytes.
|
void |
setPassword(String password)
Sets the password that will be used to connect to SQL Server.
|
void |
setPortNumber(int portNumber)
Sets the port number to be used to communicate with SQL Server.
|
void |
setResponseBuffering(String respo)
Sets the response buffering mode for connections created by using this SQLServerDataSource object.
|
void |
setSelectMethod(String selectMethod)
Sets the default cursor type that is used for all result sets that are created by using this SQLServerDataSource object.
|
void |
setSendStringParametersAsUnicode(boolean sendStringParametersAsUnicode)
Sets a boolean value that indicates if sending string parameters to the server in UNICODE format is enabled.
|
void |
setSendTimeAsDatetime(boolean sendTimeAsDatetime)
Modifies the setting of the sendTimeAsDatetime connection property.
|
void |
setServerName(String serverName)
Sets the name of the computer that is running SQL Server.
|
void |
setServerSpn(String serverSpn)
Sets the server spn
|
void |
setTrustServerCertificate(boolean e)
Sets a Boolean value that indicates if the trustServerCertificate property is enabled.
|
void |
setTrustStore(String st)
Sets the path (including file name) to the certificate trustStore file.
|
void |
setTrustStorePassword(String p)
Sets the password that is used to check the integrity of the trustStore data.
|
void |
setURL(String url)
Sets the URL that is used to connect to the data source.
|
void |
setUser(String user)
Sets the user name that is used to connect the data source.
|
void |
setWorkstationID(String workstationID)
Sets the name of the client computer name that is used to connect to the data source.
|
void |
setXopenStates(boolean xopenStates)
Sets a Boolean value that indicates if converting SQL states to XOPEN compliant states is enabled.
|
getLoginTimeout, getLogWriter, getParentLogger, setLoginTimeout, setLogWriter
void setApplicationIntent(String applicationIntent)
applicationIntent
- A String that contains the application intent.String getApplicationIntent()
void setApplicationName(String applicationName)
applicationName
- A String that contains the name of the application.String getApplicationName()
void setDatabaseName(String databaseName)
databaseName
- A String that contains the database name.String getDatabaseName()
void setInstanceName(String instanceName)
instanceName
- A String that contains the instance name.String getInstanceName()
void setIntegratedSecurity(boolean enable)
enable
- true if integratedSecurity is enabled. Otherwise, false.void setLastUpdateCount(boolean lastUpdateCount)
lastUpdateCount
- true if lastUpdateCount is enabled. Otherwise, false.boolean getLastUpdateCount()
void setEncrypt(boolean encrypt)
encrypt
- true if the Secure Sockets Layer (SSL) encryption is enabled between the client and the SQL Server. Otherwise, false.boolean getEncrypt()
void setTrustServerCertificate(boolean e)
e
- true if the server Secure Sockets Layer (SSL) certificate should be automatically trusted when the communication layer is encrypted
using SSL. Otherwise, false.boolean getTrustServerCertificate()
void setTrustStore(String st)
st
- A String that contains the path (including file name) to the certificate trustStore file.String getTrustStore()
void setTrustStorePassword(String p)
p
- A String that contains the password that is used to check the integrity of the trustStore data.void setHostNameInCertificate(String host)
host
- A String that contains the host name.String getHostNameInCertificate()
void setLockTimeout(int lockTimeout)
lockTimeout
- An int value that contains the number of milliseconds to wait.int getLockTimeout()
void setPassword(String password)
password
- A String that contains the password.void setPortNumber(int portNumber)
portNumber
- An int value that contains the port number.int getPortNumber()
void setSelectMethod(String selectMethod)
selectMethod
- A String value that contains the default cursor type.String getSelectMethod()
void setResponseBuffering(String respo)
respo
- A String that contains the buffering and streaming mode. The valid mode can be one of the following case-insensitive Strings: full
or adaptive.String getResponseBuffering()
void setSendTimeAsDatetime(boolean sendTimeAsDatetime)
sendTimeAsDatetime
- A Boolean value. When true, causes java.sql.Time values to be sent to the server as SQL Server datetime types. When false, causes
java.sql.Time values to be sent to the server as SQL Server time types.boolean getSendTimeAsDatetime()
void setSendStringParametersAsUnicode(boolean sendStringParametersAsUnicode)
sendStringParametersAsUnicode
- true if string parameters are sent to the server in UNICODE format. Otherwise, false.boolean getSendStringParametersAsUnicode()
void setServerName(String serverName)
serverName
- A String that contains the server name.String getServerName()
void setFailoverPartner(String serverName)
serverName
- A String that contains the failover server name.String getFailoverPartner()
void setMultiSubnetFailover(boolean multiSubnetFailover)
multiSubnetFailover
- The new value of the multiSubnetFailover connection property.boolean getMultiSubnetFailover()
void setUser(String user)
user
- A String that contains the user name.String getUser()
void setWorkstationID(String workstationID)
workstationID
- A String that contains the client computer name.String getWorkstationID()
void setXopenStates(boolean xopenStates)
xopenStates
- true if converting SQL states to XOPEN compliant states is enabled. Otherwise, false.boolean getXopenStates()
void setURL(String url)
url
- A String that contains the URL.String getURL()
void setDescription(String description)
description
- A String that contains the description.String getDescription()
void setPacketSize(int packetSize)
packetSize
- An int value containing the network packet size.int getPacketSize()
void setAuthenticationScheme(String authenticationScheme)
authenticationScheme
- Values are "JavaKerberos" and the default "NativeAuthentication".void setServerSpn(String serverSpn)
serverSpn
- A String that contains the server spnString getServerSpn()
Copyright © 2017 Microsoft Corporation. All rights reserved.