0 Replies Latest reply on Apr 28, 2013 4:37 AM by sanjeevgupta

    Mysql datasource connection pooling in jboss-3.2

    sanjeevgupta

      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.