try mysql login,jdbc mysql loginTimeout不能正常工作

Can someone please explain why the following program timeout after 3 seconds where as I set it to do so after

12 seconds. I deliberately turned off mysql server to test this scenario where mysql server is unreachable.

import java.sql.Connection;

import java.sql.DriverManager;

/**

*

* @author dhd

*/

public class TestMysql {

static Thread trd;

public static void main(String[] argv) {

keepTrack();

try {

DriverManager.setLoginTimeout(12);

Class.forName("com.mysql.jdbc.Driver");

Connection c = DriverManager.getConnection("jdbc:mysql://localhost:3306/driving", "root", "");

} catch (Exception ex) {

System.err.println(ex.getMessage());

trd.stop();

}

}

public static void keepTrack() {

trd = new Thread(new Runnable() {

@Override

public void run() {

int i = 1;

while (true) {

System.out.println(i);

try {

Thread.sleep(1000);

} catch (Exception ex) {

}

i++;

}

}

});

trd.start();

}

}

The output is:

run:

1

2

3

Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

BUILD SUCCESSFUL (total time: 3 seconds).

Run from netbeans. Before asking why i need this please answer first please. Thanks

解决方案

If the MySQL server is not running the connection does not time out; the operating system replies with a "connection refused" error immediately. To make the connection time out one thing you can do is configure a fire wall to drop all packets arriving to the MySQL port.