Re: DBCP Connection pooling problem (V 1.2.1)

[Dirk Verbeeck]

Hi,

You should set maxActive & maxIdle to some reasonable values.
Then monitor pool usage to see if there is still a problem.

-- Dirk

Hari Haran wrote:

Hi,

I have configured DBCP for Oracle 9iAS (OC4j standalone) we have noticed that, at times the Application performance is hit badly.

It appears to me that performance is hit when the number of users and
connections increases.

Do I need to modify the configuration mentioned below to improve the
performance.

Here is the configuration.

<data-source
                name = "BasicDataSource"
                class = "org.apache.commons.dbcp.BasicDataSource"
                connection-driver = "oracle.jdbc.driver.OracleDriver"
                url = "jdbc:oracle:thin:@<host>:1521:<sid>"
                connection-retry-interval = "1"
                location = "jdbc/OracleDS"
                username="<uid>"
                password="<pwd>"
        >

        <property name="username" value="<uid>" />
        <property name="password" value="<pwd>" />
        <property name="url" value="jdbc:oracle:thin:@<host>:1521:<sid>" />
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="defaultAutoCommit" value="true" />
        <property name="initialSize" value="0" />
        <property name="maxActive" value="0" />       
        <property name="maxIdle" value="0" />
        <property name="minIdle" value="0" />
        <property name="maxWait" value="60" />
        <property name="validationQuery" value="Select max(1) from dual" />
        <property name="testOnBorrow" value="true" />
        <property name="testOnReturn" value="false" />
        <property name="testWhileIdle" value="false" />
        <property name="timeBetweenEvictionRunsMillis" value="60000" />
        <property name="numTestsPerEvictionRun" value="5" />
        <property name="minEvictableIdleTimeMillis" value="600000" />
        <property name="poolPreparedStatements" value="false" />
        <property name="maxOpenPreparedStatements" value="100" />
        <property name="accessToUnderlyingConnectionAllowed" value="false" />
        <property name="removeAbandoned" value="true" />
        <property name="removeAbandonedTimeout" value="60" />
        <property name="logAbandoned" value="true" />
</data-source>

-Hari Haran

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]