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>kbgr</user-name>
<password>wSsxRz6Z</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
so plz provide me solution thanks...