Ticket #29214
Question
I copied an existing JDBC bean connection in the Datasource Configuration to set up a new SQL Server instance we'd like to use for our runtime applications. However after pointing the apps to use this new SQL server, I'm getting this message when I run any applications in the dictionary: Cannot load driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver I am not sure what the problem is.
Answer
Informed customer the name of the driver file specified in the bean is incorrect. His driver specified was "com.microsoft.jdbc.sqlserver.SQLServerDriver" however in the SQL Server 2005 JDBC driver (and later), Microsoft changed this to "com.microsoft.sqlserver.jdbc.SQLServerDriver" (note the switch of order between sqlserver and jdbc. Once he made sure his driver name matched the latter, saving the file and restarting Tomcat resolved the issue.
Asked on July 12, 2019