报错:"该连接已关闭"

   在WIN2003＋SQL SERVER2005(Developer) + Jboss3.2.6+jdk.14 环境下运行系统，偶尔会报如下错：

 

2009-03-05 17:38:10,562 INFO [STDOUT] 2009-3-5 17:38:10 com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement close 警告: SQLServerPreparedStatementID:242752 ( ConnectionID:11 TransactionID:0x0000000000000000): Error (ignored) closing PreparedHandle:0 com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$1PreparedHandleClose.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closePreparedHandle(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.close(Unknown Source) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.agedOut(CachedPreparedStatement.java:325) at org.jboss.resource.adapter.jdbc.PreparedStatementCache.ageOut(PreparedStatementCache.java:144) at org.jboss.util.LRUCachePolicy$LRUList.demote(LRUCachePolicy.java:360) at org.jboss.util.LRUCachePolicy.insert(LRUCachePolicy.java:176) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:338) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:192) at com.hrp.app2.task_alignment.dao.HrTaskAlignmentDAO.findByCondition(HrTaskAlignmentDAO.java:653) at com.hrp.app2.task_alignment.dao.HrTaskAlignmentDAO.findByCondition(HrTaskAlignmentDAO.java:589) at com.hrp.app2.task_alignment.dao.HrTaskAlignmentDAOImp.findNotRunning(HrTaskAlignmentDAOImp.java:182) at servlet.RunningList.startToRunning(RunningList.java:68) at servlet.Watcher.backExecute(BackExecuteByStepTime.java:119) at servlet.Watcher.run(BackExecuteByStepTime.java:105) at java.lang.Thread.run(Thread.java:534) 2009-03-05 17:38:10,593 INFO [STDOUT] com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。 2009-03-05 17:38:10,593 INFO [STDOUT] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) 2009-03-05 17:38:10,593 INFO [STDOUT] at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source) 2009-03-05 17:38:10,593 INFO [STDOUT] at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(Unknown Source) 2009-03-05 17:38:10,593 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:348) 2009-03-05 17:38:10,593 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:336) 2009-03-05 17:38:10,593 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:192)

 

 后来经过升级JDK，JBOSS，换开源驱动，做压力测试等等，都测试不出来这种情况，只有一种情况除外，那就是运行一条SQL执行时间20分左右,

此时才会报上面的错,而且报错之后jboss没有挂掉，只是与数据库连接不成功，因为这是客户正式机，所以当初没有考虑到sql server2005版

本问题,Microsof公司申明企业版和开发版只存在版权问题，不存在功能问题(听说的),在一次偶然的机会下，同事问我，客户怎么用的开发版的数据库,当时在想会不会是这个的原因啊，后来让客户装了一个企业版，我再继续测试了几次，发现问题没有，然后一直到现在都没有出现这种情况了。

     之前问过客户，为什么要装开发版的，他们说企业版的太贵了。晕了..............