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.
Showing posts with label huge. Show all posts
Showing posts with label huge. Show all posts
Monday, 19 March 2012
Subscribe to:
Posts (Atom)