clickhouse-java

clickhouse-java copied to clipboard

Date32 return ZonedDateTime rather then LocalDate strings

1

## Description Only `Date` clickhouse types are formatted and returned as local date strings. `Date32` is returned as LocalDateTime. See https://github.com/ClickHouse/clickhouse-java/blob/b46d249bc894709b9f68962917c56b021dee9652/client-v2/src/main/java/com/clickhouse/client/api/data_formats/internal/AbstractBinaryFormatReader.java#L334-L340 The fix for date was added in https://github.com/ClickHouse/clickhouse-java/pull/2062/files, not...

jaccozilla

If received NetException from ClickHouse in response body, it will be ignored and unrecognized

1

### Describe the bug The ClickHouse Java driver suppresses error messages that contain `DB::NetException` due to a hardcoded substring match for `DB::Exception`. In log we receiving Caused by: com.clickhouse.client.api.ServerException: Code:...

DNAlchemist

"Failed to read row" with JDBC v2 & `OUTPUT_FORMAT_BINARY_WRITE_JSON_AS_STRING`

1

## Description Following https://github.com/ClickHouse/clickhouse-java/issues/1833#issuecomment-2877872593 I was trying to play with `OUTPUT_FORMAT_BINARY_WRITE_JSON_AS_STRING` and hit a `Failed to read row` issue. I ended up reproducing the issue in a `src/test/java/com/clickhouse/jdbc/DataTypeTests.java` test: ###...

redox

Random exception while executing queries via JDBC driver

2

### Company or project name _No response_ ### Question Hi, I'm facing a problem that doesn't always occur and is therefore difficult to reproduce and resolve. Here is some key...

alessandrorimoldi

Insert Fails for Array(Tuple) in JDBC v2 (Worked in v1)

1

We previously encountered a similar issue ([#1862](https://github.com/ClickHouse/clickhouse-java/issues/1862)), and the suggested solution worked at that time. However, after migrating to jdbc-v2 (version 0.8.4), the same approach no longer works. Currently, we're...

aira-xite

getDatabaseMajorVersion throws SQLException: "Failed to retrieve server version."

1

The database metadata object is throwing exceptions when fetching the server version. ### Steps to reproduce 1. Spin up a fresh Clickhouse test container 2. Obtain a database connection to...

jeloba

### Describe your feedback ATM, it seems jdbc-v2 cannot properly convert the embedded array value returned from the getObject function to java.sql.array types. For example, if a query fetching data...

gfunc

Batch insert failed

2

### Company or project name _No response_ ### Question Why does the SQL in my XML file execute normally when inserted individually, but an error occurs when executed in batches,...

ducklikeeat

[jdbc-v2] DatabaseMetadata fails if server has a new type

2

## Description Stacktrace: ``` java.lang.IllegalArgumentException: Unknown data type: Time64 at com.clickhouse.data.ClickHouseDataType.of(ClickHouseDataType.java:460) at com.clickhouse.jdbc.metadata.DatabaseMetaDataTest.testGetTypeInfo(DatabaseMetaDataTest.java:234) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ``` This means that old client would not work with a new server even...

chernser

Clickhouse jdbc + client throwing Cannot invoke "java.net.Socket.setSoTimeout(int)" because "sock" is null

2

### Describe the bug Hi, I'm building a Spring Boot 3 + Java 21 app that connects to a ClickHouse instance running on another machine. I can successfully ping the...

Sameerlaag