guys

   i m using

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->

<!--                                                                       -->

<!--  JBoss Server Configuration                                           -->

<!--                                                                       -->

<!-- ===================================================================== -->

<!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->

<!-- ==================================================================== -->

<!--  Datasource config for MySQL using 2.0.11 driver                     -->

<!-- ==================================================================== -->

<datasources>

  <local-tx-datasource>

    <jndi-name>TDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/NTONLINE</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name></user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>500</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

</local-tx-datasource>

  <local-tx-datasource>

    <jndi-name>KBGDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/BS</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>r</user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

  <local-tx-datasource>

    <jndi-name>BETADS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/ttaxcal</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>r</user-name>

    <password></password>

  </local-tx-datasource>

  <local-tx-datasource>

    <jndi-name>DLFDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/asm</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name></user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>500</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

  <local-tx-datasource>

    <jndi-name>MANWERDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/CONS</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>g</user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

  <local-tx-datasource>

    <jndi-name>RMSIDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/report</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>r</user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

<local-tx-datasource>

    <jndi-name>DEMODS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/DEMO</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>b</user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

<local-tx-datasource>

    <jndi-name>SEDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/TONLINE</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>kgr</user-name>

    <password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

  <local-tx-datasource>

    <jndi-name>CONLINEDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/SONLINE</connection-url>

    <!--connection-url>jdbc:mysql://localhost:3306/iimsdb</connection-url-->

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>kr</user-name>

    <password>w</password>

<min-pool-size>10</min-pool-size>

<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>36000</blocking-timeout-millis>

  </local-tx-datasource>

</datasources>

this mysql.ds as we have multiple database withi multiple client

my problom is when no of access on my site increase it's throw a exeption of jdbc

which is unable to connect and saying too many connection

but in case of a few access it's work proper

it's a serious issue when trafic increase

how many no of connection can be use in jboss-3.2 ?

so plz provide me solution thanks.