SQLServer 2000 Driver for JDBC behaviour on SQL Server restart

From: gp (parcha_at_gmail.com)
Date: 02/23/05 

Date: 22 Feb 2005 15:29:30 -0800

1) My java code properly connects to the SQL Server DB via the SQL
Server 2000 JDBC driver.
2) During one of our stress tests, we restarted the SQL Server to see
how the code handles it.
3) My code doesn't really recognize that the SQL server is up and my
calls to DB fail throwing the following exception
(Note: I have tried this on Oracle 9i and it works properly. i.e my
code is able to read from Oracle DB on db restart.)

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Broken pipe
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown
Source)
        at
com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
Source)
        at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
Source)

Any help would be appreciated.

Relevant Pages

  • RE: Reason Code 0x3006 ; Server restarting
    ... Does SQL Server often restart automatically or does it restart only ... Do you point to the SQL Server service ... Microsoft Partner Online Support ... Reason Code 0x3006; ...
    (microsoft.public.windows.server.migration)
  • Re: SQL Server statistics Counter
    ... I didn't have the chance to restart the sql server until now, ... So i will try check the error log after restarting the sql server on weekend ... > anything monitoring the counters when you restart. ... >> Threads, Max Worker Threads, Network Threads, Max Network Threads ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL server connection problem
    ... You can do that going to SQL Server Configuration Manager and go to ... changing Maximum concurrent connections value. ... found the error message was no more active for a long period before it ... The following message appears when restart the server and before login ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL server connection problem
    ... I could suggest you to connect to your SQL Server in a Single-User mode ... changing Maximum concurrent connections value. ... The following message appears when restart the server and before ... I receive Error message: ...
    (microsoft.public.sqlserver.clients)
  • Re: Parameters after "FROM" & "DROP"
    ... Have you upgraed to SQL Server SP3a? ... How about trying a restart ... It is highly recommand if you could make all latest service pack done on you box, ...
    (microsoft.public.sqlserver.dts)