baomidou / dynamic-datasource

dynamic datasource for springboot 多数据源 动态数据源 主从分离 读写分离 分布式事务
https://www.kancloud.cn/tracy5546/dynamic-datasource/2264611
Apache License 2.0
4.76k stars 1.2k forks source link

集成OceanBase报错 #650

Closed kinsey-jian closed 4 months ago

kinsey-jian commented 5 months ago

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

huayanYu commented 4 months ago

和我无关