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. Advertisements

  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. Advertisements

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. David Klemitz
    Replies:
    1
    Views:
    1,087
  2. ap
    Replies:
    0
    Views:
    576
  3. Matt Gessner
    Replies:
    1
    Views:
    1,564
  4. Donnal Walter

    telnet 'connection reset by peer'

    Donnal Walter, Aug 23, 2004, in forum: Python
    Replies:
    4
    Views:
    912
    Donnal Walter
    Aug 23, 2004
  5. Thomas Guettler

    SimpleHTTPServer: connection reset by peer

    Thomas Guettler, Oct 5, 2004, in forum: Python
    Replies:
    0
    Views:
    667
    Thomas Guettler
    Oct 5, 2004
  6. Replies:
    3
    Views:
    423
    Ben Sizer
    Oct 20, 2005
  7. Van_Gogh
    Replies:
    3
    Views:
    729
    Tim Roberts
    Jan 8, 2006
  8. Replies:
    4
    Views:
    790
    Manivannan Palanichamy
    Jun 8, 2007
Loading...