求一个关于数据源关闭仍然去取已失效连接的解决方案，在线等

wyer_ly 2017-04-01 02:40:09

上异常



Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure



The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

	at sun.reflect.GeneratedConstructorAccessor55.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)

	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:358)

	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2489)

	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2334)

	... 13 more

Caused by: java.net.ConnectException: Connection timed out: connect

	at java.net.DualStackPlainSocketImpl.connect0(Native Method)

	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)

	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)

	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)

	at java.net.Socket.connect(Socket.java:579)

	at java.net.Socket.connect(Socket.java:528)

	at java.net.Socket.<init>(Socket.java:425)

	at java.net.Socket.<init>(Socket.java:241)

	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)

	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:308)

	... 15 more

楼主数据源用的阿里的Druid
上数据源配置文件



	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"

		init-method="init" destroy-method="close">

		<property name="url" value="${datasource.url}" />

		<property name="username" value="${datasource.name}" />

		<property name="password" value="${datasource.password}" />

		<property name="connectionProperties" value="config.decrypt=false" />

<!-- 		<property name="filters" value="config,log4j" />

		<property name="maxActive" value="${datasource.maxActive}" />

		<property name="initialSize" value="${datasource.initialiSize}" />

		<property name="maxWait" value="60000" />

		<property name="minIdle" value="8" />

		<property name="timeBetweenEvictionRunsMillis" value="10000" />

		<property name="minEvictableIdleTimeMillis" value="300000" />

		<property name="validationQuery" value="SELECT 'x' from dual " />

		<property name="testWhileIdle" value="true" />

		<property name="testOnBorrow" value="true" />

		<property name="testOnReturn" value="false" />

		<property name="poolPreparedStatements" value="true" />

		<property name="maxPoolPreparedStatementPerConnectionSize"

			value="20" />

		<property name="timeBetweenLogStatsMillis" value="${time.between.logstats.millis}" />

		<property name="statLogger" ref="druidStatLoggerProxy" /> -->

	</bean>