【问题】
EOS Platform 7.2 oracle apache-tomcat-7.0.68 java version "1.8.0_152",系统运行1-2天后,后台报错:
Message: 新增一条记录失败. 事务回滚.
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:232)
......
Caused by: ErrCode: 14101015
Message: 和数据库通讯出现问题(Could not execute JDBC batch update)
at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:144)
at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:123)
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
... 61 more
Caused by: com.primeton.das.entity.impl.hibernate.exception.JDBCConnectionException: Could not execute JDBC batch update
at com.primeton.das.entity.impl.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at com.primeton.das.entity.impl.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
......
Caused by: java.sql.SQLRecoverableException: 关闭的连接
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:5416)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1585)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1570)
... 68 more
【解答】
解决方式:项目里使用了BPS_7.5_PTP_20151230_P2做自动重连后,没有再出现问题