When creating a new Data Service in WSO2 to connect with Microsft SQL Server, if you don’t import the Microsoft SQL driver jar to WSO2 you’ll get the following error when testing the connection:

Driver class com.microsoft.jdbc.sqlserver.SQLServerDriver can not be loaded

or the following when trying to execute a dblookup:

DBLookupMediator SQL Exception occurred while executing statement : ….  against DataSource : SVC_INTEGRATIONS_BO
java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver cannot be found by jdbc-pool_7.0.34.wso2v2

To resolve this is just a matter of downloading the Microsoft SQL driver jar (sqljdbc4-2.0.jar), place it in folder \repository\components\lib of your WSO2 instalation and restart your WSO2.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>