1000字范文 > java recv failed java.sql.SQLException: I/O Error: Software caused connection abort: recv failed

java recv failed java.sql.SQLException: I/O Error: Software caused connection abort: recv failed

时间：2022-10-17 05:55:39

现在我遇到如下的问题，想请教高手帮忙分析一下是怎么回事：

场景描述：现在是一个发送短信的程序，具体操作如下：首先做一个数据统计，而这个统计信息是存储在oracle10g数据库中，然后将这些统计信息组合成一个xml形式的字符串发送到一个webservice程序，这个webserveice程序就负责将这个xml形式的字符串解析入库，而这个库是mssql2000的，插入到这个库中之后就能发送出去短信了。以前这套程序一直很正常，但是最近却发生了在webservice程序往mssql2000这个数据库中插入数据的时候报错，具体错误信息：

-02-03 08:57:05-234278182-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.transport.DefaultEndpoint - Received message to /MessageServer/services/MessageService

-02-03 08:57:05-234278184-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.handler.DispatchServiceHandler@191683b]org.codehaus.xfire.handler.DispatchServiceHandler@191683b[/url] to phase dispatch

-02-03 08:57:05-234278184-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.soap.handler.ReadHeadersHandler@1522560]org.codehaus.xfire.soap.handler.ReadHeadersHandler@1522560[/url] to phase parse

-02-03 08:57:05-234278184-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.soap.handler.ValidateHeadersHandler@13e113]org.codehaus.xfire.soap.handler.ValidateHeadersHandler@13e113[/url] to phase pre-invoke

-02-03 08:57:05-234278184-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.handler.LocateBindingHandler@11dd59f]org.codehaus.xfire.handler.LocateBindingHandler@11dd59f[/url] to phase dispatch

-02-03 08:57:05-234278184-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.soap.handler.SoapActionInHandler@1b3c8a8]org.codehaus.xfire.soap.handler.SoapActionInHandler@1b3c8a8[/url] to phase dispatch

-02-03 08:57:05-234278184-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.soap.handler.SoapBodyHandler@3a96ac]org.codehaus.xfire.soap.handler.SoapBodyHandler@3a96ac[/url] to phase dispatch

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.service.binding.ServiceInvocationHandler@7a0ff7]org.codehaus.xfire.service.binding.ServiceInvocationHandler@7a0ff7[/url] to phase service

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.service.binding.PostInvocationHandler@1ae33d6]org.codehaus.xfire.service.binding.PostInvocationHandler@1ae33d6[/url] to phase service

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase transport

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase parse

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking handler org.codehaus.xfire.soap.handler.ReadHeadersHandler in phase parse

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase pre-dispatch

-02-03 08:57:05-234278185-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase dispatch

-02-03 08:57:05-234278200-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking handler org.codehaus.xfire.soap.handler.SoapActionInHandler in phase dispatch

-02-03 08:57:05-234278200-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.handler.OutMessageSender@4ae1c1]org.codehaus.xfire.handler.OutMessageSender@4ae1c1[/url] to phase send

-02-03 08:57:05-234278200-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler [url=mailto

rg.codehaus.xfire.soap.handler.SoapActionOutHandler@db88af]org.codehaus.xfire.soap.handler.SoapActionOutHandler@db88af[/url] to phase transport

-02-03 08:57:05-234278200-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - adding handler org.codehaus.xfire.soap.handler.SoapSerializerHandler@eab445 to phase post-invoke

-02-03 08:57:05-234278200-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase policy

-02-03 08:57:05-234278201-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase user

-02-03 08:57:05-234278201-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase pre-invoke

-02-03 08:57:05-234278201-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking handler org.codehaus.xfire.soap.handler.ValidateHeadersHandler in phase pre-invoke

-02-03 08:57:05-234278201-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking phase service

-02-03 08:57:05-234278201-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.codehaus.xfire.handler.HandlerPipeline - Invoking handler org.codehaus.xfire.service.binding.ServiceInvocationHandler in phase service

-02-03 08:57:05-234278201-[LOG] INFO [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' impl.MessageServiceImpl - 收到发送的短信信息。

-02-03 08:57:05-234278223-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.impl.SessionImpl - opened session at timestamp: 13282306255

-02-03 08:57:05-234278223-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.transaction.JDBCTransaction - begin

-02-03 08:57:05-234278223-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.jdbc.ConnectionManager - opening JDBC connection

-02-03 08:57:05-234278223-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.transaction.JDBCTransaction - current autocommit status: false

-02-03 08:57:05-234278223-[LOG] INFO [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' impl.MessageServiceImpl - 发送短信信息开始。

-02-03 08:57:05-234278224-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' dao.MessageDAO - saving Message instance

-02-03 08:57:05-234278224-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.event.def.AbstractSaveEventListener - executing identity-insert immediately

-02-03 08:57:05-234278224-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)

-02-03 08:57:05-234278224-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.SQL - insert into cqyw.dbo.message (app_name, app_password, message, mobile) values (?, ?, ?, ?)

-02-03 08:57:05-234278227-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)

-02-03 08:57:05-234278227-[LOG] DEBUG [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.util.JDBCExceptionReporter - could not insert: [pojo.Message] [insert into cqyw.dbo.message (app_name, app_password, message, mobile) values (?, ?, ?, ?)]

java.sql.SQLException: I/O Error: Software caused connection abort: recv failed

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1053)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:537)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:504)

at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)

at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)

at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)

at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)

at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)

at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)

at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)

at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)

at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)

at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)

at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)

at dao.MessageDAO.save(MessageDAO.java:37)

at impl.MessageServiceImpl.sendSMS(MessageServiceImpl.java:50)

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 org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:59)

at org.codehaus.xfire.service.invoker.ObjectInvoker.invoke(ObjectInvoker.java:45)

at org.codehaus.xfire.service.binding.ServiceInvocationHandler.sendMessage(ServiceInvocationHandler.java:320)

at org.codehaus.xfire.service.binding.ServiceInvocationHandler$1.run(ServiceInvocationHandler.java:86)

at org.codehaus.xfire.service.binding.ServiceInvocationHandler.execute(ServiceInvocationHandler.java:134)

at org.codehaus.xfire.service.binding.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:109)

at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)

at org.codehaus.xfire.transport.DefaultEndpoint.onReceive(DefaultEndpoint.java:64)

at org.codehaus.xfire.transport.AbstractChannel.receive(AbstractChannel.java:38)

at org.codehaus.xfire.transport.http.XFireServletController.invoke(XFireServletController.java:304)

at org.codehaus.xfire.transport.http.XFireServletController.doService(XFireServletController.java:129)

at org.codehaus.xfire.transport.http.XFireServlet.doPost(XFireServlet.java:116)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

Caused by: .SocketException: Software caused connection abort: recv failed

at .SocketInputStream.socketRead0(Native Method)

at .SocketInputStream.read(SocketInputStream.java:147)

at java.io.DataInputStream.readFully(DataInputStream.java:178)

at java.io.DataInputStream.readFully(DataInputStream.java:152)

at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:846)

at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:727)

at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)

at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)

at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)

at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3932)

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1046)

... 55 more

-02-03 08:57:05-234278229-[LOG] WARN [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08S01

-02-03 08:57:05-234278229-[LOG] ERROR [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' org.hibernate.util.JDBCExceptionReporter - I/O Error: Software caused connection abort: recv failed

-02-03 08:57:05-234278229-[LOG] ERROR [ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)' dao.MessageDAO - save failed

org.hibernate.exception.JDBCConnectionException: could not insert: [pojo.Message]

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)