Note: Always Encrypted is available with SQL Server 2016 or later and Azure SQL Database.
#Timing synonym driver
When AE is enabled, the JDBC driver transparently encrypts and decrypts sensitive data stored in encrypted database columns on the server.įor more information about Always Encrypted, see Using Always Encrypted with the JDBC driver. (Version 6.0+) Set to "Enabled" to use the Always Encrypted (AE) feature.
#Timing synonym password
(Version 8.4+) Specifies the optional password string for accessing the clientKey file's private key. (Version 8.4+) Specifies the location of the private key for PEM, DER, and CER certificates specified by the clientCertificate attribute. The JDBC driver supports PFX, PEM, DER, and CER file extensions.įor details, see Client Certificate Authentication for Loopback Scenarios. (Version 8.4+) Specifies the location of the certificate to be used for client certificate authentication. The default value for this property is -1 and behavior is to wait indefinitely. The driver waits the total amount of cancelQueryTimeout + queryTimeout seconds, to drop the connection and close the channel. This property is only applicable if 'queryTimeout' is also set on the connection. Query execution hangs and doesn't throw an exception if the TCP connection to the server is silently dropped. (Version 6.4+) This property can be used to cancel a queryTimeout set on the connection. Otherwise, an error occurs (connection properties must be specified).
#Timing synonym windows
When using authenticationScheme=NTLM, you must specify the Windows domain by using the domain or domainName property, the Windows credentials in the user or userName property, and the password property. Otherwise, an error occurs (Server not found in Kerberos database).įor more information about using authenticationScheme=JavaKerberos, see Using Kerberos integrated authentication to connect to SQL Server. When using authenticationScheme=JavaKerberos, you must specify the fully qualified domain name (FQDN) in the serverName or serverSpn property. (The native authentication library loaded is named sqljdbc_auth.dll when using driver versions 6.0 through 7.4.)
NativeAuthentication causes the driver to load mssql-jdbc_auth-.dll (for example, mssql-jdbc_auth-8.2.2.圆4.dll) on Windows, which is used to obtain integrated authentication information. Possible values are JavaKerberos, NTLM (version 7.4+), and the default NativeAuthentication.
Indicates which kind of integrated security you want your application to use.
#Timing synonym how to
Note: When the authentication property is set to any value other than NotSpecified, the driver by default uses Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL), encryption.įor information on how to configure Azure Active Directory authentication, see Connecting to SQL Database By Using Azure Active Directory Authentication. Microsoft Authentication Library can be installed from Microsoft ODBC Driver for SQL Server or Microsoft OLE DB Driver for SQL Server. [-.dll (available in the JDBC driver package) and Microsoft Authentication Library for SQL Server ( ADAL.DLL). Possible values are ReadOnly and ReadWrite.įor more information about disaster recovery, see JDBC driver support for High Availability, disaster recovery. (Version 6.0+) Declares the application workload type to connect to a server. (Version 12.4+) The name of the callback-implementing class to be used with access token callback. accessToken can't be set using the connection URL. (Version 6.0+) Use this property to connect to a database using an access token. The following table lists all the currently available connection string properties for the JDBC driver. Synonyms are allowed and are resolved in order, just as duplicate property names.
Unknown values are allowed for the property names, and the JDBC driver doesn't validate for case sensitivity.
0 kommentar(er)
