SQL in getCatalogs method cause JDBC pause 30 seconds

[be-happy4]

Describe the bug

When I use DBeaver to connect to ClickHouse, I found that it is very slow to open the connection.
After some debugging, I found that a SQL in the getCatalogs method never gets a response and hangs for 30 seconds until it times out.

select concat('jdbc(''', name, ''')') as TABLE_CAT from jdbc('', 'SHOW DATASOURCES') order by name

This SQL wastes half a minute of my time once I use DBeaver to open a ClickHouse connection. Hope you can fix it.
Best wishes.

Steps to reproduce

Expected behavior

Don't waste time in getCatalogs method

Code example

Error log

Configuration

Environment

• Client version: clickhouse-jdbc:0.6.1
• Language version: java23
• OS: macOS/Windows

ClickHouse server

• ClickHouse Server version: 24.9.2.42
  

[chernser]

Fixed in new JDBC v2.