Causedby：SocketException：Connectionr。。。

ERROR 27-05 13:02:11,659 - 原客户号[4264257810]更新失败

hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [select mpextsysac0_.ACCT_NO as

ACCT1_3_, mpextsysac0_.ACCT_TYPE as ACCT2_3_, mpextsysac0_.EXT_CUSTOMER_ID as EXT3_3_, mpextsysac0_.EXT_SYS_ACCT_NO as EXT4_3_,

mpextsysac0_.EXT_SYS_ACCT_STATUS as EXT5_3_, mpextsysac0_.EXT_SYS_TIME as EXT6_3_, mpextsysac0_.EXT_SYSTEM_ID as EXT7_3_,

mpextsysac0_.JPA_VERSION as JPA8_3_, mpextsysac0_.ORG as ORG3_ from MP_EXT_SYS_ACCT mpextsysac0_ where mpextsysac0_.EXT_CUSTOMER_ID=?]; SQL state [null]; error code [0]; could not execute query; nested exception is ption.GenericJDBCException: could not execute query

at vertHibernateAccessException(SessionFactoryUtils.java:651)

at jpa.anslateExceptionIfPossible(HibernateJpaDialect.java:104)

at anslateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403)

at org.springframework.dao.anslateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)

at org.springframework.dao.anslateIfNecessary(DataAccessUtils.java:213)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

org.springframework.pository.support.LockModeRepositoryPostProcessor$LockModePopulatingMethodIntercceptor.invoke(LockModeRepositoryPostProcessor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy63.findOne(Unknown Source)

aps.batch.a1001.A1001CompareProcessor.process(A1001CompareProcessor.java:57)

aps.batch.a1001.A1001CompareProcessor.process(A1001CompareProcessor.java:1)

aps.batch.a1001.A1001CompareProcessor$$FastClassByCGLIB$$ac40e66d.invoke(<generated>)

at lib.proxy.MethodProxy.invoke(MethodProxy.java:204)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)

aps.batch.a1001.A1001CompareProcessor$$EnhancerByCGLIB$$c4efa718.process(<generated>)

flect.GeneratedMethodAccessor47.invoke(Unknown Source)

flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at flect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy28.process(Unknown Source)

硅胶模具制作方法

at org.step.item.SimpleChunkProcessor.doProcess(SimpleChunkProcessor.java:125)

at org.step.ansform(SimpleChunkProcessor.java:291)肩扛式摄像机

at org.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:190)

at org.step.ute(ChunkOrientedTasklet.java:74)

at org.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:386)

at ansaction.ute(TransactionTemplate.java:130)

at org.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:264)

at org.t.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:76)

at org.peat.NextResult(RepeatTemplate.java:367)

at org.peat.uteInternal(RepeatTemplate.java:214)

at org.peat.support.RepeatTemplate.iterate(RepeatTemplate.java:143)

at org.step.tasklet.TaskletStep.doExecute(TaskletStep.java:250)

足球加工at org.ute(AbstractStep.java:195)

at org.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:135)

at org.job.uteStep(JobFlowExecutor.java:61)

at org.job.flow.support.state.StepState.handle(StepState.java:60)

at org.job.flow.sume(SimpleFlow.java:144)

at org.job.flow.support.SimpleFlow.start(SimpleFlow.java:124)

at org.job.flow.FlowJob.doExecute(FlowJob.java:135)

at org.ute(AbstractJob.java:293)

at org.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:120)

at ute(SyncTaskExecutor.java:48)

at org.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:114)

st.st(SpringJunitBaseTest.java:65)

st.MyTest.main(MyTest.java:26)

Caused by: ption.GenericJDBCException: could not execute query

at ption.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

at vert(SQLStateConverter.java:128)

at vert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2545)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

at org.hibernate.loader.Loader.list(Loader.java:2271)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)

at ine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

31auat org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at org.hibernate.SingleResult(QueryImpl.java:274)

sema.query.jpa.SingleResult(AbstractJPAQuery.java:219)

sema.query.jpa.impl.AbstractJPAQuery.uniqueResult(AbstractJPAQuery.java:295)

sema.query.jpa.impl.AbstractJPAQuery.uniqueResult(AbstractJPAQuery.java:281)

at org.springframework.pository.support.QueryDslJpaRepository.findOne(QueryDslJpaRepository.java:86)

flect.GeneratedMethodAccessor60.invoke(Unknown Source)

flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at flect.Method.invoke(Method.java:597)

at org.support.uteMethodOn(RepositoryFactorySupport.java:344)

at org.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:329)视频采集

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at ansaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)

... 53 more

