DBCP not opening multiple connections

["Campano, Troy" <Tr...@LibertyMutual.com>]

Hello, 
I am using Tomcat with DBCP.
I define my data source in server.xml like this:
 
 
 

          <ResourceParams name="jdbc/inventoryPool">
            <parameter>
              <name>password</name>
              <value>myPassword</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>myUser</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:oracle:thin:@myNode:1521: <mailto:jdbc:oracle:thin:@cedar.lmig.com:1521:> myInstance</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>oracle.jdbc.driver.OracleDriver</value>
            </parameter>
  <parameter>
      <name>maxActive</name>
      <value>500</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>30</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
  </ResourceParams>
 
 
I open a browser on multiple machines and go to this web app, but when I look at the database, I only see one inactive connection.
I expected to see one for every client user at the webapp.
 
What am I doing wrong?
 
 
thank you!
 
~ t r o y ~
 

Re: DBCP not opening multiple connections

[Rodney Waldhoff <rw...@apache.org>]

Since DBCP pools connections, you should expect to see roughly no more
connections created than are used in parallel, yes?