Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem about jdbc driver's connection reset error on Wind..

 
   Database Help (Home) -> JDBC Driver RSS
Next:  digital camera upgrade for mercurycyberpix S_555V  
Author Message
Kun Niu

External


Since: Oct 14, 2008
Posts: 5



(Msg. 1) Posted: Tue Oct 14, 2008 6:53 pm
Post subject: Problem about jdbc driver's connection reset error on Windows 2003
Archived from groups: microsoft>public>sqlserver>jdbcdriver (more info?)

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.

 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
joe.weinstein

External


Since: Feb 02, 2008
Posts: 15



(Msg. 2) Posted: Wed Oct 15, 2008 7:46 am
Post subject: Re: Problem about jdbc driver's connection reset error on Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
Jimmy Wu

External


Since: Dec 18, 2007
Posts: 7



(Msg. 3) Posted: Wed Oct 15, 2008 9:25 pm
Post subject: RE: Problem about jdbc driver's connection reset error on Windows 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
Kun Niu

External


Since: Oct 14, 2008
Posts: 5



(Msg. 4) Posted: Thu Oct 16, 2008 12:47 am
Post subject: Re: Problem about jdbc driver's connection reset error on Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

"joeNOSPAM@bea.com" wrote:

> 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.
>
 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
Kun Niu

External


Since: Oct 14, 2008
Posts: 5



(Msg. 5) Posted: Thu Oct 16, 2008 12:51 am
Post subject: RE: Problem about jdbc driver's connection reset error on Windows 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm sorry that I've made a mistake.
Sql Server we installed on server2003 is Sql Server 2000 with sp3.

"Kun Niu" wrote:

> 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.
 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
Kun Niu

External


Since: Oct 14, 2008
Posts: 5



(Msg. 6) Posted: Thu Oct 16, 2008 12:52 am
Post subject: RE: Problem about jdbc driver's connection reset error on Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

"Jimmy Wu" wrote:

> 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
>
>
 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
Evan T. Basalik (MSFT)

External


Since: Nov 21, 2006
Posts: 24



(Msg. 7) Posted: Sun Nov 16, 2008 4:25 pm
Post subject: RE: Problem about jdbc driver's connection reset error on Windows 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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==?=
>References:
>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:
>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
>
>I'm sorry that I've made a mistake.
>Sql Server we installed on server2003 is Sql Server 2000 with sp3.
>
>"Kun Niu" wrote:
>
>> 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.
>

Evan T. Basalik
This posting is provided “AS IS” with no warranties, and confers no rights.
 >> Stay informed about: Problem about jdbc driver's connection reset error on Wind.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
JDBC driver doesn't close socket event after connection.cl.. - Hi I have a Java application (on Red Hat Enterprise) that <font color=purple> ; 1) connects every 10 seconds to an MS/SQL database</font> <font color=purple> ; 2) attempts to get the metadata for a specific table</fo...

New JDBC 1.2 driver runs slower than JDBC 1.1 driver-- exp.. - I have some test programs I run which do repeated simple SQL Select and SQL update statements. These test programs consistently take 5 to 10% longer to run with the new JDBC 1.2 driver than they do with the JDBC 1.1 driver. Is this expected? I..

MDX and JDBC Driver - Hi all, Anybody know if it possible to connect to an as2000 database and run mdx queries using the microsoft jdbc drivers? thanks, Peter

Register JDBC Driver - I'm new to Java and writing a test program to connect to a SQL Server 2000 database. I read and follow the instruction in KB article # Q313100. I have modifed the Classpath statement to include the 3 jar files. How do I register the driver? In the...

JDBC driver has issues with VARCHAR(24) - All of my VARCHAR(24) columns are reported as size 7 from java.sql.DatabaseMetaData::getColumns. All other sizes from 1 to 49 report the correct COLUMN_SIZE. Any ideas? The following program shows the problem (using 1.2.2828.100 against SQL Server....
   Database Help (Home) -> JDBC Driver All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]