alibaba / druid

阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品,为监控而生的数据库连接池
https://github.com/alibaba/druid/wiki
Apache License 2.0
27.76k stars 8.55k forks source link

请各位帮忙看看问题,druid连接sqlserver2019,monitor页面无监控数据 #5975

Open SourceRep opened 3 weeks ago

SourceRep commented 3 weeks ago

各位好, 我试了druid和spring boot以及java的各种版本,怎么都用不了druid,确定下来的版本总算能进了druid页面,可是页面里没有监控数据,查找了论坛里的问题也找不到解决办法,请使用成功的各位不吝赐教,在此先谢谢各位了。 具体配置信息如下: dbtype: sqlserver dbversion: 2019 duird version: 1.2.20 spring-boot-starter-parent version: 2.7.18 java version: 21 mssql-jdbc version: 9.2.1.jre8

application.properties配置内容:

Server port

server.port=8082

SQL Server DataSource configuration

spring.datasource.url=jdbc:sqlserver://xxxx:1433;databaseName=xxxx; spring.datasource.username=xxx spring.datasource.password=xxxx spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver

Druid specific configuration

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.druid.initialSize=5 spring.datasource.druid.minIdle=5 spring.datasource.druid.maxActive=20 spring.datasource.druid.maxWait=60000 spring.datasource.druid.timeBetweenEvictionRunsMillis=60000 spring.datasource.druid.minEvictableIdleTimeMillis=300000 spring.datasource.druid.validation-query=SELECT 1 spring.datasource.druid.testWhileIdle=true spring.datasource.druid.testOnBorrow=false spring.datasource.druid.testOnReturn=false spring.datasource.druid.poolPreparedStatements=true spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20 spring.datasource.druid.filters=stat,wall,slf4j spring.datasource.druid.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

spring.datasource.druid.useGlobalDataSourceStat=true

Druid monitor configuration

spring.datasource.druid.stat-view-servlet.enabled=true spring.datasource.druid.stat-view-servlet.url-pattern=/druid/* spring.datasource.druid.stat-view-servlet.login-username=admin spring.datasource.druid.stat-view-servlet.login-password=admin

spring.datasource.druid.web-stat-filter.enabled=true spring.datasource.druid.web-stat-filter.url-pattern=/ spring.datasource.druid.web-stat-filter.exclusions=.js,.gif,.jpg,.png,.css,.ico,/druid/