Caused by: java.sql.SQLException: connection holder is null

at com.alibaba.druid.pool.DruidPooledConnection.checkState(DruidPooledConnection.java:1090)

at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:305)

at org.hibernate.PreparedStatement(AbstractBatcher.java:534)

at org.hibernate.PreparedStatement(AbstractBatcher.java:452)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)

at org.hibernate.loader.Loader.doQuery(Loader.java:801)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2542)

... 74 more

Caused by: java.sql.SQLRecoverableException: IO 错误: Connection reset

at oracle.jdbc.uteForRows(T4CPreparedStatement.java:1028)

at oracle.jdbc.uteMaybeDescribe(OracleStatement.java:1177)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

at oracle.jdbc.uteInternal(OraclePreparedStatement.java:3449)

at oracle.jdbc.uteQuery(OraclePreparedStatement.java:3493)

at oracle.jdbc.uteQuery(OraclePreparedStatementWrapper.java:1491)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2714)

at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2711)

at com.alibaba.druid.proxy.uteQuery(PreparedStatementProxyImpl.java:132)

at com.alibaba.druid.uteQuery(DruidPooledPreparedStatement.java:227)

at org.hibernate.ResultSet(AbstractBatcher.java:208)

at org.hibernate.ResultSet(Loader.java:1953)

at org.hibernate.loader.Loader.doQuery(Loader.java:802)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2542)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

at org.hibernate.loader.Loader.list(Loader.java:2271)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)

at ine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at org.hibernate.SingleResult(QueryImpl.java:274)

sema.query.jpa.SingleResult(AbstractJPAQuery.java:219)

sema.query.jpa.impl.AbstractJPAQuery.uniqueResult(AbstractJPAQuery.java:295)

sema.query.jpa.impl.AbstractJPAQuery.uniqueResult(AbstractJPAQuery.java:281)

at org.springframework.pository.support.QueryDslJpaRepository.findOne(QueryDslJpaRepository.java:86)

flect.GeneratedMethodAccessor60.invoke(Unknown Source)

flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at flect.Method.invoke(Method.java:597)

at org.support.uteMethodOn(RepositoryFactorySupport.java:344)

at org.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:329)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

crpd-366at ansaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy58.findOne(Unknown Source)

aps.batch.a1001.A1001CompareProcessor.process(A1001CompareProcessor.java:58)

... 45 more

Caused by: SocketException: Connection reset

ad(SocketInputStream.java:168)

ive(Packet.java:282)

ive(DataPacket.java:103)

NextPacket(NetInputStream.java:230)

ad(NetInputStream.java:175)

ad(NetInputStream.java:100)

ad(NetInputStream.java:85)

at oracle.jdbc.adNextPacket(T4CSocketInputStreamWrapper.java:122)

at oracle.jdbc.ad(T4CSocketInputStreamWrapper.java:78)

at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

at oracle.jdbc.ive(T4CTTIfun.java:279)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

at oracle.jdbc.uteForRows(T4CPreparedStatement.java:1008)

... 89 more

Connection reset ：⼀般是客户端正在从服务器读数据时或者向服务器写数据时，服务器连接关闭，通过tcpdump抓包可以看到，返回了⼀个RST复位标志，导致连接重置。导致此异常的原因，总结下来有三种情况：

1.服务器端偶尔出现了异常，导致连接关闭

解决⽅法：采⽤出错重试机制

2.服务器端和客户端使⽤的连接⽅式不⼀致

解决⽅法：服务器端和客户端使⽤相同的连接⽅式，即同时使⽤长连接或短连接

3.如果是HTTPS，那么还存在TLS版本不⼀致

解决⽅法：服务器端和客户端使⽤相同的TLS版本

附录：JDK中对 HTTPS 版本的⽀持情况：

JDK 6

SSL v3

TLS v1(默认)

TLS v1.1(JDK6 update 111 及以上)

JDK 7

SSLv3

TLS v1(默认)

TLS v1.1

TLS v1.2

JDK 8

SSL v3

TLS v1

TLS v1.1

TLS v1.2(默认)

如果客户端JDK是1.7，服务器端要求TLSv1.2，那么在启动参数加上-Dhttps.protocols=TLSv1.2即可。

或者代码指定TLS版本 System.setProperty("https.protocols", "TLSv1.2");

本文发布于:2024-09-25 15:26:27，感谢您对本站的认可！

本文链接：https://www.17tex.com/tex/3/104857.html

上一篇：grub启动过程

下一篇：【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课

标签：连接导致版本服务器端服务器客户端硅胶

留言与评论（共有 0 条评论）