【Druid】数据库连接超时
创始人
2025-01-15 12:35:04
0

现象:
接口请求,10秒钟超时,看了一下,是sql查询耗时太长了,数据还没来得及返回,连接就断开了。
连接断开,上层应用直接报错。。

这些问题,都是。。。知道答案后,就觉得,emmm,好简单。知道答案前,…tmd, 这啥玩意儿。。。。

直接说答案吧:
数据库连接超时,那就配置超时时长,准确地说是 druid 的超时时长。。。
要设置 druid 的 connectTimeout 、socketTimeout 这两个配置项,
嗯。单这样说,有点。。。

一份druid 配置

druid:   url: jdbc:mysql://10.12.1.9:3306/student?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true   username: username   password: passwordxxxx   useSSL: false   initial-size: 50   min-idle: 50   max-active: 200   connectTimeout: 600000  #1.2.12版本需要单独配置才生效   socketTimeout: 600000   #1.2.12版本需要单独配置才生效 

有了配置,不够,需要在代码里面解析配置
于是要写一个:
DruidProperties.java

import org.springframework.boot.context.properties.ConfigurationProperties;  /** * druid */ @ConfigurationProperties(prefix = "druid") public class DruidProperties {    private String url;    private String username;    private String password;     private int initialSize;    private int minIdle;    private int maxActive;    private long maxWait;     private String validationQuery;     private int connectTimeout;     private int socketTimeout;     private boolean testOnBorrow;     public String getUrl() {        return url;    }     public void setUrl(String url) {        this.url = url;    }     public String getUsername() {        return username;    }     public void setUsername(String username) {        this.username = username;    }     public String getPassword() {        return password;    }     public void setPassword(String password) {        this.password = password;    }     public int getInitialSize() {        return initialSize;    }     public void setInitialSize(int initialSize) {        this.initialSize = initialSize;    }     public int getMinIdle() {        return minIdle;    }     public void setMinIdle(int minIdle) {        this.minIdle = minIdle;    }     public int getMaxActive() {        return maxActive;    }     public void setMaxActive(int maxActive) {        this.maxActive = maxActive;    }     public long getMaxWait() {        return maxWait;    }     public void setMaxWait(long maxWait) {        this.maxWait = maxWait;    }     public String getValidationQuery() {        return validationQuery;    }     public void setValidationQuery(String validationQuery) {        this.validationQuery = validationQuery;    }      public int getConnectTimeout() {        return connectTimeout;    }     public void setConnectTimeout(int connectTimeout) {        this.connectTimeout = connectTimeout;    }     public int getSocketTimeout() {        return socketTimeout;    }     public void setSocketTimeout(int socketTimeout) {        this.socketTimeout = socketTimeout;    }     public boolean isTestOnBorrow() {        return testOnBorrow;    }     public void setTestOnBorrow(boolean testOnBorrow) {        this.testOnBorrow = testOnBorrow;    } } 

还有 DruidAutoConfiguration.java

