java.sql.SQLException: Io exception: Software caused connection abort: recv failed

[Mohanasundar Nagarajan]

Kindly help me to solve this issue.
I'm getting this problem frequently in my tomcat 6.

Here is the error.

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.
java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:44
8)
        at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Ajp
AprProtocol.java:399)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:16
75)
        at java.lang.Thread.run(Thread.java:662)
[quote]java.sql.SQLException: Io exception: Software caused connection abort: recv fail
ed[/quote]
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:254)
        at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:479)
        at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1
174)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.close(DelegatingConn
ection.java:247)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnection.reallyClose(PoolableCo
nnection.java:122)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.destroyObject(P
oolableConnectionFactory.java:628)
        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.invalidateObject(G
enericObjectPool.java:1282)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.invalidateObject(Aban
donedObjectPool.java:125)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.removeAbandoned(Aband
onedObjectPool.java:158)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(Abandone
dObjectPool.java:77)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDa
taSource.java:106)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:1044)
        at single.context.DBConnection.getConnection(DBConnection.java:134)
        at ActionDecisionMaker.getTenderActivity(ActionDecisionMaker.java:38)
        at TenByLineTopServlet.doGet(TenByLineTopServlet.java:78)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:404)
        at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java
:136)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.
java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:44
8)
        at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Ajp
AprProtocol.java:399)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:16
75)
        at java.lang.Thread.run(Thread.java:662)
SELECT ISCHARGEABLE FROM SMS_MASTER WHERE SEQNO='1'
SELECT ISCHARGEABLE FROM SMS_MASTER WHERE SEQNO='2'
s230
s230
s230
java.sql.SQLException: Io exception: Software caused connection abort: recv fail
ed
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:254)
        at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:479)
        at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1
174)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.close(DelegatingConn
ection.java:247)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnection.reallyClose(PoolableCo
nnection.java:122)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.destroyObject(P
oolableConnectionFactory.java:628)
        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.invalidateObject(G
enericObjectPool.java:1282)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.invalidateObject(Aban
donedObjectPool.java:125)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.removeAbandoned(Aband
onedObjectPool.java:158)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(Abandone
dObjectPool.java:77)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDa
taSource.java:106)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:1044)
        at single.context.DBConnection.getConnection(DBConnection.java:134)
        at SelectScheduleServlet.activityExist(SelectScheduleServlet.java:7218)
        at SelectScheduleServlet.doGet(SelectScheduleServlet.java:2415)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:404)
        at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java
:136)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.
java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:44
8)
        at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Ajp
AprProtocol.java:399)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:16
75)
        at java.lang.Thread.run(Thread.java:662)
java.sql.SQLException: Io exception: Software caused connection abort: recv fail
ed
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:254)
        at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:479)
        at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1
174)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.close(DelegatingConn
ection.java:247)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnection.reallyClose(PoolableCo
nnection.java:122)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.destroyObject(P
oolableConnectionFactory.java:628)
        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.invalidateObject(G
enericObjectPool.java:1282)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.invalidateObject(Aban
donedObjectPool.java:125)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.removeAbandoned(Aband
onedObjectPool.java:158)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(Abandone
dObjectPool.java:77)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDa
taSource.java:106)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:1044)
        at asl.tw.data.db.source.TWDataSource.getConnection(TWDataSource.java:12
8)
        at asl.tw.data.db.source.TWDataSource.exequteSQL(TWDataSource.java:204)
        at asl.tw.data.db.source.TWDataSource.exequteSQL(TWDataSource.java:162)
        at SelectScheduleServlet.doGet(SelectScheduleServlet.java:75)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:404)
        at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java
:136)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.
java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:44
8)
        at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Ajp
AprProtocol.java:399)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:16
75)
        at java.lang.Thread.run(Thread.java:662)
java.sql.SQLException: Io exception: Software caused connection abort: recv fail
ed
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:254)
        at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:479)
        at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1
174)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.close(DelegatingConn
ection.java:247)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnection.reallyClose(PoolableCo
nnection.java:122)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.destroyObject(P
oolableConnectionFactory.java:628)
        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.invalidateObject(G
enericObjectPool.java:1282)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.invalidateObject(Aban
donedObjectPool.java:125)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.removeAbandoned(Aband
onedObjectPool.java:158)
        at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(Abandone
dObjectPool.java:77)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDa
taSource.java:106)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:1044)
        at single.context.DBConnection.getConnection(DBConnection.java:134)
        at single.context.TenderResubmitDAO.checkForResubmission(TenderResubmitD
AO.java:28)
        at SelectScheduleServlet.doGet(SelectScheduleServlet.java:626)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:404)
        at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java
:136)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.
java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:44
8)
        at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Ajp
AprProtocol.java:399)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:16
75)
        at java.lang.Thread.run(Thread.java:662)

[Wendy Gibbons]

which database are you using?
and something in the stack trace caught my eye it listed 2 select statements and then 3 lines containing: s230
where is the s230 coming from? could you put either a breakpoint or some system printlines showing exactly every sql line you are trying to process.