Throwable while attempting to get a new connection: null

[chwang]

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

[chwang]

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>