Problem about jdbc driver's connection reset error on Windows 2003

Kun Niu

unread,

Oct 14, 2008, 9:53:01 PM10/14/08

to

Dear all,
My program works fine when SQL server 2000 sp3 was installed on Windows 2000
server.
But when we moved to Windows 2003 with SQL Server 2005 sp2 installed, we
often encounter the following error:
ava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection
reset
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 Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.rollbackTransaction(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.rollback(Unknown Source)
I wonder what might be the cause of the problem.
My netwrok connection is really good when the program runs.
Thanks in advance for any hints or suggestion.

joe.we...@gmail.com

unread,

Oct 15, 2008, 10:46:34 AM10/15/08

to

Hi. You'll have to check the DBMS error log. The exception
simply means the driver was surprised to find the DBMS
had closed the socket.

Jimmy Wu

unread,

Oct 15, 2008, 9:14:23 PM10/15/08

to

From the call stack, it looks like you are using the SQL Server 2000 JDBC
driver. You should upgrade to the new Microsoft SQL Server 2005 JDBC
driver when connecting to SQL Server 2005. The latest release is v1.2.
The driver can be found at http://msdn.microsoft.com/data/jdbc

Jimmy

Kun Niu

unread,

Oct 16, 2008, 3:47:00 AM10/16/08

to

Thank you for your reply.
Do you mean errorlog.txt provided by sql server?
We can't find any message which is related to the error.

Kun Niu

unread,

Oct 16, 2008, 3:52:01 AM10/16/08

to

Really appreciate your reply.
I'm sorry that I've made a mistake.
Sql server we use is Sql server 2000 with sp3.

Kun Niu

unread,

Oct 16, 2008, 3:51:01 AM10/16/08

to

I'm sorry that I've made a mistake.

Sql Server we installed on server2003 is Sql Server 2000 with sp3.

Evan T. Basalik (MSFT)

unread,

Nov 16, 2008, 3:58:25 PM11/16/08

to

If you are running on Windows 2003 SP2, this is likely a known issue with the Scalable Networking Pack (aka TCPChimney) or possibly a bad piece of
network hardware somewhere.

As Joe pointed out, that error means that the driver went to use the TCP/IP connection only to find out the TCP/IP connection was not there.

I would try applying http://support.microsoft.com/default.aspx?scid=kb;EN-US;948496. If that doesn't work, I would start looking at network traces to identify
the misbehaving piece of hardware.

Evan
--------------------
>Thread-Topic: Problem about jdbc driver's connection reset error on Windows 2003
>thread-index: AckvY+8d2BBME+6LTJ++wTaf3Iy8lQ==
>X-WBNR-Posting-Host: 207.46.193.207
>From: =?Utf-8?B?S3VuIE5pdQ==?= <Kun...@discussions.microsoft.com>
>References: <850C56B5-0D54-4A1A...@microsoft.com>
>Subject: RE: Problem about jdbc driver's connection reset error on Windows 2003
>Date: Thu, 16 Oct 2008 00:51:01 -0700
>Lines: 22
>Message-ID: <C8F82990-BEB3-404B...@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3119
>Newsgroups: microsoft.public.sqlserver.jdbcdriver
>Path: TK2MSFTNGHUB02.phx.gbl
>Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.jdbcdriver:595
>NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
>X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver

Evan T. Basalik
This posting is provided “AS IS” with no warranties, and confers no rights.