请帮我看看我配的连接池 经常掉连接 数据库是mysql

Question

#???????
DBType=mysql
#???????
DBUserName=myweb
#?????????
DBPassword=777777
#????????????????????????????????????
InUsePercentage=0.5
#??????????????implementation,proxy?
PoolImpl=implementationmysql.driver=com.mysql.jdbc.Driver
#JDBC URL
mysql.url=jdbc:mysql://210.83.81.68:3306/wap?useUnicode=true&characterEncoding=GB2312
#SQL Command????????10001?10002?????????????SQL Command????????
mysql.sqlCacheMode=10002
#???????
mysql.poolinit=4
#????????
mysql.poolmax=60
#????????
mysql.poolmin=4
#??????????
mysql.poolincr=1

Answer 1

这个要看你的java里怎么写的，看配置文件什么也看不出来。

Answer 2

<GlobalNamingResources>
    <Environment
      name="simpleValue"
      type="java.lang.Integer"
      value="30"/>
    <Resource
      auth="Container"
      description="User database that can be updated and saved"
      name="UserDatabase"
      type="org.apache.catalina.UserDatabase"
      pathname="conf/tomcat-users.xml"
      factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
    <Resource
      name="Test"
      type="javax.sql.DataSource"
      password="root"
      driverClassName="com.mysql.jdbc.Driver"
      maxIdle="2"
      maxWait="5000"
      username="root"
      url="jdbc:mysql://localhost:3306/jspdev"
      maxActive="4"/>
    <Resource
      name="jdbc/jspdev"
      type="javax.sql.DataSource"
      password="bn"
      driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
      maxIdle="2"
      maxWait="5000"
      username="bn"
      url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev"
      maxActive="4"/>
  </GlobalNamingResources>

Answer 3

连接池Mysql会自动维护，你用完了记得释放连接应该问题不大。