2 Replies Latest reply on Mar 25, 2006 12:00 PM by Scott Stark

    Throwable while attempting to get a new  connection: null

    chahua wang Newbie

      Hi folks,

      I let 30 threads running, then they update the the databse almost same time in Jboss 4.0.2, I use MS SqL and the jdbc driver is jtds1.2.
      I got a SQL exception...

      I increased max pool size=75, it doesn't take effect. actually there is only 60 transactions with database with 30 threads.

      And I did something according to these links


      still did not solve the issue.

      but if I decreased to 20 threads running, which is fine.
      I wonder if I need to set max pool size=0, which means no limit.
      or this is memory issue, others.

      the following is exception and -ds.xml file
      Thank you.


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


       <check-valid-connection-sql>SELECT * FROM Group</check-valid-connection-sql>