com.microsoft.sqlserver.jdbc.sqlserverdriver not found error occurs when JDBC driver is missing on Controller application server.

As part of our Server administration services, Bobcares responds to all inquiries, large and small.

Let’s take a closer look at how our Support team assisted one of our customers identify and resolve this error.

How to solve com.microsoft.sqlserver.jdbc.sqlserverdriver not found error ?

JDBC stands for Java Database Connectivity, and it is a standard that allows Java programmes to connect to databases. A JDBC driver is required to access databases using JDBC. JDBC drivers are available as free downloads from database vendors.

When JDBC driver is Missing on Controller application repository database hosted by Microsoft SQL server, we will get the error: ** ERROR: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver not found.

Since Controller 10.1, all modern versions often use JAVA for the “Database Conversion” utility. As a result, it connects to the Controller application databases via JDBC connections, which necessitates the use of a JDBC driver.

Replicating the error

1. Firstly, start Controller Configuration.
2. Then, navigate to the “Database Connections” section.
3. Highlight our database.
4. Then, click the green “run” button.
5. The database Conversion Utility will now appear.
6. Finally, press the ‘connect’ button.

The error com.microsoft.sqlserver.jdbc.sqlserverdriver not found will now appear.

Resolving the error

Install the appropriate third-party JDBC driver (JAR file). The steps that follow are based on Microsoft SQL.

1. Download the recommended Microsoft SQL Server JDBC driver.
2. Then, copy the relevant JAR file in the same directory as DBCONV.EXE. This is the default: C:Program Filesibmcognosccr_64Data
3. Finally, test the connection by clicking the ‘connect’ button after the steps in “Replicating the error”.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To sum up, our Skilled engineers demonstrated how to identify and resolve the error: com.microsoft.sqlserver.jdbc.sqlserverdriver not found