How to set socket timeout in Dbeaver?

HyeontaeJu

i use dbeaver and testing query,,
but, the query time is over than 30000ms so the sql is rollbacked..
how to fix the timeout more than 30000ms in dbeaver??

Jim_Knicely

Maybe the "Keep-Alive" option is what you are lookiong for?

s_crossman

If you are using the latest DBeaver EE there are multiple keep-alive settings:
Right click on the connection in the nav pane and select Edit Connection
In that dialog there are various keep-alive and timeout settings as follows:

• Errors and Timeouts has the timeouts for connection open, connection close, and connection validation. It's in milliseconds.
• Connection Settings, SSH tab for SSH tunnel keep-alive interval and tunnel timeout. It is in milliseconds.
• Driver Manager Connection Properties allows adding a Vertica driver user property (connection property as listed in the Vertica docs). The only timeout one we have there is LoginTimeout. No keep alive property.

Spark

hi, could you please help on how to set connection timeout and query timeout in dbeaver for mysql?

s_crossman

@Spark Hi. We only support the DBeaver/Vertica integration. I took a quick look and in DBeaver under Database menu, Driver Manager, MY SQL, Edit, Driver Properties tab it shows "connectionTimeout=20000" so that seems to be exposed in the driver. I do not see a similar one for the query timeout. You may have to Google search or reach out to Microsoft for info. They do have a similar jdbc url to ours, so possibly they also accept parameters passed that way. I hope it helps

Spark

hi @s_crossman thank you, will check it out!