dbeaver/cloudbeaver

Regarding Issue 2728 - autocommit

rlauti1980 opened this issue · 7 comments

rlauti1980 commented

I've tried to set the autocommit to false, for all our data connections, by adding the autocommit parameter to every connection, in the configuration/bootstrap section of data-sources.json.

"configuration": {
...
"bootstrap": {
"autocommit": false
}
}

This was what i noticed that changed, after deactivating it using the GUI. But it seems not all that needs to be done, because the autocommit is still active.
What else needs to be done?

Thank you!
René

EvgeniaBzzz commented

Hi @rlauti1980
That's enough to disable autocommit mode.
What exactly did you do to ensure that autocommit mode is still on?

If autocommit is disabled in connection settings, you'll see 3 buttons when open sql editor.
image

rlauti1980 commented

Hi Evgenia,

sorry for my late answer. I hadn't any time to go after this. Let me double check, what i have done in the config file and come back to you.

Thank you for your fast response!

EvgeniaBzzz commented

@rlauti1980
Also you can set commit mode in the connection settings via UI.
Expand Expert settings on the connection form and unmark 'Auto commit'.
image

rlauti1980 commented

I'm aware of that. When i unset the checkbox manually, this is actually working. But no one wants to do it for that many connections.
Following is an example of a connection in the script generated json file and it's end.
image

But the checkbox is still set in the GUI after deployment.

image

What am i missing?

EvgeniaBzzz commented

Please, use lower case for autocommit.

  • 👍1
rlauti1980 commented

Awsome! That was my mistake. Works now as expected.
Thank you very much!

EvgeniaBzzz commented

Great, thanks for the update 🦫