RE: slow connections with jdbc driver and no entry in hosts file
From: david (david_at_discussions.microsoft.com)
Date: 09/23/04
- Previous message: cheers: "Unhandled token type:COLINFO"
- In reply to: Carb Simien [MSFT]: "RE: slow connections with jdbc driver and no entry in hosts file"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 23 Sep 2004 07:33:05 -0700
Thanks for the response.
Unfortunately dns is not used here, so ping -a returns only the ip address.
Query Analyzer returns instantly and works fine. It does happen on multiple
client (xp) and W2K servers.
I tried with the sp3 driver and the same speed issue occurs. We are going
to do additional testing to find out the exact JDBC code that is hanging.
I'll post back with additonal findings.
Thanks.
David
""Carb Simien [MSFT]"" wrote:
>
> | 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.
>
>
- Previous message: cheers: "Unhandled token type:COLINFO"
- In reply to: Carb Simien [MSFT]: "RE: slow connections with jdbc driver and no entry in hosts file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
