在用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)