每次登陆的时候都会出现 事务回滚错误

腹部流出的肉

每次登陆系统的时候 都是要登陆两次 特别烦人 .... （x5.2.6）

腹部流出的肉

还有一个问题也是这样的 页面长时间不刷新 刷新一下就成了这样子

fpj

腹部流出的肉 发表于 2013-12-29 14:05
还有一个问题也是这样的 页面长时间不刷新 刷新一下就成了这样子

将你的TOMCAT 中报的错误信息贴一下。

腹部流出的肉

2014-01-03 13:24:41 action:<?xml version="1.0" encoding="UTF-8"?>
<actions><action process="/tcjl_bidmgr/statisticalReport/process/branchCompany/branchCompanyProcess" activity="branchCompanyActivity" name="getSysParamsAction" executeContext="" content-type="application/xml"><parameters/></action><action process="/tcjl_bidmgr/statisticalReport/process/branchCompany/branchCompanyProcess" activity="branchCompanyActivity" name="openActivityAction" executeContext="" content-type="application/xml"><parameters/></action></actions>
com.justep.exception.BusinessException: 编码: JUSTEP150050; 提示: 回滚事务出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.Transaction.rollback(Unknown Source)
        at com.justep.system.log.LogUtils.a(Unknown Source)
        at com.justep.system.log.LogUtils.log(Unknown Source)
        at com.justep.system.log.LogUtils.log(Unknown Source)
        at com.justep.system.interceptor.LogBefore.a(Unknown Source)
        at com.justep.system.interceptor.LogBefore.c(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
        at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Already closed.
        at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:114)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
        ... 30 more
2014-01-03 13:24:41 编码: JUSTEP150050; 提示: 回滚事务出错
javax.servlet.ServletException: com.justep.exception.BaseRuntimeException: 编码: JUSTEP150050; 提示: 回滚事务出错
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BaseRuntimeException: 编码: JUSTEP150050; 提示: 回滚事务出错
        at com.justep.ui.WindowServer.getData(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        ... 14 more
2014-1-3 13:24:41 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
com.justep.exception.BaseRuntimeException: 编码: JUSTEP150050; 提示: 回滚事务出错
        at com.justep.ui.WindowServer.getData(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)

腹部流出的肉

谢谢

zhaixin

你好楼主，该问题需要远程，已经通过技术服务QQ加你为好友了，请及时通过，我们会尽快QQ远程。

泡泡

解决没有？我这也有同样的问题

zhaixin

在长时间没有访问tomcat后，数据库连接已经失效，连接池因为没有检测，所以认为连接有效，导致连接出错。避免这种错误的方法是设置连接有效查询sql语句。设置后，连接池会使用该sql语句测试连接是否有效，如果无效，会重新建立连接。
设置方法为：在server.xml中的<Resource>节点中增加属性validationQuery="select   sysdate  from  dual;"。例如：
<Resource name="system" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://127.0.0.1:1433/x5_1900"
username="sa" password="sa" maxActive="10" maxIdle="5"
validationQuery="select  sysdate  from  dual;"/>