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>