如何指定OBLoader加载oracle的驱动

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】OBLoader版本4.2, OB的版本3.2
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【问题现象及影响】

2023-05-16 09:37:25 [INFO] Load jdbc driver class: “org.mariadb.jdbc.Driver” finished
2023-05-16 09:37:25 [ERROR] create connection SQLException, url: jdbc:mysql://10.10.180.48:2883/stc?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&emulateUnsupportedPstmts=true&useServerPrepStmts=true, errorCode 1235, state 0A000 java.sql.SQLFeatureNotSupportedException: Could not connect to address=(host=10.10.180.48)(port=2883)(type=master) : (conn=735674) Oracle tenant for current client driver is not supported
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1701) ~[druid-1.2.16.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1786) ~[druid-1.2.16.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2910) ~[druid-1.2.16.jar:?]
Caused by: java.sql.SQLFeatureNotSupportedException: (conn=735674) Oracle tenant for current client driver is not supported
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
… 6 more

2023-05-16 09:37:25 [ERROR] create connection SQLException, url: jdbc:mysql://10.10.180.48:2883/stc?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&emulateUnsupportedPstmts=true&useServerPrepStmts=true, errorCode 1235, state 0A000 java.sql.SQLFeatureNotSupportedException: Could not connect to address=(host=10.10.180.48)(port=2883)(type=master) : (conn=735675) Oracle tenant for current client driver is not supported
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1701) ~[druid-1.2.16.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1786) ~[druid-1.2.16.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2910) ~[druid-1.2.16.jar:?]
Caused by: java.sql.SQLFeatureNotSupportedException: (conn=735675) Oracle tenant for current client driver is not supported
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
… 6 more

2023-05-16 09:37:25 [ERROR] Load failed! Error: Init connection key failed. Error: ConnectFailedException: Init DataSourceManager failed. Error: SQLFeatureNotSupportedException: (conn=735675) Oracle tenant for current client driver is not supported

不应该加载ob驱动吗?oracle租户应该也是ob驱动

但是它现在默认加载的maridb的驱动,不知道要怎么改掉

使用的导数工具的是企业版还是社区版的?另外使用的指令可以贴下么(注意脱敏)

社区

./obloader -h *** -P 2883 -u *** -p ‘’ --sys-user *** -c *** -t *** -D *** --csv --table '’ -f ***

  1. oceanbase 社区版:仅支持mysql模式,配套的工具也支持 mysql模式,没有oracle部分的能力。
  2. 我看observer版本使用的是3.2的企业版,如果是想支持3.2的oracle模式可以问下对接同学获取obloader企业版,企业版有对应的能力

好的,感谢