Cannot connect via JDBC (impacting AirByte and Metabase integration) about proton-java-driver HOT 8 CLOSED

Root cause is the com.clickhouse.jdbc.ClickhouseDrver will call this SQL as part of the connection setup. We need to change the SQL

from proton-java-driver.

Pls change the SQL during JDBC connection setup. This blocks other Java based integration.

I can update the code if you can advise what SQL to change

from proton-java-driver.

I am going to fix the JDBC driver myself.

A working SQL can be

select 'default' as currentUser, timezone(), version(),if_null((select to_uint8(value) from system.settings where name='readonly'),0) as readonly

from proton-java-driver.

After changing the SQL and I got the other error for Nullable

Exception in thread "main" java.lang.ExceptionInInitializerError
at com.clickhouse.client.http.ClickHouseHttpClient.postRequest(ClickHouseHttpClient.java:90)
at com.clickhouse.client.http.ClickHouseHttpClient.execute(ClickHouseHttpClient.java:114)
at com.clickhouse.client.ClickHouseRequest.execute(ClickHouseRequest.java:1385)
at com.clickhouse.jdbc.internal.ClickHouseConnectionImpl.getServerInfo(ClickHouseConnectionImpl.java:78)
at com.clickhouse.jdbc.internal.ClickHouseConnectionImpl.(ClickHouseConnectionImpl.java:245)
at com.clickhouse.jdbc.internal.ClickHouseConnectionImpl.(ClickHouseConnectionImpl.java:213)
at com.clickhouse.jdbc.ClickHouseDriver.connect(ClickHouseDriver.java:145)
at com.clickhouse.jdbc.ClickHouseDriver.connect(ClickHouseDriver.java:41)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:683)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:230)
at test_jdbc_driver.App.dropAndCreateTable(App.java:17)
at test_jdbc_driver.App.main(App.java:85)
Caused by: java.lang.IllegalArgumentException: Unknown data type: Nullable
at com.clickhouse.client.ClickHouseDataType.of(ClickHouseDataType.java:186)
at com.clickhouse.client.ClickHouseColumn.readColumn(ClickHouseColumn.java:342)
at com.clickhouse.client.ClickHouseColumn.of(ClickHouseColumn.java:388)
at com.clickhouse.client.data.ClickHouseStreamResponse.(ClickHouseStreamResponse.java:30)

from proton-java-driver.

further changed Nullable and I got "java.sql.SQLFeatureNotSupportedException: Sorry this driver only supports ClickHouse server 20.7 or above"

Then I changed the version to 21

The JDBC connection can be setup but running select * from table(car_live_data) limit 10 failed with

Apr. 05, 2022 10:51:34 P.M. com.clickhouse.client.data.ClickHouseStreamResponse
SEVERE: Failed to create stream response, closing input stream
java.sql.SQLException: Reached end of input stream after reading 28 of 46 bytes, server ClickHouseNode(addr=http:localhost/:8123, db=default)@-966655878
at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:55)
at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:70)
at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.getLastResponse(ClickHouseStatementImpl.java:81)
at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:268)
at test_jdbc_driver.App.query(App.java:19)
at test_jdbc_driver.App.main(App.java:35)
Caused by: java.io.IOException: Reached end of input stream after reading 28 of 46 bytes
at com.clickhouse.client.ClickHouseInputStream.readBytes(ClickHouseInputStream.java:683)
at com.clickhouse.client.data.ClickHouseLZ4InputStream.read(ClickHouseLZ4InputStream.java:207)
at com.clickhouse.client.ClickHouseInputStream.readString(ClickHouseInputStream.java:724)
at com.clickhouse.client.ClickHouseInputStream.readUnicodeString(ClickHouseInputStream.java:761)
at com.clickhouse.client.data.ClickHouseRowBinaryProcessor.readColumns(ClickHouseRowBinaryProcessor.java:572)
at com.clickhouse.client.ClickHouseDataProcessor.(ClickHouseDataProcessor.java:96)
at com.clickhouse.client.data.ClickHouseRowBinaryProcessor.(ClickHouseRowBinaryProcessor.java:586)
at com.clickhouse.client.ClickHouseDataStreamFactory.getProcessor(ClickHouseDataStreamFactory.java:47)
at com.clickhouse.client.data.ClickHouseStreamResponse.(ClickHouseStreamResponse.java:77)
at com.clickhouse.client.data.ClickHouseStreamResponse.of(ClickHouseStreamResponse.java:54)
at com.clickhouse.client.http.ClickHouseHttpClient.postRequest(ClickHouseHttpClient.java:90)
at com.clickhouse.client.http.ClickHouseHttpClient.execute(ClickHouseHttpClient.java:114)
at com.clickhouse.client.ClickHouseRequest.execute(ClickHouseRequest.java:1385)
at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.getLastResponse(ClickHouseStatementImpl.java:76)

Event select 1 failed

from proton-java-driver.

Update: Ken fixed the proton and also patches the JDBC driver. I added one more change and now pure JDBC is okay, and dbeaver is okay. But airbyte is blocked with other reasons

DBeaver UI

from proton-java-driver.

JDBC driver is basically. However I still cannot make the airbyte connector working.

• the airbyte destination (send data to timeplus), will create temp table, then insert to the temp table, then insert into .. as select, then drop the temp table. For example reason, no data is inserted. Need to check whether JDBC issue or my connector code issue
• airbyte source (read from timeplus), hang when loading schema

but I will close this ticket

from proton-java-driver.

(Jove Github Bot) moved this ticket out of the GitHub project(up to 1200 tickets for one project).

from proton-java-driver.