APP网站建设开发企业发展,网站建设与管理培训活动总结,网站图片搜索技术哪里可以做,视频wordpress现象#xff1a; 接口请求#xff0c;10秒钟超时#xff0c;看了一下#xff0c;是sql查询耗时太长了#xff0c;数据还没来得及返回#xff0c;连接就断开了。 连接断开#xff0c;上层应用直接报错。。
这些问题#xff0c;都是。。。知道答案后#xff0c;就觉得 接口请求10秒钟超时看了一下是sql查询耗时太长了数据还没来得及返回连接就断开了。 连接断开上层应用直接报错。。
这些问题都是。。。知道答案后就觉得emmm好简单。知道答案前…tmd, 这啥玩意儿。。。。
直接说答案吧 数据库连接超时那就配置超时时长准确地说是 druid 的超时时长。。。 要设置 druid 的 connectTimeout 、socketTimeout 这两个配置项 嗯。单这样说有点。。。
一份druid 配置
druid:url: jdbc:mysql://10.12.1.9:3306/student?useUnicodetruecharacterEncodingUTF-8allowMultiQueriestrueusername: usernamepassword: passwordxxxxuseSSL: falseinitial-size: 50min-idle: 50max-active: 200connectTimeout: 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 {Autowiredprivate DruidProperties properties;/*** 获取数据源* return DataSource*/Beanpublic 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*/Beanpublic 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版本需要单独配置才生效
