[jboss-user] [JBoss Web Services] - jboss hanging issue

[sanjeev Gupta]

sanjeev Gupta [https://community.jboss.org/people/sanjeevgupta] created the discussion

"jboss hanging issue"

To view the discussion, visit: https://community.jboss.org/message/810679#810679

--------------------------------------------------------------
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...
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/810679#810679]

Start a new discussion in JBoss Web Services at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2044]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130428/347343b9/attachment-0001.html