Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | Microsoft SQL | Microsoft JDBC Driver for SQL Server
 
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
*NativeAuthentication is specific to the Windows platform and uses the following files:
*The library sqljdbc_auth.dll for Microsoft JDBC driver version 7 or earlier.
*The library mssql-jdbc_auth-x.x.x.xxx.dll for Microsoft JDBC driver version 8 or later.
*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.