6.6w+
社区成员
- 全部
struts下连接oracle数据库异常，如何配置？
java.sql.SQLException: DBCP could not obtain an idle db connection, pool exhausted
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
GJA106 2005-02-24
如果连接池配置正确(如下述内容)，那应该是代码中使用过的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>
...
...
<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>
...
