How to set a connection timeout on the MySQL JDBC driver?

Question

I'm seeing the JDBC MySQL driver consistently fail connection attempts to a stopped MySQL after 10 seconds, but I'd like to change that timeout.

I tried adding ?connectTimeout=2000&socketTimeout=2000 to the connection URI, but that didn't make a difference.

Is there a way to customize how long it takes for the Driver to return a timeout while connecting to MySQL?

score 16 · Accepted Answer · answered Mar 08 '17 at 06:30

I tried adding ?connectTimeout=2000&socketTimeout=2000 to the connection URI, but that didn't make a difference.

This is exactly how it's configured, eg

jdbc:mysql://aaa.bbb.ccc.rds.amazonaws.com:1234/hello?connectTimeout=5000&socketTimeout=30000

score 6 · Answer 2 · answered Jul 09 '21 at 14:34

If neither connectTimeout or socketTimeout helps you, you can try adding MAX_EXECUTION_TIME to sessionVariables in the URL:

jdbc:mysql://{host}:{port}/{database}?sessionVariables=MAX_EXECUTION_TIME=123456666

Query to verify:

SELECT @@max_execution_time

Expected output:

+--------------------+ 
|@@max_execution_time| 
+--------------------+ 
| 123456666          | 
+--------------------+

Johan Le Roux · Answer 3 · 2018-10-15T13:39:33.820

4

Adding this before you call getConnection.

...
DriverManager.setLoginTimeout(2);
DriverManager.getConnection(connectString);
...

Worked in my case.

edited Oct 15 '18 at 13:39

answered Oct 15 '18 at 13:33

Johan Le Roux

score 1 · Answer 4 · answered Jan 25 '14 at 13:31

1

You can set the connection timeout using this:

con.query('SET GLOBAL connect_timeout=2000')
con.query('SET GLOBAL wait_timeout=2000')
con.query('SET GLOBAL interactive_timeout=2000')

For more help see MySqlConnection

answered Jan 25 '14 at 13:31

ravibagul91

score -5 · Answer 5 · answered Jan 25 '14 at 13:13

-5

You can change the default value in MySQL configuration file (connect-timeout option in mysqld section) -

[mysqld]
connect-timeout=100

If this file is not accessible for you, then you can set this value using this statement -

SET GLOBAL connect_timeout=100;

answered Jan 25 '14 at 13:13

Salah

I am confused....isn't that a mysql daemon setting. What if you want the setting to be client side. ie. my client may not have settings from the daemon server, right? or am I getting this wrong? – Dean Hiller Mar 24 '16 at 12:39
This is the setting on the MySQL server. It's not going to have any affect on a client trying to connect to that server when it's stopped. – Adrian Baker Mar 08 '17 at 05:48

5 Answers5