baomidou/dynamic-datasource

集成OceanBase报错

kinsey-jian opened this issue · 1 comments

Please fill it out carefully, or it will be closed.
请认真填写,不然会直接关闭。

Enviroment

JDK Version(required): 1.8

SpringBoot Version(required): 2.3

dynamic-datasource-spring-boot-starter Version(required):3.6.1

druid Version(optional): 1.1.23

Describe what happened

集成OceanBase时候发生报错
Expected Result:

Actual Result:

If there is an exception,or aop invalid,please attach the exception trace:

Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'RECOVER' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at com.mysql.cj.jdbc.StatementImpl.executeQuery$original$svb4JuB5(StatementImpl.java:1200) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at com.mysql.cj.jdbc.StatementImpl.executeQuery$original$svb4JuB5$accessor$HPHBRqXJ(StatementImpl.java) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at com.mysql.cj.jdbc.StatementImpl$auxiliary$QLEjjuiL.call(Unknown Source) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86) ~[skywalking-agent.jar:8.9.0]
	at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:168) ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
	... 165 more

Steps to reproduce

  • Step 1
    配置和传统的没区别

  • Step 2

  • Step 3

和我无关