Two Connection pools - Tomcat 4.1.29- Please help!!

[GuptaD]

Hi,

    I was wondering that is it possible at all to create 2 pools of
connections which are to be used by the same application. I tried to do
someyhing like this in server.xml but the second one doesn't work: - 
it's giving me following error for second one 

 --Cannot create PoolableConnectionFactory--

I will really appreciate if somebosy could post the code if you've done it
already...

-- the part of server.xml looks like this--------------

          <Resource name="jdbc/CrdbConn" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/CrdbConn">
 
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourc
eFactory</value></parameter>
                <parameter><name>maxActive</name>
                <value>20</value>
                </parameter>            
            
              <parameter>
                <name>maxIdle</name>
                <value>10</value>
              </parameter>
              <parameter>
                <name>maxWait</name>
                <value>-1</value>
              </parameter>

            <parameter><name>driverClassName</name>
              <value>oracle.jdbc.driver.OracleDriver</value></parameter>
            <parameter><name>url</name>
 
<value>jdbc:oracle:thin:@dpwdev02:1521:drpd</value></parameter>
 
<parameter><name>username</name><value>cweb</value></parameter>
 
<parameter><name>password</name><value>cweb</value></parameter>
          </ResourceParams>
          
          <!-- HDB connection -->
          
          <Resource name="jdbc/hdbConn" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/hdbConn">
 
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourc
eFactory</value></parameter>
                <parameter><name>maxActive</name>
                <value>10</value>
                </parameter>            
            
              <parameter>
                <name>maxIdle</name>
                <value>10</value>
              </parameter>
              <parameter>
                <name>maxWait</name>
                <value>-1</value>
              </parameter>

            <parameter><name>driverClassName</name>
              <value>oracle.jdbc.driver.OracleDriver</value></parameter>
            <parameter><name>url</name>
              <value>jdbc:oracle:thin:@wfmprd02:1521:HDB</value></parameter>
 
<parameter><name>username</name><value>admin</value></parameter>
 
<parameter><name>password</name><value>admin</value></parameter>
          </ResourceParams>
          
          <!-- end HDB -->
------  end of part of
server.xml------------------------------------------------------

my web.xml looks like this


-----------web.xml--------------------------
<?xml version="1.0"?>
<!DOCTYPE web-app    
        PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"  
        "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd";>
<web-app>   
        <context-param>     
                <param-name>appversion</param-name>      
                <param-value>Development</param-value>   
        </context-param>
        <context-param>
          <param-name>som</param-name>
          <param-value>Divya Gupta</param-value>
        </context-param>
        <context-param>
          <param-name>amphost</param-name>
          <param-value>sundev01</param-value>
        </context-param>
        <context-param>
          <param-name>ampsid</param-name>
          <param-value>am2d</param-value>
        </context-param>
        <context-param>
          <param-name>crdbhost</param-name>
          <param-value>dpwdev02</param-value>
        </context-param>
        <context-param>
          <param-name>crdbsid</param-name>
          <param-value>drpd</param-value>
        </context-param>
<resource-ref>
 <description>Oracle Datasource example</description>
 <res-ref-name>jdbc/CrdbConn</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

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


</web-app>
---end of web.xml---------------------------------

Thanks in advance,

Regards,

Divya