|
定时器每天8点调用内部程序一次,但是程序运行异常,报数据库错误。
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执
行sql: SELECT inven.FMATERIALNAME AS fMaterialName, inven.FPERSONID AS fPersonI
D, inven.FNUMBER AS fNumber, inven.FCURRENTEXECUTORS AS fCurrentExecutors, inven
.FSPECIFICATIONS AS fSpecifications FROM L_BM_INVENTORYCONTROL inven WHERE inve
n.FTYPE = ?, binds: [库存]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 33 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last pac
ket successfully received from the server was 60,751,746 milliseconds ago. The
last packet sent successfully to the server was 60,751,746 milliseconds ago. is
longer than the server configured value of 'wait_timeout'. You should consider e
ither expiring and/or testing connection validity before use in your application
, increasing the server configured values for client timeouts, or using the Conn
ector/J connection property 'autoReconnect=true' to avoid this problem.
这个怎么解决?谢谢
|
|