Max Cursor Open
---------------
Key: DBCP-267
URL: https://issues.apache.org/jira/browse/DBCP-267
Project: Commons Dbcp
Issue Type: Bug
Affects Versions: 1.0
Environment: Struts 1.2.7, Oracle Application Server 10g, Database
Oracle 10g
Reporter: Kailas Kore
Fix For: 1.0
Hi,
We are facing error Max Cursor Open though we have closed Statement, Resultset
and Connection in java code after each procedure call.
We are using below datasource settings
<data-source key="RENPOSDB" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<set-property property="url" value="jdbc:oracle:thin:@l92.168.192.1:1521:ksdb2"
/>
<set-property property="username" value="NS" />
<set-property property="password" value="NS" />
<set-property property="description" value="Dev" />
<set-property property="autoCommit" value="true" />
<set-property property="maxCount" value="100" />
<set-property property="minCount" value="4" />
</data-source>
We are using finally block to close connection.
finally{
try{
commonMethods.closeConnection(rs,cstmt1,conn);
}catch (SQLException SQLe){}
}
We have used Implementation-Version: 1.0.1 of commons-dbcp.jar and
commons-pool.jar
Let us know if need to updatewith latest version
Thanks and Regards,
Kailas
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
