JDBC Driver: Connection reset by peer: socket write error

From: chrissy (ginger_at_notme.com)
Date: 11/11/04

  • Next message: Joe Weinstein: "Re: JDBC Driver: Connection reset by peer: socket write error" 
    Date: 11 Nov 2004 07:23:59 -0800

    I am using Microsoft SQL Server 2000 Driver for JDBC Service Pack 1
    and on occasion receive:

    "ServerXact exception: java.sql.SQLException: [Microsoft][SQLServer
    2000 Driver for JDBC]Connection reset by peer: socket write error
    java.lang.RuntimeException: ServerXact exception:
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
    JDBC]Connection reset by peer: socket write error at
    com.ondemandinc.server.ServerXact$odiStatement.execute(ServerXact.java:767)
    at com.ondemandinc.server.ServerXact.execute(ServerXact.java:420) at
    com.ondemandinc.server.xact.DBLoginXact.execute(DBLoginXact.java:77)
    at com.ondemandinc.server.web.Login.core_execute(Login.java:140) at
    com.ondemandinc.server.web.Login._execute(Login.java:116) at
    com.ondemandinc.server.web.Login.execute(Login.java:87) at
    com.ondemandinc.server.webTask.run(webTask.java:130) at
    com.ondemandinc.utils.WorkerThread.run(WorkerThread.java:88)
    "

    I reboot the server, it works again. The SQL Server it connects to is
    SQL Server 2000 Standard Edition SP3. Any ideas what is happening?

    Thanks

  • Next message: Joe Weinstein: "Re: JDBC Driver: Connection reset by peer: socket write error"

    Relevant Pages

    • RE: [dbi] Re: MsSQL DBD::ODBC IsNull and undef
      ... I'd guess this is because the SQL Server ODBC driver is looking at your ... Martin J. Evans ... can you run your test script again but creating an OOB log file ...
      (perl.dbi.users)
    • Re: Padding using Type 4 Drivers
      ... |> value than what you have set in SQL Server 2000. ... |> settings that you require. ... |> Are you using the Microsoft JDBC driver or a third-party driver?. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: MsSQL DBD::ODBC IsNull and undef
      ... Martin J. Evans ... On 26-Jul-2005 Brian Becker wrote: ... > ensure you tell your driver the type of the column in bind_col. ... > I'd guess this is because the SQL Server ODBC driver is looking at your ...
      (perl.dbi.users)
    • Re: XA and 2000 backwards compatibility
      ... We haven't deployed the SQL2K XA driver either, so this should work for us. ... I am going through the documentation for the SQL Server driver. ... and enable XA transactions in MSDTC on the SQL Server ... Goto MSDTC tab on properties, click "Security Configuration" button, ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: [dbi] Re: MsSQL DBD::ODBC IsNull and undef
      ... ensure you tell your driver the type of the column in bind_col. ... To: Brian Becker ... I'd guess this is because the SQL Server ODBC driver is looking at your ... Martin J. Evans ...
      (perl.dbi.users)
    Loading