DO NOT REPLY [Bug 29220] New: - Connection pool exhausted

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29220>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29220

Connection pool exhausted

           Summary: Connection pool exhausted
           Product: Tomcat 4
           Version: 4.1.24
          Platform: Other
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: Connector:Other
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


My server.xml is given below

<ResourceParams name="jdbc/bbksms">                             
        <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:@192.9.200.4:1521:orcl</value>
        </parameter>
        <parameter>
          <name>username</name>
          <value>notisappuser</value>
        </parameter>
        <parameter>
          <name>password</name>
          <value>nihmcbiegllgnafk</value>
        </parameter>
        <parameter>
          <name>maxActive</name>
          <value>30</value>
        </parameter>
        <parameter>
           <name>maxIdle</name>
           <value>3</value>
        </parameter>
        <parameter>
          <name>maxWait</name>
          <value>10000</value>
        </parameter>                                            
</ResourceParams>

There is a appropriate entry in web.xml too

<resource-ref>
                 <description>Oracle Datasource example</description>
                 <res-ref-name>jdbc/bbksms</res-ref-name>
                 <res-type>javax.sql.DataSource</res-type>
                 <res-auth>Container</res-auth>
        </resource-ref>

i am using oracle 9i as my database.
during login, i used to get 
org.apache.commons.dbcp.SQLNestedException: Cannot create 
PoolableConnectionFactory, cause: Io exception:
connection pool exhausted.

what may be the reason

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