druid版本:1.2.16
[com.al](https://github.com/alibaba/druid/issues/new#)ibaba druid-spring-boot-starter事由:上周由于国产数据库驱动需要,更新了druid版本为1.2.15,之后发现有较多报错,提示Read timed out,分析原因,可能为加入了socketTimeOut参数导致,但是在yml里配置后报错依旧,看最新的1.2.16已解决,所以下载重试,配置如下,sql只要运行超过10s,报错依旧,不知是否为配置错导致? yml: spring: datasource: druid: initial-size: 1 max-active: 8 min-idle: 2 testWhileIdle: true maxWait: 60000 keepAlive: true socket-timeout: 20000 connect-timeout: 30000
日志报错: [[[2023-03-08 14:24:35.444 | TID: N/A | | hh| (https://github.com/alibaba/druid/issues/new#) | INFO | 9004 - 2023-03-08 14:24:35.444 INFO 9540 --- [ XNIO-1 task-1] amic.datasource.DynamicRoutingDataSource 144 : dynamic-datasource - add a datasource named [aa1111] success]]] [[[2023-03-08 14:24:45.604 | TID: N/A | | hh| (https://github.com/alibaba/druid/issues/new#) | INFO | 9004 - 2023-03-08 14:24:45.604 INFO 9540 --- [ XNIO-1 task-1] hhnfig.GlobalExceptionHandler 30 : org.springframework.dao.DataAccessResourceFailureException: CallableStatementCallback; SQL [exec auto_proc1111]; Read timed out; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)