RE: BUG: JDBC connection disconnected, can't reconnect
- From: Marco <Marco@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 2 Jul 2008 00:11:01 -0700
Hi Evan,
thanks for your response. It's not the SQL server which needs power cycling
(it wasn't in Frank's post either). It's the webserver which has to be power
cycled in order to get the web application to work again.
I have some extra info on this matter:
we've replaced the MS JDBC driver with jTDS JDBC driver, however this makes
no difference at all.
thanks again!
"Evan T. Basalik (MSFT)" wrote:
Are you seeing the same symptoms (connect fine, lose connectivity, have to restart SQL Server to recover)? If so, I would encourage you to look at the.
database side. There is really nothing the driver can do that will take down SQL Server.
Evan
--------------------
Thread-Topic: BUG: JDBC connection disconnected, can't reconnect
thread-index: AcjXco8Pq53bZmYcTeqBht64HmY1Nw==
X-WBNR-Posting-Host: 207.46.19.197
From: =?Utf-8?B?TWFyY28=?= <Marco@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <E16DE076-5FDA-4DDB-9386-14F3CE2E1DFC@xxxxxxxxxxxxx>
Subject: RE: BUG: JDBC connection disconnected, can't reconnect
Date: Thu, 26 Jun 2008 02:54:00 -0700
Lines: 101
Message-ID: <73A2A143-BD20-4B76-8BAD-4C020E745B90@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.2992
Newsgroups: microsoft.public.sqlserver.jdbcdriver
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.jdbcdriver:533
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
Hi,
we have exacty the same problem. Our environment:
Windows 2003 Standard SP2
SQL 2005 Standard
Sun JDK 1.6
SQL JDBC 1.2
Help much appreciated!
Marco
"Frank Sommers" wrote:
Hi,
Our environment is:
Windows Server 2003, Service Pack 2
SQL Server Express 2005
SQLServer JDBC driver 1.2
Sun JDK 1.6 (we tried this on JDK 1.5 as well)
There is no virus protection software on the host, and no firewall is enabled.
Our problem is that the JDBC connection running on the localhost
periodically gets disconnected, and then we can't reconnect to the database
at all, unless we physically power cycle the server.
This is a very strange situation, and to illustrate, I created the following
command-line program:
public class DBTest {
public static void main(String[] arg) throws Exception {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn =
DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=datamart",
"username", "password");
System.out.println("Connected");
conn.close();
}
}
Essentially, this program verifies that a database connection can be made to
the SQL Server instance on the local host.
Executing this from the command line works the vast majority of the time.
However, once the Web application running on the same host encounters the
JDBC disconnection issue, executing this program from the command line
results in the following exception:
C:\Documents and Settings\frank>java -cp sqljdbc.jar;. DBTest
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException:
Software caused connect on abort: recv failed
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown
Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:7)
The relevant line seems to be:
Software caused connect on abort: recv failed
There is no way to obtain further access to the database, except by
power-cycling the machine. Shutting down and then re-starting the SQL Server
instance does not help, nor does restarting any individual process on the
server.
Something permanently disables connection to the database server, and only a
hard reset of the OS solves that problem.
Any suggestions would be most appreciated, as this is a serious,
mission-criticial problem for us right now.
Evan T. Basalik
This posting is provided “AS IS” with no warranties, and confers no rights.
- Follow-Ups:
- RE: BUG: JDBC connection disconnected, can't reconnect
- From: Evan T. Basalik (MSFT)
- RE: BUG: JDBC connection disconnected, can't reconnect
- References:
- RE: BUG: JDBC connection disconnected, can't reconnect
- From: Evan T. Basalik (MSFT)
- RE: BUG: JDBC connection disconnected, can't reconnect
- Prev by Date: RE: BUG: JDBC connection disconnected, can't reconnect
- Next by Date: Re: ResultSet.getTimestamp() truncating trailing zeros in milliseconds
- Previous by thread: RE: BUG: JDBC connection disconnected, can't reconnect
- Next by thread: RE: BUG: JDBC connection disconnected, can't reconnect
- Index(es):
Relevant Pages
|
