記一次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=***

心得：以後類路徑再也不手寫了