【已解决】oracle catalog 可以创建成功,但是查询时报错:[HY000][1105] failed to get database name list from jdbc

Viewed 39

doris version:2.0.3

oracle version:11g,12C

jar: ojdbc8-19.23.0.0.jar

create catalog sql:

CREATE CATALOG oracle PROPERTIES (
"type"="jdbc",
"user"="",
"password"="",
"jdbc_url" = "jdbc:oracle:thin:@ip:1521:ERP",
"driver_url" = "ojdbc8-19.23.0.0.jar",
"driver_class" = "oracle.jdbc.driver.OracleDriver"
);

postgres,clickhouse catalog是可以正常使用的

更新

找到问题了,odbc8.jar 的版本不对,更换版本后就可以了

1 Answers

在fe.log 中找一下具体详细的堆栈贴一下哈