RE: slow connections with jdbc driver and no entry in hosts file
From: Carb Simien [MSFT] (CarbinoS_at_online.microsoft.com)
Date: 09/21/04
- Next message: David S. Faller: "Re: Exception in xa_open with SqlServer 2000 SP3a on Win 2003"
- Previous message: Carb Simien [MSFT]: "RE: SQL Server SP3a via JDBC SP2"
- In reply to: david: "slow connections with jdbc driver and no entry in hosts file"
- Next in thread: david: "RE: slow connections with jdbc driver and no entry in hosts file"
- Reply: david: "RE: slow connections with jdbc driver and no entry in hosts file"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 18:05:45 GMT
--------------------
| Thread-Topic: slow connections with jdbc driver and no entry in hosts file
| thread-index: AcSXYCKci3cB2RhXRfepoRDASqdhLQ==
| X-WBNR-Posting-Host: 63.215.122.7
| From: "=?Utf-8?B?ZGF2aWQ=?=" <david@discussions.microsoft.com>
| Subject: slow connections with jdbc driver and no entry in hosts file
| Date: Fri, 10 Sep 2004 11:01:02 -0700
| Lines: 11
| Message-ID: <8E8497EB-2AC6-4ED5-9D34-1031446634A1@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.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6316
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| We have had a problem with connections taking 30+ seconds to our sql
server
| with sp1 and sp2 versions of the jdbc driver. It goes away if I put an
entry
| for the server in our local hosts file. We are not access by name, but
by ip
| (example jdbc url):
url=jdbc:microsoft:sqlserver://192.168.10.100:1433;DatabaseName=db1;SelectMe
thod=cursor
|
| We shouldn't have an entry (especially if it's using ip) in our hosts
file.
|
| Ideas?
|
| Thanks
|
Hi David,
Do you observe the same behavior when connecting to the server via IP using
Query Analyzer from the same client workstation? In other words, is this
specific to JDBC or not? Also, can you successfully resolve the host name
from the IP address by using "ping -a 192.168.10.100"? Does the same
behavior occur from other client machines? Be sure to run these tests with
the HOST entry removed.
JDBC SP3 is the latest driver, so you may want to consider this for future
development:
SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-
B138-2AA54BFDC03A&displaylang=en
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
- Next message: David S. Faller: "Re: Exception in xa_open with SqlServer 2000 SP3a on Win 2003"
- Previous message: Carb Simien [MSFT]: "RE: SQL Server SP3a via JDBC SP2"
- In reply to: david: "slow connections with jdbc driver and no entry in hosts file"
- Next in thread: david: "RE: slow connections with jdbc driver and no entry in hosts file"
- Reply: david: "RE: slow connections with jdbc driver and no entry in hosts file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
