Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to set socket timeout in Dbeaver?

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??

Answers

  • Jim_KnicelyJim_Knicely Administrator
    edited January 7

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

  • 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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.