search

ClickHouse / clickhouse-jdbc-bridge

A JDBC proxy from ClickHouse to external databases
Apache License 2.0
167 stars 60 forks source link

SEVERE: Failed to set property driverClassName on target class com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig java.lang.reflect.InvocationTargetException #167

Open peder1001 opened 1 year ago

peder1001 commented 1 year ago

I have an existing ClickHouse installation (recently installed on Thursday last week), self-hosted on Ubuntu 22.04. It has been working great, and today I wanted to start using the clickhouse-jdbc-bridge.

I followed the Java CLI instructions from https://github.com/ClickHouse/clickhouse-jdbc-bridge And when I run it, I get the following errors.

These errors happen, even when I add the password to ch-server.json. I tried again using localhost instead of ch-server as the host, but I still get the same errors. Any ideas what might be causing this?

java -jar clickhouse-jdbc-bridge-2.1.0-shaded.jar
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.Utils loadJsonFromFile
INFO: Loading JSON from file [config/vertx.json]...
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.Utils loadJsonFromFile
WARNING: Failed to load JSON from file config/vertx.json
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.Utils loadJsonFromFile
INFO: Loading JSON from file [config/server.json]...
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.Utils loadJsonFromFile
WARNING: Failed to load JSON from file config/server.json
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.JdbcBridgeVerticle registerConfigLoader
INFO: Start to monitor configuration file(s) at [config/datasources]
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.JdbcBridgeVerticle registerConfigLoader
INFO: Start to monitor configuration file(s) at [config/schemas]
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.JdbcBridgeVerticle registerConfigLoader
INFO: Start to monitor configuration file(s) at [config/queries]
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.BaseRepository registerType
INFO: Registering new type of NamedDataSource: [jdbc] -> [com.clickhouse.jdbcbridge.impl.JdbcDataSource]
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.BaseRepository registerType
INFO: Default type of NamedDataSource is set to [jdbc]
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.BaseRepository registerType
INFO: Registering new type of NamedDataSource: [script] -> [com.clickhouse.jdbcbridge.impl.ScriptDataSource]
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.Utils loadJsonFromFile
INFO: Loading JSON from file [config/httpd.json]...
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.Utils loadJsonFromFile
WARNING: Failed to load JSON from file config/httpd.json
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.JdbcBridgeVerticle startServer
INFO: Starting web server...
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.impl.JsonFileRepository reload
INFO: No NamedSchema configuration found
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.impl.JsonFileRepository reload
INFO: No NamedQuery configuration found
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.JdbcBridgeVerticle lambda$startServer$0
INFO: Server http://0.0.0.0:9019 started in 877 ms
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.impl.JsonFileRepository reload
INFO: Loading NamedDataSource configuration...
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.BaseRepository update
INFO: Adding NamedDataSource(id=ch-server)...
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig setDriverClassName
SEVERE: Failed to load driver class com.clickhouse.ClickHouseDriver from HikariConfig class classloader jdk.internal.loader.ClassLoaders$AppClassLoader@55054057
Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf setProperty
SEVERE: Failed to set property driverClassName on target class com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig
java.lang.reflect.InvocationTargetException
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:150)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:59)
        at java.base/java.util.concurrent.ConcurrentHashMap.forEach(ConcurrentHashMap.java:1603)
        at java.base/java.util.Properties.forEach(Properties.java:1446)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:54)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig.<init>(HikariConfig.java:135)
        at com.clickhouse.jdbcbridge.impl.JdbcDataSource.<init>(JdbcDataSource.java:439)
        at com.clickhouse.jdbcbridge.impl.JdbcDataSource.newInstance(JdbcDataSource.java:297)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at com.clickhouse.jdbcbridge.core.Extension.newInstance(Extension.java:224)
        at com.clickhouse.jdbcbridge.core.BaseRepository.createFromConfig(BaseRepository.java:97)
        at com.clickhouse.jdbcbridge.core.BaseRepository.update(BaseRepository.java:209)
        at com.clickhouse.jdbcbridge.impl.JsonFileRepository.reload(JsonFileRepository.java:95)
        at com.clickhouse.jdbcbridge.JdbcBridgeVerticle.lambda$null$5(JdbcBridgeVerticle.java:594)
        at com.clickhouse.jdbcbridge.internal.vertx.core.impl.ContextImpl.lambda$executeBlocking$2(ContextImpl.java:313)
        at com.clickhouse.jdbcbridge.internal.vertx.core.impl.TaskQueue.run(TaskQueue.java:76)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at com.clickhouse.jdbcbridge.internal.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.RuntimeException: Failed to load driver class com.clickhouse.ClickHouseDriver in either of HikariConfig class loader or Thread context classloader
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig.setDriverClassName(HikariConfig.java:486)
        ... 27 more

Dec 12, 2022 10:47:04 AM com.clickhouse.jdbcbridge.core.BaseRepository update
WARNING: Failed to add NamedDataSource(id=ch-server)
java.lang.IllegalStateException: Failed to create instance from extension: class com.clickhouse.jdbcbridge.impl.JdbcDataSource
        at com.clickhouse.jdbcbridge.core.Extension.newInstance(Extension.java:227)
        at com.clickhouse.jdbcbridge.core.BaseRepository.createFromConfig(BaseRepository.java:97)
        at com.clickhouse.jdbcbridge.core.BaseRepository.update(BaseRepository.java:209)
        at com.clickhouse.jdbcbridge.impl.JsonFileRepository.reload(JsonFileRepository.java:95)
        at com.clickhouse.jdbcbridge.JdbcBridgeVerticle.lambda$null$5(JdbcBridgeVerticle.java:594)
        at com.clickhouse.jdbcbridge.internal.vertx.core.impl.ContextImpl.lambda$executeBlocking$2(ContextImpl.java:313)
        at com.clickhouse.jdbcbridge.internal.vertx.core.impl.TaskQueue.run(TaskQueue.java:76)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at com.clickhouse.jdbcbridge.internal.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:165)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:59)
        at java.base/java.util.concurrent.ConcurrentHashMap.forEach(ConcurrentHashMap.java:1603)
        at java.base/java.util.Properties.forEach(Properties.java:1446)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:54)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig.<init>(HikariConfig.java:135)
        at com.clickhouse.jdbcbridge.impl.JdbcDataSource.<init>(JdbcDataSource.java:439)
        at com.clickhouse.jdbcbridge.impl.JdbcDataSource.newInstance(JdbcDataSource.java:297)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at com.clickhouse.jdbcbridge.core.Extension.newInstance(Extension.java:224)
        ... 10 more
Caused by: java.lang.reflect.InvocationTargetException
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:150)
        ... 22 more
Caused by: java.lang.RuntimeException: Failed to load driver class com.clickhouse.ClickHouseDriver in either of HikariConfig class loader or Thread context classloader
        at com.clickhouse.jdbcbridge.internal.zaxxer.hikari.HikariConfig.setDriverClassName(HikariConfig.java:486)
        ... 27 more