sanjeev Gupta
2013-04-28 06:53:39 UTC
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]
"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]