为了更快的定位您的问题，请提供以下信息，谢谢
starrocks2.5.4执行
create external resource jdbc0
properties (
“type” = “jdbc”,
“user” = “xxxxx”,
“password” = “xxxxxxx”,
“jdbc_uri” = “jdbc:oracle:thin:@x.x.x.x:1521:enginedb”,
“driver_url” = “file:///opt/StarRocks-1.19.1/lib/jdbc_drivers/ojdbc14-10.2.0.4.0.jar”,
“driver_class” = “oracle.jdbc.driver.OracleDriver”
);
create external table check_info
(
bizno VARCHAR(50) not null,
invoicecode VARCHAR(50) not null,
invoicenumber VARCHAR(50) not null,
deal_time DATETIME,
projname VARCHAR(50),
source VARCHAR(50),
totalcount DECIMAL(22,0),
billingdate VARCHAR(50),
checkcode VARCHAR(20),
salestaxno VARCHAR(50),
totalamount DECIMAL(22,2),
resultstatus DECIMAL(5,0),
resultvalue VARCHAR(50)
) ENGINE=jdbc
properties (
“resource” = “jdbc0”,
“table” = “haiertpd.check_info”
);
上述外部表创建后执行如下查询
select * from check_info limit 10;
报错如下：
2023-10-17 16:39:59,692 WARN (starrocks-mysql-nio-pool-102383|4275637) [Coordinator.getNext():1545] get next fail, need cancel. status errorCode INTERNAL_ERROR open JDBCScanner failed, error: java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.isValid(I)Z[com.zaxxer.hikari.pool.PoolBase.checkValidationSupport(PoolBase.java:458), com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:441), com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:410), com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:363), com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206), com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477), com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560), com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115), com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:81), com.starrocks.jdbcbridge.JDBCScanner.lambda$open$0(JDBCScanner.java:44), com.starrocks.jdbcbridge.DataSourceCache.lambda$getSource$0(DataSourceCache.java:21), java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660), com.starrocks.jdbcbridge.DataSourceCache.getSource(DataSourceCache.java:21), com.starrocks.jdbcbridge.JDBCScanner.open(JDBCScanner.java:35)], query id: c1c42495-6cc8-11ee-a6fd-024241330015
2023-10-17 16:39:59,693 WARN (starrocks-mysql-nio-pool-102383|4275637) [Coordinator.updateStatus():1525] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: c1c42495-6cc8-11ee-a6fd-024241330015, instance id: NaN
2023-10-17 16:39:59,693 WARN (starrocks-mysql-nio-pool-102383|4275637) [Coordinator.getNext():1566] query failed: open JDBCScanner failed, error: java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.isValid(I)Z[com.zaxxer.hikari.pool.PoolBase.checkValidationSupport(PoolBase.java:458), com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:441), com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:410), com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:363), com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206), com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477), com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560), com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115), com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:81), com.starrocks.jdbcbridge.JDBCScanner.lambda$open$0(JDBCScanner.java:44), com.starrocks.jdbcbridge.DataSourceCache.lambda$getSource$0(DataSourceCache.java:21), java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660), com.starrocks.jdbcbridge.DataSourceCache.getSource(DataSourceCache.java:21), com.starrocks.jdbcbridge.JDBCScanner.open(JDBCScanner.java:35)]