import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.http.StatViewServlet;   import javax.sql.DataSource; import java.sql.SQLException;   /**  * Created by chu on 2017/3/2.  */ @Configuration @EnableConfigurationProperties(DruidProperties.class) @ConditionalOnClass(DruidDataSource.class) @ConditionalOnProperty(prefix = "druid", name = "url") @AutoConfigureBefore(DataSourceAutoConfiguration.class) public class DruidAutoConfiguration {       @Autowired     private DruidProperties properties;     /**      * 获取数据源      * @return DataSource      */     @Bean     public DataSource dataSource() {         DruidDataSource dataSource = new DruidDataSource();         dataSource.setUrl(properties.getUrl());         dataSource.setUsername(properties.getUsername());         dataSource.setPassword(properties.getPassword());         if (properties.getInitialSize() > 0) {             dataSource.setInitialSize(properties.getInitialSize());         }         if (properties.getMaxActive() > 0) {             dataSource.setMaxActive(properties.getMaxActive());         }         if (properties.getMaxWait() > 0) {             dataSource.setMaxWait(properties.getMaxWait());         }         if (properties.getMinIdle() > 0) {             dataSource.setMinIdle(properties.getMinIdle());         }         if (properties.getValidationQuery() != null) {             dataSource.setValidationQuery(properties.getValidationQuery());         }         if (properties.getConnectTimeout() > 0) {             dataSource.setConnectTimeout(properties.getConnectTimeout());         }         if (properties.getSocketTimeout() > 0) {             dataSource.setSocketTimeout(properties.getSocketTimeout());         }         dataSource.setTestOnBorrow(properties.isTestOnBorrow());           try {             dataSource.init();         } catch (SQLException e) {             throw new RuntimeException(e);         }         return dataSource;     }       /**      * 获取ServletRegistrationBean      * @return ServletRegistrationBean      */     @Bean     public ServletRegistrationBean druidServlet() {         ServletRegistrationBean druidServletRegistration = new ServletRegistrationBean(new DruidStatViewServlet());         druidServletRegistration.addInitParameter("allow", "127.0.0.1");         druidServletRegistration.addUrlMappings("/druid/*");         return druidServletRegistration;     }   } 

一开始,配置文件写到了

spring:   datasource:     druid:       connectTimeout: 600000  #1.2.12版本需要单独配置才生效       socketTimeout: 600000   #1.2.12版本需要单独配置才生效 

然后配置死活不生效。。。

呃,,,, 所以配置文件,和解析类的前缀一定要匹配才行噢! 不熟悉的同学,其实很容易踩坑。。。。

我就踩了好多次。。。emmmm
踩坑记录:单独配置:socketTimeout: 600000不生效,需要两项同时配置:

      connectTimeout: 600000  #1.2.12版本需要单独配置才生效       socketTimeout: 600000   #1.2.12版本需要单独配置才生效 

相关内容

热门资讯

专业讨论!德扑之星真破解套路(... 专业讨论!德扑之星真破解套路(辅助挂)软件透明挂(有挂了解)-哔哩哔哩;人气非常高,ai更新快且高清...
每日必看!智星德州菠萝外挂检测... 每日必看!智星德州菠萝外挂检测(辅助挂)软件透明挂(有挂教学)-哔哩哔哩1、玩家可以在智星德州菠萝外...
透视透明挂!轰趴十三水有后台(... 轰趴十三水有后台赢率提升策略‌;透视透明挂!轰趴十三水有后台(辅助挂)软件透明挂(有挂详情)-哔哩哔...
发现玩家!德扑ai助手软件(辅... 发现玩家!德扑ai助手软件(辅助挂)透视辅助(有挂教学)-哔哩哔哩;玩家在德扑ai助手软件中需先进行...
一分钟了解!x-poker辅助... 一分钟了解!x-poker辅助软件(辅助挂)辅助透视(有挂攻略)-哔哩哔哩1、每一步都需要思考,不同...
一分钟揭秘!德州最新辅助器(辅... 一分钟揭秘!德州最新辅助器(辅助挂)透视辅助(有挂攻略)-哔哩哔哩;德州最新辅助器最新版本免费下载安...
玩家攻略推荐!德州辅助(辅助挂... 玩家攻略推荐!德州辅助(辅助挂)辅助透视(有挂了解)-哔哩哔哩是由北京得德州辅助黑科技有限公司精心研...
揭秘真相!pokernow德州... 《揭秘真相!pokernow德州(辅助挂)辅助透视(有挂介绍)-哔哩哔哩》 pokernow德州软件...
五分钟了解!德州之星辅助器(辅... 五分钟了解!德州之星辅助器(辅助挂)辅助透视(有挂透明)-哔哩哔哩1、很好的工具软件,可以解锁游戏的...
推荐一款!pokermaste... 1、推荐一款!pokermaster有外挂(辅助挂)透视辅助(有挂教学)-哔哩哔哩;详细教程。2、p...