- 论坛徽章:
- 0
|
我的系统为:
Redhat9
Apache2.0.48(jk-1.2.5)
Tomcat5.0.12
MySQL4.0.16
我用下面的方法设置MySQL的连接池:
<Resource name="jdbc/连接池名称" auth="Container" type="javax.sql.DataSource"/>;
<ResourceParams name="jdbc/连接池名称">;
<parameter>;
<name>;factory</name>;
<value>;org.apache.commons.dbcp.BasicDataSourceFactory</value>;
</parameter>;
<parameter>;
<name>;maxActive</name>;
<value>;1000</value>;
</parameter>;
<parameter>;
<name>;maxIdle</name>;
<value>;0</value>;
</parameter>;
<parameter>;
<name>;maxWait</name>;
<value>;10000</value>;
</parameter>;
<parameter>;
<name>;username</name>;
<value>;数据库用户名</value>;
</parameter>;
<parameter>;
<name>;password</name>;
<value>;数据库口令</value>;
</parameter>;
<parameter>;
<name>;driverClassName</name>;
<value>;org.gjt.mm.mysql.Driver</value>;
</parameter>;
<parameter>;
<name>;url</name>;
<value>;jdbc:mysql://localhost:3306/数据库名称?useUnicode=true&characterEncoding=gb2312&autoReconnect=true</value>;
</parameter>;
</ResourceParams>;
原来设置的“maxIdle”为300,但过些时候总出现数据库错误,查看Tomcat日志有这样的记录:
namingBCP could not obtain an idle db connection, pool exhausted
我尝试将“maxIdle”改为0,但问题依旧。
那么我到底错在哪里?该怎么解决呢?请各位指点! |
|