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> View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3931946#3931946 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3931946 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
