1 Reply Latest reply on Mar 22, 2006 11:23 AM by chahua wang

    Throwable while attempting to get a new connection: null

    chahua wang Newbie

      Hi folks,


      I have 30 threads running, then they update the the databse almost same time in Jboss 4.0.2, I got this exception

      2006-03-15 11:34:51,341 74020 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-8080-Processor100:) Throwable while
      
       attempting to get a new connection: null
      
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Network error IOException: Connect
      
      ion refused: connect)
      
       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)



      I have found only 26 update, the rest 4 didn't.

      Although I incresed max pool size, it doesn't take effect.
      I also read the links

      http://wiki.jboss.org/wiki/Wiki.jsp?page=IGetWARNConnectionErrorOccured

      http://wiki.jboss.org/wiki/Wiki.jsp?page=SQLExceptionIONetwork


      I wonder if this is a bug in 4.0.2

      Thank you,

      chwang

        • 1. Re: Throwable while attempting to get a new connection: null
          chahua wang Newbie

          I use MS SqL and the jdbc driver is jtds1.2.
          When I decreased to 20 threads running is fine.
          the following is my -ds.xml file. I wonder if I also need to set rar. Thank you,

          <datasources>
           <no-tx-datasource>
           <jndi-name>MY_DS</jndi-name>
           <connection-url>jdbc:jtds:sqlserver://localhost/myds</connection-url>
           <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
           <user-name>sa</user-name>
           <password>sa</password>
          
          
           <min-pool-size>5</min-pool-size>
          
           <max-pool-size>75</max-pool-size>
          
           <idle-timeout-minutes>15</idle-timeout-minutes>
          
           <check-valid-connection-sql>SELECT * FROM Group</check-valid-connection-sql>
          
           </no-tx-datasource>
          
          </datasources>