Skip to content

DLL statement failures with the v2 of the JDBC driver #2398

@nickcodefresh

Description

@nickcodefresh

Description

We are in the process of upgrading our code to use the 0.8.x of library, up from 0.7.x. If we upgrade and continue to use the v1 of the driver (via adding clickhouse.jdbc.v1=true to the JDBC URL), everything is fine.

If we try to use v2 of the driver, our DLL commands seem to fail, with the Clickhouse library outputting errors to System.err.

For example this is the statement we're trying to execute in an integration test:

CREATE USER IF NOT EXISTS 'flyway' IDENTIFIED BY 'password'

then when the test runs the following is logged to the console:

line 1:7 no viable alternative at input 'CREATEUSER'
line 1:6 missing TABLE at 'USER'

It's like the driver is removing whitespaces from the commands, but also that the command is silently failing (except System.err output).

This happens to all our DLL statements. Any ideas?

Environment

  • Client version: 0.7.1-patch1 -> 0.8.6
  • Language version: 24
  • OS: Unix or MacOS

ClickHouse Server

  • ClickHouse Server version: 24.12.6

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions