Failed to connect to clickhouse 20.8.3

[Rabbit-st]

Description

connection clickhouse 20.8.3.18 error report：SQL 错误 [22000]: Code: 115. DB::Exception: (transport error: 404)
Code: 115. DB::Exception: (transport error: 404)

DBeaver Version

Community Edition 20.8.3.18

Operating System

windows 10

Database and driver

Database name and version: Clickhouse 20.8.3.18
Driver name and version: com.clickhouse:clickhouse-jdbc:RELEASE > [0.7.2]

Steps to reproduce

No response

Additional context

dbeaver log:

SQL 错误 [22000]: Code: 115. DB::Exception: <Unreadable error message> (transport error: 404)
  Code: 115. DB::Exception: <Unreadable error message> (transport error: 404)

clickhouse server log:

2026.07.21 15:45:02.947997 [ 3038 ] {} <Trace> DynamicQueryHandler: Request URI: /?session_id=sess_2a524094-c76f-40e0-9974-966dc2259567&query_id=9af2fec9-dd29-43b0-b716-a2826e3052a5&compress=1&wait_end_of_query=0&async_insert=0
2026.07.21 15:45:02.948258 [ 3038 ] {} <Error> DynamicQueryHandler: Code: 115, e.displayText() = DB::Exception: Unknown setting async_insert, Stack trace (when copying this message, always include the lines below):

[davestokes]

@Rabbit-st Thank you for your report. We will investigate, but version 20.8.3.18 is past End-of-life status and drivers may not be available.

[chernser]

Good day, @Rabbit-st !

I'm from ClickHouse JDBC driver team.
Error 115 is about UNKNOWN_SETTING - it actually present in message: Unknown setting async_insert.
async_insert was introduced in ClickHouse 21.1.
You need to remove async_insert it from your config.

<Unreadable error message> is fixed in later versions - 0.9.1 ClickHouse/clickhouse-java#2511

[Rabbit-st]

Good day, @Rabbit-st !

I'm from ClickHouse JDBC driver team. Error 115 is about UNKNOWN_SETTING - it actually present in message: Unknown setting async_insert. async_insert was introduced in ClickHouse 21.1. You need to remove async_insert it from your config.

<Unreadable error message> is fixed in later versions - 0.9.1 ClickHouse/clickhouse-java#2511

There is no option to remove the async_insert configuration item. After reviewing the driver's update history, I found that the async_insert configuration was hardcoded in versions prior to 0.10.0-rc1. The hardcoding was removed in 0.10.0-rc1, so upgrading the driver to this version resolved the issue. https://github.com/ClickHouse/clickhouse-java/releases

[chernser]

@Rabbit-st
Thank you for explanation!
yes - async_insert was hardcoded in JDBC v2. But it was used by default after 0.8.0 version. That is why I have not mentioned it.
And yes - we have removed all hard-coded settings in 0.10.0-rc1.