<!-- https://mvnrepository.com/artifact/net.sourceforge.jtds/jtds -->
<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.3.1</version>
</dependency>
使用jtds驱动,数据库配置需要做出如下更改:
sqlserver:
datasource:
url: jdbc:jtds:sqlserver://{ip}:{port};DatabaseName={}
driverClassName: net.sourceforge.jtds.jdbc.Driver
多个数据源
datasource:
master:
url: jdbc:sqlserver://*****:1525;DatabaseName=AutoTEST
username: *****
password: *****
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
# 多数据源配置
multi-datasource1:
url: jdbc:jtds:sqlserver://*****;DatabaseName=*****
username: *****
password: *****$
driver-class-name: net.sourceforge.jtds.jdbc.Driver