Microsoft JDBC Driver for SQL Server
DataSource
Transaction Type | DataSource Class |
NO_TRANSACTION, LOCAL_TRANSACTION | com.microsoft.sqlserver.jdbc.SQLServerDataSource |
XA_TRANSACTION | com.microsoft.sqlserver.jdbc.SQLServerXADataSource |
SSL Settings
Specify the SSL parameters in the Other Properties field in the following format:
encrypt=value;
trustStore=Truststore path;
trustStorePassword=Truststore password
encrypt value is
true or
false depending on the encryption settings in the Microsoft SQL server.
trustStore value is the path of the trusted certificate store.
trustStorePassword value is the password used to protect the TrustStore data.
Note:
If you have configured SSL connections between Adapter for JDBC and Microsoft SQL Server, enter the TCPS port number of the Microsoft SQL Server.
Kerberos Authentication
Specify the Kerberos authentication parameters in the Other Properties field in the following format:
integratedSecurity=true;
authenticationScheme=NativeAuthentication
![*](chapterTOC_bullet.png)
NativeAuthentication is specific to the Windows platform and uses the following files:
![*](chapterTOC_bullet.png)
The library
sqljdbc_auth.dll for Microsoft JDBC driver version 7 or earlier.
![*](chapterTOC_bullet.png)
The library
mssql-jdbc_auth-x.x.x.xxx.dll for Microsoft JDBC driver version 8 or later.
![*](chapterTOC_bullet.png)
For Windows 32 or Windows 64, copy the appropriate library (
sqljdbc_auth.dll or
mssql-jdbc_auth-x.x.x.xxx.dll) to
Integration Server_directory\instances\instance_name\lib directory.
Authentication
The user name and password you configure for a connection must be the same as those used to create the tables you use with a specific notification. Otherwise, an exception is generated at runtime.
Other Properties
Specify the parameters in the Other Properties field:
Parameter | Description |
selectMethod | For XA_TRANSACTION only: selectMethod=cursor |
Required Connection Property Fields
Driver Name | Server Name | User | Password | Database Name | Port Number | Network Protocol |
Microsoft JDBC Driver Version 2.2.0019 for Microsoft SQL Server 2000 | Yes | Yes | Yes | No | Yes | No |
Microsoft JDBC Driver Version 1.0.809.102 for Microsoft SQL Server 2005 | Yes | Yes | Yes | No | Yes | No |
For more information about limitations, see
Limitations.