Help Required!! SQLException: Io exception: Connection reset by peer

Discussion in 'Java' started by abhi, Sep 27, 2006.

  1. abhi

    abhi Guest

    I am getting this error while uploading an .xls file to oracle DB
    throug my struts app. Can anyone help me with this.Following is the
    stack trace:


    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:334)
    at
    oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3668)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
    at
    oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
    at
    oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
    at
    oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
    at
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
    at
    oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
    at
    oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
    at com.TCS.ismanager.DAO.CRMgmtDAO.insertNewFile(CRMgmtDAO.java:300)
    at com.TCS.ismanager.DAO.CRMgmtDAO.saveFile(CRMgmtDAO.java:259)
    at
    com.TCS.ismanager.actions.CRMgmtAction.execute(CRMgmtAction.java:79)
    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:763)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
    at
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
    at
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
    at
    org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at
    org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
    at
    org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
    at
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
    at
    org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at
    org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
    at
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
    at
    org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
    at
    org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
    at
    org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
    at
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
    at
    org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at
    org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
    at
    org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
    at
    org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
    at
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
    at
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
    at
    org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
    at
    org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
    at java.lang.Thread.run(Thread.java:568)
    abhi, Sep 27, 2006
    #1
    1. Advertising

  2. Hi,

    Check the connection string you are using. Can you tnsping the service
    from the server box? Looks like the connection between the server and
    the database is broken. If you can tnsping, then you might want to
    bounce your application server to re-establish the connection (or
    connections if you are pooling 'em).

    -cheers,
    Manish
    Manish Pandit, Sep 27, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John O'Conner
    Replies:
    1
    Views:
    469
    totojepast
    Jan 30, 2004
  2. Sudheer
    Replies:
    2
    Views:
    1,294
    Roedy Green
    Apr 1, 2004
  3. Guy Noir

    Re: peer to peer messaging

    Guy Noir, May 26, 2005, in forum: Java
    Replies:
    7
    Views:
    682
    Owen Jacobson
    May 31, 2005
  4. Matt Gessner
    Replies:
    1
    Views:
    1,387
  5. Replies:
    0
    Views:
    363
Loading...

Share This Page