Monday, 19 March 2012

Connect time very slow

Hi,
I've been using the sql server jdbc driver for quite a while. Out of the
blue my connect times are huge, 15-25 seconds. I've written the following
test code:
System.out.println("connecting");
Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
Connection con =
DriverManager.getConnection("jdbc:microsoft:sqlser ver://devserver1:1433;Data
baseName=eipp0053","sa","password");
System.out.println("connected");
I thought it may have something to do with network stuf, but if I run query
analyser or similar it connects straight through no problems. Anyone got
any ideas?
Chris.
"Chris Warr" <cwarr@.--no-spam--.labyrinth.net.au> wrote in message
news:1086133910.48572@.proxy.nec.com.au...
> Hi,
> I've been using the sql server jdbc driver for quite a while. Out of the
> blue my connect times are huge, 15-25 seconds. I've written the following
> test code:
> System.out.println("connecting");
> Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
> Connection con =
>
DriverManager.getConnection("jdbc:microsoft:sqlser ver://devserver1:1433;Data
> baseName=eipp0053","sa","password");
> System.out.println("connected");
> I thought it may have something to do with network stuf, but if I run
query
> analyser or similar it connects straight through no problems. Anyone got
> any ideas?
> Chris.
>
Forgot to mention, my enviroment is:
Windows 2000 server Talking to Sql Server 2000
Sun Java 1.3.1_04
|||> >[vbcol=seagreen]
> query
got
> Forgot to mention, my enviroment is:
> Windows 2000 server Talking to Sql Server 2000
> Sun Java 1.3.1_04
>
Never mind, I've discovered the wonderful jtds driver, converted my code
over in no time and the connection is instantanious. Goodbye MS driver.
Chris.

No comments:

Post a Comment