急救！！！Jboss 出现 Error setting up static cursor cache

程序原来好好的，重装机器后，开始程序运行正常，可过一段时间后，出现以下错误，什么原因啊，盼高手解决！2008-12-21 19:09:52,078 ERROR [STDERR] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache.
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.setupTempFiles(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.postSetupInitialize(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseImplServiceResultSet.postSetupInitialize(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseResultSet.<init>(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseStatement.commonGetNextResultSet(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.evelong.web.business.common.LoginBusiness.comparePassword(LoginBusiness.java:40)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.evelong.web.action.common.LoginAction.loginCheck(LoginAction.java:87)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.evelong.web.action.common.LoginAction.execute(LoginAction.java:51)
2008-12-21 19:09:52,078 ERROR [STDERR]  at com.evelong.common.BaseAction.execute(BaseAction.java:39)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
2008-12-21 19:09:52,078 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
2008-12-21 19:09:52,078 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:73)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:54)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:174)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
2008-12-21 19:09:52,078 ERROR [STDERR]  at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
2008-12-21 19:09:52,078 ERROR [STDERR]  at java.lang.Thread.run(Thread.java:534)
2008-12-21 19:10:13,515 INFO  [com.evelong.web.action.common.LoginAction] ===================loginCheck.Action Start
2008-12-21 19:10:13,515 INFO  [com.evelong.web.business.common.LoginBusiness] ===================loginCheck.Action Start

解决方案 »

  1.   

    Jboss运行一段时间才出现这个问题，估计可能是配置方面的问题数据库连接用的是db.properties文件，内容如下
    drivers=com.microsoft.sqlserver.jdbc.SQLServerDriver
    evelong.url=jdbc:sqlserver://localhost:1433;DatabaseName=DEMO
    evelong.user=sa
    evelong.password=
    evelong.maxconn=200
      

  2.   

    具体就是sql server在往某个目录写临时文件时失败，在jboss的根目录下建一个名字为temp的目录试试，或者在系统盘根目录下建一个叫temp的文件夹
      

  3.   

    程序是去年开发完的，已经用了两年，半个月前服务器崩溃，重装了系统，直到今天！今天是一百多人大规模登陆的日子，今天登录的人比较多，出现这样的问题，我用netstat -a -n看有不少TCP处于 Time_Wait状态
    不知道正常不正常比如：TCP    10.1.2.2:80            10.0.0.7:64431         TIME_WAIT