DBeaver连oceandb时报错。求大佬指点原因。

在用DBeaver连ob数据库时:报ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase;check the manual that corresponds to your OceanBase version for the right syntax to use near ‘show’ at line 1
**的jdbc版本为: oceanbase-client.1.1.10.jar
--------------启动日志如下:
!MESSAGE ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘show’ at line 1

!SUBENTRY 1 org.jkiss.dbeaver.model 4 0 2022-08-25 21:00:47.809

!MESSAGE ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘show’ at line 1

!STACK 0

com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘show’ at line 1

at [java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native](http://java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native) Method)

at [java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown](http://java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown) Source)

at [java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown](http://java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown) Source)

at [java.base/java.lang.reflect.Constructor.newInstance(Unknown](http://java.base/java.lang.reflect.Constructor.newInstance(Unknown) Source)

at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)

at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)

at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)

at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)

at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)

at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)

at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)

at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2908)

at com.alipay.oceanbase.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1942)

at com.alipay.oceanbase.jdbc.PreparedStatement.execute(PreparedStatement.java:1231)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.execute(JDBCPreparedStatementImpl.java:261)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeStatement(JDBCPreparedStatementImpl.java:205)

at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCObjectCache.loadObjects(JDBCObjectCache.java:109)

at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCObjectCache.getAllObjects(JDBCObjectCache.java:73)

at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.initialize(MySQLDataSource.java:365)

at org.jkiss.dbeaver.ext.oceanbase.mysql.model.OceanbaseMySQLDataSource.initialize(OceanbaseMySQLDataSource.java:63)

at org.jkiss.dbeaver.registry.DataSourceDescriptor.openDataSource(DataSourceDescriptor.java:960)

at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(DataSourceDescriptor.java:887)

at org.jkiss.dbeaver.runtime.jobs.ConnectJob.run(ConnectJob.java:70)

at org.jkiss.dbeaver.runtime.jobs.ConnectionTestJob.run(ConnectionTestJob.java:103)

at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

看错误码是企业版OB的oracle模式?

dbeaver和社区版是可以链接的。

用的就是社区版。

是社区版dbraver连了企业版的OB,并且是企业版ob的oracle模式。
可以去看看dbeaver是否支持企业版ob的oracle模式

如果使用的是企业版的OceanBase,可以联系下你们的支持人员

终于搞明白了, 用OB的oracle模式的话, 在新建数据库连接时,不能直接用系统自带的,需要使用 oceanbase-client.1.1.10.jar新建一个连接。

嗯,ob自己实现的驱动,兼容了oracle模式。但是不能用oracle驱动连ob

我也遇到了同样的问题,不能使用 dbeaver自带的 oceanBase ? 为什么?如果不能用,他是干嘛的啊????? 。 另外,我自己新建驱动,然后可以使用了。但是系统默认提供的,不明白,为什么不能使用。。。。