tomcat 数据库稳定链接配置

<Resource
name="jdbc/HAOMA"
auth="Container"
type="javax.sql.DataSource"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost:1433/HAOMA/charset=gbk;tds=8.0;lastupdatecount=true;autoReconnect=true"
username="sa"
password="123"
maxIdle="10"
maxWait="1000"
maxActive="500"
validationQuery="select top 1 * from t_test"
testOnBorrow="true"
testOnReturn="true"
testWhileIdle="true"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
/>

李小家
原文地址:https://www.cnblogs.com/101key/p/3123462.html