struts下连接oracle数据库异常，如何配置？

[qianshiyu]

java.sql.SQLException: DBCP could not obtain an idle db connection, pool exhausted

[GJA106]

如果连接池配置正确(如下述内容)，那应该是代码中使用过的Connection没有close掉(Result/Statement/...都应该close掉)。

...
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property
property="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<set-property
property="url"
value="jdbc:oracle:thin:@localhost:1521:orcl" />
<set-property
property="username"
value="system" />
<set-property
property="password"
value="manager" />
<set-property
property="maxActive"
value="100" />
<set-property
property="maxWait"
value="5000" />
<set-property
property="defaultAutoCommit"
value="true" />
<set-property
property="defaultReadOnly"
value="false" />
</data-source>
</data-sources>
...