springboot集成sqlserver数据库

1.看版本2010以上用正常得jdbc好使   像老版2000得要用jtds驱动才好使

上代码

引入

<dependency>
   <groupId>net.sourceforge.jtds</groupId>
   <artifactId>jtds</artifactId>
   <version>1.2.4</version>
</dependency>

druid里配置sqlserver数据源
policesqlServer:
  url: jdbc:jtds:sqlserver://10.119.205.4:1433;DatabaseName=tcl
  dbname: tcl
  username: tcl_guest2
  password: Guest@2020
  auto-commit: false
  rollback-on-return: true
  driver-class-name: net.sourceforge.jtds.jdbc.Driver
  initialSize: 5
  minIdle: 5
  maxActive: 10

这里用得事jtds得驱动 net.sourceforge.jtds.jdbc.Driver