[jira] Resolved: (DBCP-267) Max Cursor Open

["Phil Steitz (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DBCP-267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phil Steitz resolved DBCP-267.
------------------------------

    Resolution: Fixed

This is a question for the user list.  There is no 1.0.1 version of DBCP.  In any case, all versions of DBCP have used "maxActive" to control the number of connections allocated to the pool.  Assuming the parameters in the report are what are being used to initialize a BasicDataSource, changing "maxOpen" to "maxActive" might solve the problem  Please reopen if this really points to a bug in DBCP.  Otherwise, feel free to ask for help on the commons user list.

> 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.