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??
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:
hi, could you please help on how to set connection timeout and query timeout in dbeaver for mysql?
@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
hi @s_crossman thank you, will check it out!