...
Download and copy one of the following drivers to the WSO2 product's <MB_HOME>/repository/components/lib/ directory.
- Download the Microsoft SQL JDBC driver file
jtds-1.3.1.jarand copy it to thelibdirectory. Or download the Microsoft JDBC Driver 6.0, 4.2, 4.1, or 4.0 and copy the JAR file that is compatible with your JRE version to the
libdirectory:.Note - If you are using JRE 7, install the
Sqljdbc41.jarfile. This supports the JDBC 4.1 API. - If you are using JRE 8, install the
Sqljdbc42.jarfile. This supports the JDBC 4.2. API.
- If you are using JRE 7, install the
Once this is done, the driver class relevant to the driver you use should be updated in the master-datasources.xml when you set up the datasource configurations. By default the master-datsources.xml file is configured with the driver class for the jtds-1.3.1.jar driver, which is net.sourceforge.jtds.jdbc.Driver. If you use the JDBC driver 6.0, 4.2, 4.1 or 4.0, you need to change driver class configuration to com.microsoft.sqlserver.jdbc.SQLServerDriver.
Setting up datasource configurations
...