org.hibernate.exception.GenericJDBCException: Cannot release connection

每次保存附件时报错

org.hibernate.exception.GenericJDBCException: Cannot release connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:455)
at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
at com.sinitek.base.metadb.MetaDBContextImpl.rollback(MetaDBContextImpl.java:283)
at com.sinitek.base.metadb.support.MetaDBContextSuppportInvocationHandler.invoke(MetaDBContextSuppportInvocationHandler.java:219)
at $Proxy0.saveAttachment(Unknown Source)
at com.sinitek.sirm.web.rschreport.innerreport.asyn.AttachmentConvertRunnable.sendSMS(AttachmentConvertRunnable.java:95)
at com.sinitek.sirm.web.rschreport.innerreport.asyn.AttachmentConvertRunnable.run(AttachmentConvertRunnable.java:47)
at java.lang.Thread.run(Thread.java:662)
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)
at com.sinitek.base.metadb.config.impl.ConnectionProviderImpl.closeConnection(ConnectionProviderImpl.java:48)
at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
... 10 more
Exception in thread "启动线程-报告模板附件转换pdf" [01010026]-保存实体[ATTACHMENT]的对象时失败
at com.sinitek.base.metadb.MetaObjectImpl.save(MetaObjectImpl.java:221)
at com.sinitek.sirm.common.attachment.entity.AttachmentMO.save(AttachmentMO.java:345)
at com.sinitek.sirm.common.attachment.service.impl.AttachmentServiceImpl.saveAttachment(AttachmentServiceImpl.java:44)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sinitek.base.metadb.support.MetaDBContextSuppportInvocationHandler.invoke(MetaDBContextSuppportInvocationHandler.java:154)
at $Proxy0.saveAttachment(Unknown Source)
at com.sinitek.sirm.web.rschreport.innerreport.asyn.AttachmentConvertRunnable.sendSMS(AttachmentConvertRunnable.java:95)
at com.sinitek.sirm.web.rschreport.innerreport.asyn.AttachmentConvertRunnable.run(AttachmentConvertRunnable.java:47)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.JDBCConnectionException: could not update: [ATTACHMENT#1101343]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2430)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.sinitek.base.metadb.MetaObjectImpl.save(MetaObjectImpl.java:211)
... 11 more
Caused by: java.sql.SQLException: IO 错误: Connection reset by peer: socket write error
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1028)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2412)
... 21 more
Caused by: java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at oracle.net.ns.DataPacket.send(DataPacket.java:199)
at oracle.net.ns.NetOutputStream.write(NetOutputStream.java:176)
at oracle.jdbc.driver.T4CSocketOutputStreamWrapper.flush(T4CSocketOutputStreamWrapper.java:98)
at oracle.jdbc.driver.T4CSocketOutputStreamWrapper.flush(T4CSocketOutputStreamWrapper.java:91)
at oracle.jdbc.driver.T4CSocketOutputStreamWrapper.write(T4CSocketOutputStreamWrapper.java:83)
at oracle.jdbc.driver.T4CMAREngine.marshalB1Array(T4CMAREngine.java:585)
at oracle.jdbc.driver.T4CTTIrxd.marshal(T4CTTIrxd.java:793)
at oracle.jdbc.driver.T4C8Oall.marshalBinds(T4C8Oall.java:1532)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:947)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:185)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
... 28 more


试了很多不同的附件,发现docx的可以正常保存,600多KB的doc也可以正常保存,但900多KB的doc文件不能保存,试过的doc文件都是vba生成的报告模板文件,不知道文件本身的问题还是文件大小问题,有人说是网络问题,但是网络问题应该是随机的,现在



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值