在线等BI链接clickhouse数据源的配置方法

在线等永洪BI链接clickhouse数据源的配置方法

当前版本不支持直接连接clickhouse数据源，后续推出的94会支持。
当前只能使用GENERIC数据库实现，自定义上传自己的clickhouse驱动
https://www.yonghongtech.com/hel ... ighlightsub=generic

感谢解答，目前使用的75的版本，里面的GENERIC数据源链接的配置页面见附件图片，没有“自定义选择驱动”选项，是否可以把相应的clickhouse的jdbc驱动包手动上传到服务器的相应目录来实现？
目前尝试了将jar包clickhouse-jdbc-0.2.6.jar上传到YongHong75/Yonghong/jdbcDriver目录下，重启后没效果

永洪tech-zxx 发表于 2021-10-26 10:10
当前版本不支持直接连接clickhouse数据源，后续推出的94会支持。
当前只能使用GENERIC数据库实现，自定义上 ...

感谢解答，目前使用的75的版本，里面的GENERIC数据源链接的配置页面见附件图片，没有“自定义选择驱动”选项，是否可以把相应的clickhouse的jdbc驱动包手动上传到服务器的相应目录来实现？
目前尝试了将jar包clickhouse-jdbc-0.2.6.jar上传到YongHong75/Yonghong/jdbcDriver目录下，重启后没效果,是否目录放错了？

V8.5.0.X及之前的版本 将驱动放到 服务器安装目录\Yonghong\jdbcDriver\lib\jdbcDriver 路径下，将原来的驱动移走，放入新的驱动，重启服务生效

永洪tech-zxx 发表于 2021-10-26 10:25
V8.5.0.X及之前的版本 将驱动放到 服务器安装目录\Yonghong\jdbcDriver\lib\jdbcDriver 路径下，将原来的驱 ...

感谢回答!按照目录放置jar包重启后，再测试数据库连接报如图错误，请问是什么原因？

报错提示jar包不对出现了冲突 这个jar和你clickhouse版本是对应的吗

永洪tech-zxx 发表于 2021-10-26 10:43
报错提示jar包不对出现了冲突 这个jar和你clickhouse版本是对应的吗

感谢回答，jar包版本是对应的，用这个jar包编写Java测试类是可以正常连上clickhouse的

咱们这边之前验证75版本连接clickhouse是没有问题的，建议取日志分析一下

永洪tech-zxx 发表于 2021-10-26 11:26
咱们这边之前验证75版本连接clickhouse是没有问题的，建议取日志分析一下

取YongHong75/Yonghong/log/bi.log  实时操作错误日志信息如下：
Oct 26, 2021 11:39:43.309[SEVERE]TestQryReq.testConn: Could not initialize class org.apache.http.impl.conn.ManagedHttpClientConnectionFactory
java.lang.NoClassDefFoundError: Could not initialize class org.apache.http.impl.conn.ManagedHttpClientConnectionFactory
        at org.apache.http.impl.conn.PoolingHttpClientConnectionManager$InternalConnectionFactory.<init>(PoolingHttpClientConnectionManager.java:572)
        at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.<init>(PoolingHttpClientConnectionManager.java:174)
        at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.<init>(PoolingHttpClientConnectionManager.java:158)
        at ru.yandex.clickhouse.util.ClickHouseHttpClientBuilder.getConnectionManager(ClickHouseHttpClientBuilder.java:140)
        at ru.yandex.clickhouse.util.ClickHouseHttpClientBuilder.buildClient(ClickHouseHttpClientBuilder.java:71)
        at ru.yandex.clickhouse.ClickHouseConnectionImpl.<init>(ClickHouseConnectionImpl.java:76)
        at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:55)
        at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:47)
        at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:29)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at g5.qry.sql.impl.DefConnBuilder.build0(Unknown Source)
        at g5.qry.sql.impl.JDBCConnBuilder.build(Unknown Source)
        at g5.sv.qry.req.TestQryReq.testConn(Unknown Source)
        at g5.sv.qry.req.TestQryReq.process0(Unknown Source)
        at g5.sv.Req.process(Unknown Source)
        at g5.sv.qry.impl.QueryServiceImpl.process(Unknown Source)
        at g5.sv.qry.QueryProc.procReq(Unknown Source)
        at g5.sv.qry.QueryProc.service(Unknown Source)
        at g5.sv.ServletHelper.service(Unknown Source)
        at g5.sv.PortalServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
Oct 26, 2021 11:39:49.775[SEVERE]TestQryReq.testConn: Could not initialize class org.apache.http.impl.conn.ManagedHttpClientConnectionFactory
java.lang.NoClassDefFoundError: Could not initialize class org.apache.http.impl.conn.ManagedHttpClientConnectionFactory
        at org.apache.http.impl.conn.PoolingHttpClientConnectionManager$InternalConnectionFactory.<init>(PoolingHttpClientConnectionManager.java:572)
        at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.<init>(PoolingHttpClientConnectionManager.java:174)
        at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.<init>(PoolingHttpClientConnectionManager.java:158)
        at ru.yandex.clickhouse.util.ClickHouseHttpClientBuilder.getConnectionManager(ClickHouseHttpClientBuilder.java:140)
        at ru.yandex.clickhouse.util.ClickHouseHttpClientBuilder.buildClient(ClickHouseHttpClientBuilder.java:71)
        at ru.yandex.clickhouse.ClickHouseConnectionImpl.<init>(ClickHouseConnectionImpl.java:76)
        at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:55)
        at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:47)
        at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:29)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at g5.qry.sql.impl.DefConnBuilder.build0(Unknown Source)
        at g5.qry.sql.impl.JDBCConnBuilder.build(Unknown Source)
        at g5.sv.qry.req.TestQryReq.testConn(Unknown Source)
        at g5.sv.qry.req.TestQryReq.process0(Unknown Source)
        at g5.sv.Req.process(Unknown Source)
        at g5.sv.qry.impl.QueryServiceImpl.process(Unknown Source)
        at g5.sv.qry.QueryProc.procReq(Unknown Source)
        at g5.sv.qry.QueryProc.service(Unknown Source)
        at g5.sv.ServletHelper.service(Unknown Source)
        at g5.sv.PortalServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
Oct 26, 2021 11:39:50.391[INFO]Reporter.heartbeat: 172.17.232.42 starts to heartbeat at Tue Oct 26 11:39:50 CST 2021.
Oct 26, 2021 11:39:50.391[INFO]ReportSProc.proc0: Received 172.17.232.42 heartbeat request, starts to process at Tue Oct 26 11:39:50 CST 2021.
Oct 26, 2021 11:39:50.391[INFO]Reporter.heartbeat: 172.17.232.42 end of heartbeat, files: 0, length: 175, occupied: 0ms.