[GH-ISSUE #3971] ClickHouse jdbc driver should be updated to 0.9.4 #1355

New issue

Closed

opened 2026-03-07 21:02:47 +03:00 by kerem · 3 comments

kerem commented

2026-03-07 21:02:47 +03:00

Owner

Originally created by @linux-wizard on GitHub (Dec 9, 2025).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/3971

Is your feature request related to a problem? Please describe.
When enabling ClickHouse's query cache, we need to ensure set_overflow_mode is defined as throw in the session settings. However there is a bug in ClickHouse 0.8.5 which is overriding this setting by default thus breaking the ability to log and query ClickHouse. There are others issues with this driver too as shown in the following upstream issues:

Fortunately this has been fixed in newer versions of the ClickHouse driver as shown in the following PR ( StatementImpl which was merged in the version 0.9.3 of the ClickHouse JDBC driver: https://github.com/ClickHouse/clickhouse-java/releases/tag/v0.9.3

Describe the solution you'd like
Please upgrade the ClickHouse jdbc driver to at least 0.9.3 or 0.9.4

Describe alternatives you've considered
Alternatives are disabling query cache on ClickHouse side (which impact Analytics performances) or build a custom image of CLoudBeaver CE with the new driver as explained in https://github.com/dbeaver/cloudbeaver/wiki/Adding-new-database-drivers

Additional context
Errors when trying to log in with ClickHouse's query cache enabled

Originally created by @linux-wizard on GitHub (Dec 9, 2025). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/3971 **Is your feature request related to a problem? Please describe.** When enabling ClickHouse's [query cache](https://clickhouse.com/docs/operations/query-cache), we need to ensure `set_overflow_mode` is defined as `throw` in the session settings. However there is a bug in ClickHouse 0.8.5 which is overriding this setting by default thus breaking the ability to log and query ClickHouse. There are others issues with this driver too as shown in the following upstream issues: - [The ClickHouseHttpConnection overrides result_overflow_mode](https://github.com/ClickHouse/clickhouse-java/issues/1932) - [Fixed overriding max_result_rows settings](https://github.com/ClickHouse/clickhouse-java/pull/1934) - [setMaxRows() doesn't work when result_overflow_mode is readonly](https://github.com/ClickHouse/clickhouse-java/issues/2582) - [Error "Cannot modify 'result_overflow_mode' setting in readonly mode"](https://github.com/dbeaver/dbeaver/issues/38280) Fortunately this has been fixed in newer versions of the ClickHouse driver as shown in the following PR ( [StatementImpl](https://github.com/ClickHouse/clickhouse-java/pull/2591) which was merged in the version 0.9.3 of the ClickHouse JDBC driver: https://github.com/ClickHouse/clickhouse-java/releases/tag/v0.9.3 **Describe the solution you'd like** Please upgrade the ClickHouse jdbc driver to at least 0.9.3 or 0.9.4 **Describe alternatives you've considered** Alternatives are disabling query cache on ClickHouse side (which impact Analytics performances) or build a custom image of CLoudBeaver CE with the new driver as explained in https://github.com/dbeaver/cloudbeaver/wiki/Adding-new-database-drivers **Additional context** Errors when trying to log in with ClickHouse's query cache enabled <img width="721" height="152" alt="Image" src="https://github.com/user-attachments/assets/7ec7478b-24cc-499a-af17-73ef6e65ed5d" /> <img width="744" height="567" alt="Image" src="https://github.com/user-attachments/assets/8eeedb51-2542-4d32-bb4a-e2b6d6189b94" />

kerem

2026-03-07 21:02:47 +03:00

closed this issue
added the
x:clickhouse
label

kerem commented

2026-03-07 21:02:49 +03:00

Author

Owner

@EvgeniaBzzz commented on GitHub (Dec 10, 2025):

Hi @linux-wizard
Thank you for your request.
We plan to update the driver to 0.9.5, since there are several additional issues in the previous versions. So we are waiting for the update.
You can add the required version yourself using this instruction

@EvgeniaBzzz commented on GitHub (Dec 10, 2025): Hi @linux-wizard Thank you for your request. We plan to update the driver to 0.9.5, since there are several additional issues in the previous versions. So we are waiting for the update. You can add the required version yourself using [this instruction](https://github.com/dbeaver/cloudbeaver/wiki/Adding-new-database-drivers#adding-drivers-in-cloudbeaver-community-edition)

kerem commented

2026-03-07 21:02:49 +03:00

Author

Owner

@Destrolaric commented on GitHub (Dec 12, 2025):

@linux-wizard Hi, I was responsible for the update 0.9.4. Unfortunately, the driver broke backward compatibility with older database versions. So we are currently waiting for the 0.9.5 which contains the fixes for compatibility

@Destrolaric commented on GitHub (Dec 12, 2025): @linux-wizard Hi, I was responsible for the update 0.9.4. Unfortunately, the driver broke backward compatibility with older database versions. So we are currently waiting for the 0.9.5 which contains the fixes for compatibility

kerem commented

2026-03-07 21:02:49 +03:00

Author

Owner

@Destrolaric commented on GitHub (Dec 25, 2025):

Driver is updated to 0.9.5, closing the issue

@Destrolaric commented on GitHub (Dec 25, 2025): Driver is updated to 0.9.5, closing the issue

kerem referenced this issue

2026-03-07 21:08:58 +03:00

[PR #1355] [MERGED] CB-2962 get default auth model fix #2441