起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 11914|回复: 4

[处理中3] 点击功能报“刷新数据失败”,关闭再开不报错了

[复制链接]

39

主题

85

帖子

323

积分

中级会员

Rank: 3Rank: 3

积分
323
QQ
发表于 2021-4-8 09:20:51 | 显示全部楼层 |阅读模式
版本: 其它(帖子中说明) 小版本号:
数据库: MySQL 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 7 浏览器: Chrome
平台Bex5版本: 5.3.8.6314
这是正是服务器,本地开发环境没遇到过,现场多次反映此问题,上次以为是连接超时,在Tomcat中加了 validationQuery="select current_date" ,现在又报错了。
现场反映是偶尔报,关闭后打开功能又没问题了,而且一直在操作系统,不存在连接超时情况,请问是什么问题?
微信图片_20210408091307.jpg
2021-04-01 08:14:28 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:28 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:28 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:29 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:30 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:30 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:30 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:30 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:54 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:14:56 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:14:56 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:14:56 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:15:29 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:15:32 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:15:32 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:15:32 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:16:17 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:16:19 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:16:19 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:16:19 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where   newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01 08:16:40 excute stream action, params:{"process":"/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/generalMaterialsWarehousingProcess","activity":"mainActivity","translateParameter":{"rowsConfig":{"sequence":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","concept":"ERP_MaterialClass"},"dataType":"row-list","includeState":true,"transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false},"executor":"","executeContext":"","actionFlag":"__action_0__","action":"queryERP_MaterialClassAction","contentType":"json","parameters":{"filter":"(fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫%'))","variables":{},"offset":0,"columns":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","limit":20},"accept":"application/json"}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT ERP_MaterialClass.*  FROM ERP_MaterialClass ERP_MaterialClass WHERE ((fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫%'))) LIMIT 0, 20
--> sql: SELECT  ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass  WHERE  (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) )
--> binds: [工区物资, %硫%, %硫%, %硫%, %硫%, %硫%]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass  WHERE  (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) ) , binds: [工区物资, %硫%, %硫%, %硫%, %硫%, %硫%]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 35 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 36,160,987 milliseconds ago.  The last packet sent successfully to the server was 36,160,987 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 36 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
        ... 43 more
2021-04-01 08:16:57 excute stream action, params:{"process":"/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/generalMaterialsWarehousingProcess","activity":"mainActivity","translateParameter":{"rowsConfig":{"sequence":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","concept":"ERP_MaterialClass"},"dataType":"row-list","includeState":true,"transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false},"executor":"","executeContext":"","actionFlag":"__action_0__","action":"queryERP_MaterialClassAction","contentType":"json","parameters":{"filter":"(fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫酸%'))","variables":{},"offset":0,"columns":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","limit":20},"accept":"application/json"}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT ERP_MaterialClass.*  FROM ERP_MaterialClass ERP_MaterialClass WHERE ((fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫酸%'))) LIMIT 0, 20
--> sql: SELECT  ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass  WHERE  (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) )
--> binds: [工区物资, %硫酸%, %硫酸%, %硫酸%, %硫酸%, %硫酸%]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass  WHERE  (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) ) , binds: [工区物资, %硫酸%, %硫酸%, %硫酸%, %硫酸%, %硫酸%]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 35 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 36,224,001 milliseconds ago.  The last packet sent successfully to the server was 36,224,001 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 36 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
        ... 43 more
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from  ERP_MaterialDetail where fSL <= fYJSL
更新实时数据--------------------------------------------------------------------
2021-04-01 08:18:48 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:48 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:49 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:49 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:50 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:50 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:50 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:50 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:53 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:18:53 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:18:53 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:18:53 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:19:04 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:06 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:06 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:06 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:19 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:19:20 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:19:20 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:19:20 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where   newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from  ERP_MaterialDetail where fSL <= fYJSL
更新实时数据--------------------------------------------------------------------
2021-04-01 08:23:16 开始-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:23:16 结束-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:23:16 开始-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:23:17 结束-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 开始-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 结束-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 开始-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 结束-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where   newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from  ERP_MaterialDetail where fSL <= fYJSL
2021-04-01 08:27:49 执行sql: insert into SA_Log  (sCreatorPosName, sActivity, sAction, sCreatorFID, sProcess, sCreatorPersonName, sCreateTime, sParameters, sActionName, sIP, sDeviceType, sProcessName, sStatusName, sDescription, sCreatorFName, sCreatorPersonID, sCreatorOgnName, sOperatingSystem, version, SID, sResult, sCreatorPosID, sActivityName, sCreatorDeptID, sTypeName, sCreatorDeptName, sCreatorOgnID, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue), binds: [, mainActivity, logoutAction, /ORG01.ogn/PSN01@ORG01.psm, /SA/OPM/system/systemProcess, system, 2021-04-01 08:27:49.465, 参数名称: sessionID
参数值: {"value":"2AEA1BB54814ADB479932D68DE2005A1"}
, 退出, 192.168.4.200, 未知, 系统调用, 失败, null, /起步软件/system, PSN01, 起步软件, 未知, 0, 199793049F924FB6B1DD9B4EA7DA63D8, , , 系统, , 操作日志, , ORG01]失败
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 52,275,539 milliseconds ago.  The last packet sent successfully to the server was 52,275,539 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
        at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4882)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
        at com.justep.system.data.Transaction.begin(Unknown Source)
        at com.justep.system.log.LogUtils.execSqlUpdate(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.actionLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.doActionLog(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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Software caused connection abort: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
        ... 40 more
更新实时数据--------------------------------------------------------------------
2021-04-01 08:29:18 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:29:22 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:29:22 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:29:22 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:30:59 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
2021-04-01 08:31:00 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
2021-04-01 08:31:00 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
2021-04-01 08:31:00 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where   newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from  ERP_MaterialDetail where fSL <= fYJSL
更新实时数据--------------------------------------------------------------------
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where   newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01 08:36:48 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:48 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:48 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:48 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:49 Not registed session:989DFC625E298217F9110F03A815AC07, jsessionid:JSESSIONID=79528813B3AFBE010D2494536D13422C, action: <?xml version="1.0" encoding="UTF-8"?>
<actions><action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="getSysParamsAction" execute-context="" content-type="application/xml"><parameters/></action></actions>
2021-04-01 08:36:49 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:49 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:49 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:49 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:52 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:54 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:54 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:54 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:57 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:36:58 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:36:58 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:36:58 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w


91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35918
发表于 2021-4-8 11:18:45 | 显示全部楼层
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 36,224,001 milliseconds ago.  The last packet sent successfully to the server was 36,224,001 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.


报错是数据库的问题
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

39

主题

85

帖子

323

积分

中级会员

Rank: 3Rank: 3

积分
323
QQ
 楼主| 发表于 2021-4-8 17:50:27 | 显示全部楼层
jishuang 发表于 2021-4-8 11:18
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully rec ...

我知道是这个问题,我查到其他帖子也有类似问题,我根据你回复的连接设置了,在Tomcat中加了 validationQuery="select current_date" 。
但是现在还是报错,正式环境的Tomcat是在studio里面启动的,是否跟这个有关系呢?
请问该怎么解决?急急急
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35918
发表于 2021-4-8 19:18:27 | 显示全部楼层
报错中已经给你了提示信息了啊,加上autoReconnect=true看看

正式环境为什么要在studio中启动tomcat?这个是不推荐的
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

39

主题

85

帖子

323

积分

中级会员

Rank: 3Rank: 3

积分
323
QQ
 楼主| 发表于 2021-4-8 20:29:00 | 显示全部楼层
jishuang 发表于 2021-4-8 19:18
报错中已经给你了提示信息了啊,加上autoReconnect=true看看

正式环境为什么要在studio中启动tomcat?这个 ...

我设置了autoReconnect=true, 后续几天看看使用情况。
已经在startup.bat启动Tomcat了,之前在studio中启动是客户自己启动的,
请暂时不要结贴,观察一周若没问题再结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-4-26 17:22 , Processed in 0.064495 second(s), 28 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表