nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 该驱动程序不支持 SQL Server 8 版。 ClientConnectionId:963413c6-4a36-44fd-a152-fda692306ea9\r\n### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 该驱动程序不支持 SQL Server 8 版。 ClientConnectionId:963413c6-4a36-44fd-a152-fda692306ea9
服务器使用的SQLServer 2000版本,版本太古老
解决方案:
1.sqljdbc4将 4.0 降低到 3.0版本
<dependency>
<groupId>com.microsoft</groupId>
<artifactId>sqljdbc4</artifactId>
<version>3.0</version>
</dependency>
application.yml
spring:
datasource:
username: sa
password: 123
url: jdbc:sqlserver://127.0.0.1:1433;databaseName=数据库名
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
2.换 jtds 依赖(我是这个成功的)
<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.3.1</version>
</dependency>
application.yml文件
spring:
datasource:
url: jdbc:jtds:sqlserver://localhost:1433/你的数据库名
username: sa
password: 123
driver-class-name: net.sourceforge.jtds.jdbc.Driver
hikari:
connection-test-query: SELECT 1