Re: JDBC Driver: Connection reset by peer: socket write error

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


Date: Fri, 12 Nov 2004 09:13:09 -0800


chrissy wrote:

> Joe Weinstein <joeNOSPAM@bea.com> wrote in message news:<u#FxJRAyEHA.352@TK2MSFTNGP14.phx.gbl>...
>
>>Yes. Either your network broke the socket between the driver
>>and the DBMS, or the DBMS had a failure which required it to
>>terminate the connection abruptly. Check the DBMS error log to
>>see if there are any messages about having to kill a session.
>>Joe Weinstein at BEA
>
>
> The DBMS has no errors in the log. In fact - when the error occurrs, I
> can connect to SQL with no problem, execute queries, etc but nothing
> via JDBC will work. I reboot the server that hosts both JDBC & the SQL
> server and no more errors. Is this possibly a user/session limit that
> we are hitting? Any way to trace exactly what happens?

Very odd. It sounds like something odd with the network... When this happens,
can you *connect* via JDBC? Ie: the failure you showed was with a connection
that was already made... How many users do you have logged in via jdbc when this
happens?
Joe



Relevant Pages

  • Re: [Info-Ingres] jdbc caches prepared statements?
    ... [Info-Ingres] jdbc caches prepared statements? ... the JDBC driver needs to follow the DBMS here. ... For the DBMS, in theory I would agree, but it turned out that changing ...
    (comp.databases.ingres)
  • Re: Microsoft Access Database with Java.
    ... If you want to use a database, you'll need DBMS ... >>functionality of Microsoft Access in a JDBC driver any time soon. ... the "design" view of the table to find out what the real column names ...
    (comp.lang.java.databases)
  • Re: Microsoft Access Database with Java.
    ... > Fabian Rossbacher wrote: ... If you want to use a database, you'll need DBMS ... > functionality of Microsoft Access in a JDBC driver any time soon. ...
    (comp.lang.java.databases)
  • Re: JDBC Competitors?
    ... > is JDBC pretty mcuh the standard that everyone uses? ... the protocol to talk to a DBMS is proprietary to the DBMS. ... This API is used by type-2 JDBC ...
    (comp.lang.java.databases)
  • Re: Does JDBC support compressed data communication
    ... That's outside the standard JDBC interface. ... It depends entirely on the individual JDBC ... driver and DBMS backend. ... * The Ultimate DBMS is here! ...
    (comp.lang.java.databases)