1 Reply Latest reply on Jan 18, 2005 4:49 PM by daorriss

    Database pool only showing half the minimum connections allo

    daorriss

      Perhaps I'm misunderstanding something here, but I have the following configured for my oracle connection pool - 20 for a minimum pool size and 100 for a max pool size. However the DBA is only seeing 10 connections being made from JBoss. What's going on here??. (code included - trimmed for brevity). TIA!



      <?xml version="1.0" encoding="UTF-8"?>
      
      
      <datasources>
       <local-tx-datasource>
       <jndi-name>jdbc/OracleDS</jndi-name>
      
       <connection-url>jdbc:oracle:oci:@osmv2dev</connection-url>
      
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>xxxx</user-name>
       <password>xxxx</password>
       <prepared-statement-cache-size>100</prepared-statement-cache-size>
       <min-pool-size>20</min-pool-size>
       <max-pool-size>100</max-pool-size>
       <blocking-timeout-millis>10000</blocking-timeout-millis>
       <idle-timeout-minutes>15</idle-timeout-minutes>
       <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
      
       </local-tx-datasource>
      
      </datasources>
      


        • 1. Re: Database pool only showing half the minimum connections
          daorriss

          OK after finding the section in the Administrators guide on this. I find that connections aren't created by default until they're needed. OK.. but what if I want to initially create that pool of 20? Is there any way to configure this?


          This element specifies the minimum number of connections a pool should hold. These pool instances are not created until an initial request for a connection is made.