Logo 
Search:

Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

java.sql.SQLException: Io exception: Connection reset by peer: socket write err

  Asked By: Kaua    Date: Mar 07    Category: Java    Views: 4601
  

I have an error like the following!
I want to know when this error occurs!
I think something works wrong and couses to closing
connection by time out!

I use jboss, hibernate, and a blob field in Oracle and
I want to insert this field by a picture. If the
picture was very small I dont have this error1

the error log:

org.jboss.resource.JBossResourceException:
SQLException; - nested throwable:
(java.sql.SQLException: Io exception: Connection reset
by peer: socket write error)

at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(Base\
WrapperManagedConnection.java:546)

at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapper\
ManagedConnection.java:252)

at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(Int\
ernalManagedConnectionPool.java:502)


at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

at
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:648)

at
oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.\
java:485)

at
oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:39\
3)

at
oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2333)

at
oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1412)

at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapper\
ManagedConnection.java:248)

... 69 more

15:20:17,852 WARN [JDBCExceptionReporter] SQL Error:
17002, SQLState: null

15:20:17,852 ERROR [JDBCExceptionReporter] Io
exception: Connection reset by peer: socket write
error

15:20:17,868 ERROR [JDBCExceptionReporter] could not
insert: [hibernate.TestUser#901]

java.sql.SQLException: Io exception: Connection reset
by peer: socket write error

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2061)

at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)

at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:270\
9)

at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement\
.java:589)

at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPr\
eparedStatement.java:324)

at
net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)

at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)

at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)

at
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)

at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)

at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)

at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)

at
net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)

at
jdbc.TestUserDaoImpl.insert(TestUserDaoImpl.java:42)

at
struts.InsertTestUserAction.execute(InsertTestUserAction.java:31)

at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.\
java:484)

at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

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

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

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:247)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)

at
filter.EncodingFilter.doFilter(EncodingFilter.java:35)

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:213)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)

at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2\
56)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1\
91)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm\
.java:220)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsVal\
ve.java:76)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)

at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java\
:171)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio\
nValve.java:65)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174\
)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)

at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)

at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio\
n(Http11Protocol.java:549)

at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)

at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:67\
7)

at java.lang.Thread.run(Thread.java:534)

15:20:17,930 ERROR [SessionImpl] Could not synchronize
database state with session

net.sf.hibernate.JDBCException: could not insert:
[hibernate.TestUser#901]

at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:478)

at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)

at
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)

at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)

at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)

at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)

at
net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)

at
jdbc.TestUserDaoImpl.insert(TestUserDaoImpl.java:42)

at
struts.InsertTestUserAction.execute(InsertTestUserAction.java:31)

at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.\
java:484)

at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

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

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

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:247)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)

at
filter.EncodingFilter.doFilter(EncodingFilter.java:35)

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:213)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)

at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2\
56)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1\
91)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm\
.java:220)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsVal\
ve.java:76)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)

at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java\
:171)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio\
nValve.java:65)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174\
)

at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)

at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)

at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)

at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio\
n(Http11Protocol.java:549)

at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)

at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:67\
7)

at java.lang.Thread.run(Thread.java:534)

Caused by: java.sql.SQLException: Io exception:
Connection reset by peer: socket write error

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2061)

at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)

at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:270\
9)

at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement\
.java:589)

at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPr\
eparedStatement.java:324)

at
net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)

at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)

... 56 more

Share: 

 

No Answers Found. Be the First, To Post Answer.

 




Tagged: