Re: Kinda urgent Connection error messages

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 11/01/04 

Date: Mon, 01 Nov 2004 15:05:15 -0800

Hi John. Check the DBMS error log. I believe the DBMS is in trouble. The driver is just
finding out that the socket connection it sues to the DBMS is dieing.
Joe Weinstein at BEA

jdnospam@hevanet.com wrote:

> Websphere application for nurses license renewal application that hits our SQL Server 2000.
>
> This was the first error that we decided to stop and start the application:
> Unable to load SQL Server Data Driver driver.
> Unable to create database connection.
> [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
> com.obs.data.DataObjectException: [Microsoft][SQLServer 2000 Driver for JDBC]Err or establishing socket.
>
>
> This is the send stream of errors after we had thought we had solved the problem. This is kinda urgent because there are nurses out there waiting to get their licenses renewed and mad as heck:
>
> [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: Connection reset by peer
> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection res et by peer: Connection reset by peer
> 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.TDSRequest.processReply(Unknown
> Sour
> ce)
> at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType
> (Unknown Source)
> at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown S
> ource)
> at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown
> Source)
>
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Relevant Pages

  • Re: Kinda urgent Connection error messages
    ... I believe the DBMS is in trouble. ... finding out that the socket connection it sues to the DBMS is dieing. ... > Unable to load SQL Server Data Driver driver. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Java vs SQL Server float datatype limits
    ... table ischecked for data purity it will of course produce errors. ... double into a float column. ... corresponds correctly to the DBMS column. ... So I would have imagined that an SQL Server driver either handle the ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Dont do DDL with PreparedStatement with Oracle!
    ... The driver got the expected ... response packet from the DBMS, ... in fact OCI mark the DDL for re-parsing, ... no-op on subsequent execution. ...
    (comp.lang.java.databases)
  • Re: Kinda urgent Connection error messages
    ... driver perspective, these are all unexpected problems the driver is suffering ... I guarantee that the driver is making the socket the same way ... Do you hold JDBC connections open indefinitely, ... Maybe the DBMS has an idle connection timeout, ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: SMSC 91C111 / XScale Ethernet performance
    ... My experance with this driver ... ... hub from the network, to avoid other network traffic effecting the tests. ... the difference should be due to the activeSync overhead. ... good socket connection and for other preformance issues. ...
    (microsoft.public.windowsce.platbuilder)
Loading