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.