RE: Connection Reset Error with SQLState() = 08S01
- From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
- Date: Tue, 28 Aug 2007 20:53:10 GMT
Wes,
What version of the Microsoft JDBC driver are you running? Also, can you post your full code? The stack trace in the MSDN posting doesn't seem to match
yours. Am I missing something here?
Evah
--------------------
Thread-Topic: Connection Reset Error with SQLState() = 08S01
thread-index: Acfl2ebCd9vu7bnXQLGGWo0+Y3X3Kw==
X-WBNR-Posting-Host: 209.78.47.227
From: =?Utf-8?B?V2VzIENsYXJr?= <WesClark@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <F0F1C794-A805-4370-ACA7-4F633C460104@xxxxxxxxxxxxx> <F574478C-1843-420F-95E5-D1D6F52D4382@xxxxxxxxxxxxx>
Subject: RE: Connection Reset Error with SQLState() = 08S01
Date: Thu, 23 Aug 2007 16:04:04 -0700
Lines: 44
Message-ID: <C7A101C8-BA90-4499-8CFA-95703A3A4A8C@xxxxxxxxxxxxx>
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.2826
Newsgroups: microsoft.public.sqlserver.jdbcdriver
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.jdbcdriver:266
NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
I have also posted this on the MSDN threads
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1761540&SiteID=1
"Wes Clark" wrote:
I fixed my problem connecting to the MSDN forums by clearing my browser
cache.
"Wes Clark" wrote:
The stack trace is
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.flush(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.endRequest(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown
Source)
This is happening during a performance stress test, and only happens very
sporadically: two or three times during a multi-hour test of several
simultaneous users pounding on the database. There are no events on the DB
server, and nothing in the SQL Server 2005 log. The Tomcat server is running
on Linux. We are using a commons-DBCP connection pool that validates the
connection on borrow with "select 1", so we know the connection is good when
we get it for the pool. The network error happens right after a prepare
statement, so the connection is working, and then breaks on the execute of
the prepared statement. The query is not a long running query. We've also
checked the network health and it looks fine. We start some background batch
jobs against the server before the errors start to occur.
We are pretty much out of ideas. There are some relevant threads we can see
by Googling this, but neither IE nor Firefox can get the msdn.forums,
complaining the URL will never complete or something, which can be caused by
not accepting cookies, but that's not the problem.
Evan T. Basalik
This posting is provided ?AS IS? with no warranties, and confers no rights.
.
- Follow-Ups:
- RE: Connection Reset Error with SQLState() = 08S01
- From: Wes Clark
- RE: Connection Reset Error with SQLState() = 08S01
- Prev by Date: Re: connection timeouts
- Next by Date: RE: Authorization Error Using 1.2 CTP Driver
- Previous by thread: Re: connection timeouts
- Next by thread: RE: Connection Reset Error with SQLState() = 08S01
- Index(es):
Relevant Pages
|
