[SOLVED] Vertica autocommit

[taidur]

Hi!

I just discovered Dbeaver and I'm currently testing it. It looks quite good but today I faced first problem. When I make connection to Vertica database and under driver settings set autocommit = false it still makes autocommit. When I make DML statement then COMMIT and ROLLBACK buttons are not active and when I make commit or rollback manually then I get

SQL Error [HY000]: [Vertica][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.
[Vertica][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.
[Vertica][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.
[Vertica][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.
[Vertica][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.

Is this a bug or am I doing something wrong?

[Serge]

Hello,

Default auto-commit flag value depends on connection type (Dev, Prod, QA, etc). You may configure it in preferences. There is no autocommit configuration in driver settings (if you set some driver specific connection property then it will be overwrited by DBeaver after connect).
Also you may change auto-commit state manually. In main toolbar (or main menu "Database") there is a Transaction Mode button which toggles commit state. Also you may change transaction isolation level with it.

Does it solve you problem?

thanks

[taidur]

Hi!

Yes, it solves the problem. Thank you for quick response.