如果没用第三方组件来配置数据源,程序会默认使用tomcat容器内建的DHCP连接池组建。
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
maxActive="150" maxIdle="5" maxWait="5000" name="jdbc/healthDocDB"
password="root" testOnBorrow="true" testOnReturn="true" testWhileIdle="true"
type="javax.sql.DataSource"
url="jdbc:mysql://127.0.0.1:3306/healthdocdb_new?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true"
username="root" validationQuery=" select 1 " />
tomcat 容器内建的DHCP连接池组,容易出现 Connection is closed。
12358104362 2015-06-15 16:18:35,206 ERROR [http-bio-8081-exec-198338] sd.logger - get doctor undeal abnormal data count err!
java.sql.SQLException: Connection is closed.
此种问题一般有两种情况导致: