I use MSSQL 2000 JDBC in JBoss, the config is
-----------------------------------------------------

<depends optional-attribute-name="ManagedConnectionFactoryName">

myapp-datasource


<config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver://169.1.1.34:1433;DatabaseName=mydb;SelectMethod=Cursor</config-property>
<config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
<config-property name="UserName" type="java.lang.String">sa</config-property>
<config-property name="Password" type="java.lang.String">passord</config-property>


<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper



<depends optional-attribute-name="ManagedConnectionPool">

0
100
5000
15
ByContainer


<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
java:/TransactionManager
jboss.jca:service=RARDeployer

------------------------------------------------------------------

when i use 200 user access this app,the app is godd.
when i make the network is invalid,then restore the network,the app don't restore.

some one meet this question?

Jboss version :3.0.7+Tomcat4.1.24