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

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

      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.

      chwang

      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.sq
      l.SQLException: Network error IOException: Connect
      
      ion refused: connect)
      
       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnecti
      on(LocalManagedConnectionFactory.java:161



      -------------------------
      -ds.xml


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