记一次dbcp与sqlserver数据库

Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

错误内容

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.microsoft.jdbc.sqlserver.SQLServerDriver’

解决方法

sqlserver类路径错误
不是com.microsoft.jdbc.sqlserver.SQLServerDriver，而是com.microsoft.sqlserver.jdbc.SQLServerDriver
url值也有问题，原本错误jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=***
正确写法 jdbc:sqlserver://127.0.0.1:1433;DatabaseName=***

心得：以后类路径再也不手写了