Re: Kinda urgent Connection error messages

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

Date: Fri, 19 Nov 2004 09:52:30 -0800

Saran wrote:

> Hi Joe, As mentioned by John A. Davis, we are getting the following 3
> different error message at a random fashion
>
> [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
> [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
> [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket
> write error
>
> Our prodcut is web based Java application, our application is configured
> under Tomcat5 in one machine and the MS-SQL Server 2000 is running on another
> machine, both the machines are in the same network in intranet. Right now we
> are using MS-JDBC Driver SP2. The above listed errors occurring atlest 2 to 3
> times a day, otherwise the application works fine. I am still wondering why
> these error occurring in intranet based setup? any help on this appreciated.

Hi. I wish I could help you more, but I can tell you that from the JDBC
driver perspective, these are all unexpected problems the driver is suffering
when the raw TCP socket it is using to talk to the DBMS either dies or fails
to be created. I guarantee that the driver is making the socket the same way
each time, so every creation should work the same way, and once it's open,
it should just work until it's closed. This is a problem beyond the application
and driver. Do you hold JDBC connections open indefinitely, sometimes without using
them for a long time? Does the problem seem to occur right after a long idle
period? Maybe the DBMS has an idle connection timeout, and is closing your
connections out from under you. Also, if you do have a limit on the number of
DBMS connections you are allowed, how are you controlling the number of connections
you try to make.
Joe Weinstein at BEA

> "Joe Weinstein" wrote:
>
>
>>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: Best way to check oracle database server / services is alive using Java
    ... At the moment I just attempt to connect to the server IP using Socket ... and conclude the database is not running if connection timed out. ... and if you can't get a socket to the DBMS ... but all currently existing connections may be operating ...
    (comp.lang.java.databases)
  • Re: Problem about jdbc drivers connection reset error on Windows
    ... Do you mean errorlog.txt provided by sql server? ... simply means the driver was surprised to find the DBMS ... had closed the socket. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: System 6 six master display driver board
    ... connections between MPU board, display driver, driver and slave cables, and ... If you see dark stains between the pins, ... Vibration problem while you're playing game affecting digits could be due to ... bad connections between MPU and driver board- interruptions in the ...
    (rec.games.pinball)
  • Asus A8V-E Deluxe and USB ports not working proporly
    ... Cool & Quiet Utility v1.022 and AMD CPU Driver v1.2.2.0 in Windows. ... had it not been that I sometimes loose the connections to my mouse and ... the drive is connected through the front or the rear USB-ports. ...
    (alt.comp.periphs.mainboard.asus)
  • Re: RAC, the Listener and Weblogic
    ... be accessing via weblogic and we are working to connect the two using the JDBC thin driver. ... like the connections to failover to the remote oracle node with minimal ... (SERVER = DEDICATED) ... In a rac node failure situation, ...
    (comp.databases.oracle.server)
Loading