Apache DBCP not creating min connection
Hi,
I configured my app with Apache DBCP.. But when i checked initially it fail to create minimum connection.. am i miss anything here...
here is my configuration file.
<ResourceParams name="jdbc/oracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@some url</value>
</parameter>
<parameter>
<name>username</name>
<value>bloh bloh</value>
</parameter>
<parameter>
<name>password</name>
<value>bloh bloh</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>minIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
and i checked the connection using following query
select username,
machine,
count(*)
fromv$session
where machine like '%HC-APACHE%'
group by username,machine
Regards,
Ananth.P
