doris版本: 2.1.8
fe和be都已配置参数: jdbc_drivers_dir=${DORIS_HOME}/../jdbc_drivers/
已确认fe、be上jdbc驱动jar包是存在的,且权限没有问题。
创建jdbc catalog报错如下:
2025-03-24 10:27:47,377 WARN (mysql-nio-pool-12040|577293) [StmtExecutor.handleDdlStmt():2879] DDL statement(create catalog bdp PROPERTIES (
"type" = "jdbc",
"user" = "postgres",
"password" = "Passw0rd",
"jdbc_url" = "jdbc:postgresql://10.74.100.205:5433/zfbdp",
"driver_url" = "postgresql-42.5.1.jar",
"driver_classs" = "org.postgresql.Driver"
)) process failed.
org.apache.doris.datasource.jdbc.client.JdbcClientException: Failed to load driver class in either of HikariConfig class loader or Thread context classloader
at org.apache.doris.datasource.jdbc.client.JdbcClient.initializeDataSource(JdbcClient.java:146) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.jdbc.client.JdbcClient.(JdbcClient.java:115) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.jdbc.client.JdbcPostgreSQLClient.(JdbcPostgreSQLClient.java:28) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.jdbc.client.JdbcClient.createJdbcClient(JdbcClient.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.jdbc.JdbcExternalCatalog.initLocalObjectsImpl(JdbcExternalCatalog.java:244) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.jdbc.JdbcExternalCatalog.testJdbcConnection(JdbcExternalCatalog.java:331) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.jdbc.JdbcExternalCatalog.checkWhenCreating(JdbcExternalCatalog.java:282) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.CatalogFactory.createCatalog(CatalogFactory.java:151) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.CatalogFactory.createFromStmt(CatalogFactory.java:89) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.CatalogMgr.createCatalog(CatalogMgr.java:242) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.DdlExecutor.execute(DdlExecutor.java:361) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:2866) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:998) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:606) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:532) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:337) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:218) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:284) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:312) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:479) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_412]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_412]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_412]