Tomcat中DBCP2连接池配置如下:
<Resource auth="Container"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
name="jdbc/jndiname"
password="123456"
type="javax.sql.DataSource"
url="jdbc:sqlserver://servername:port;DatabaseName=dbname"
username="admin"
factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"
minIdle="10"
maxIdle="50"
initialSize="30"
maxTotal="100"
maxWaitMillis ="10000"
logAbandoned