Unable to find property 'tables' on class: org.apache.shardingsphere.single.yaml.config.pojo.YamlSingleRuleConfiguration

[zhangheng0027]

Rules can be run when using sharding，
But there was an error using SINGLE

spring:
  datasource:
    driver-class-name: org.apache.shardingsphere.driver.ShardingSphereDriver
    url: jdbc:shardingsphere:classpath:sharding.yaml

sharding.yaml

dataSources:
  master:
    dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    jdbcUrl: jdbc:mysql://localhost:3406/oee?serverTimezone=GMT%2B8&characterEncoding=utf8&useSSL=true
    username: 
    password: 

rules:
  - !SINGLE
    tables:
      # MySQL 风格
      - master.* # 加载指定数据源中的全部单表
    defaultDataSource: master

dataSources:
  master:
    dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    jdbcUrl: jdbc:mysql://localhost:3406/oee?serverTimezone=GMT%2B8&characterEncoding=utf8&useSSL=true
    username: 
    password: 


rules:
  - !SHARDING
    tables:
      equipment_oee:
        actualDataNodes: master.equipment_oee
        tableStrategy:
          complex:
            shardingColumns: statistics_cycle,statistics_time,serial_no
            shardingAlgorithmName: oeecyclealgorithmsharding

    shardingAlgorithms:
      oeecyclealgorithmsharding:
        type: CLASS_BASED
        props:
          strategy: complex
          algorithmClassName: com.kstopa.dataServer.system.conf.sharding.OeeCycleAlgorithmSharding

[linghengqian]

• Please provide an example of git. This looks like it needs to confirm the SnakeYAML version.

[zhangheng0027]

• Please provide an example of git. This looks like it needs to confirm the SnakeYAML version.

https://github.com/zhangheng0027/testSharding.git
com.example.testsharding.TestShardingApplicationTests#test01

Error will be reported upon startup

[linghengqian]

• It looks like you didn't provide the SQL file, I rewrote your project directly using h2database. I don't see this error in linghengqian-scratches/testSharding@31549a8.

• First of all, SINGLE configuration single-table loading is a feature that has only been available since ShardingSphere 5.4.0. No 5.3.2 .

• Secondly, you have not configured any implementation for JAXB for Java EE 8, which is being documented in Add a description of the Jakarta EE namespace in the documentation for Spring Boot #28303 .

• I don't understand why your ./gradlew file has been tampered with Unix permissions. It looks like you copied the Gradle Wrapper file from another file system.

[linghengqian]

• I handled the strange use of algorithm classes extra in linghengqian-scratches/testSharding@32c0dea. In general, I didn't see a particular Error Log.

$ gradle clean test

> Task :compileJava
注: /home/linghengqian/TwinklingLiftWorks/git/public/testSharding/src/main/java/com/example/testsharding/OeeCycleAlgorithmSharding.java使用了未经检查或不安全的操作。
注: 有关详细信息, 请使用 -Xlint:unchecked 重新编译。
OpenJDK 64-Bit Server VM warning: Sharing is only supported for boot loader classes because bootstrap classpath has been appended
2023-09-02T13:12:14.914+08:00  INFO 30345 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2023-09-02T13:12:14.920+08:00  INFO 30345 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.

Deprecated Gradle features were used in this build, making it incompatible with Gradle 9.0.

You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.

For more on this, please refer to https://docs.gradle.org/8.3/userguide/command_line_interface.html#sec:command_line_warnings in the Gradle documentation.

BUILD SUCCESSFUL in 46s
5 actionable tasks: 5 executed

[zhangheng0027]

• 看来你没有提供SQL文件，我直接使用h2database重写了你的项目。我在linghengqian/testSharding@ 31549a8中没有看到这个错误。
• 首先，SINGLE配置单表加载是ShardingSphere 5.4.0之后才提供的功能。没有 5.3.2。
• 其次，您尚未为 Java EE 8 配置 JAXB 的任何实现，该实现记录在Spring Boot 文档中添加 Jakarta EE 命名空间的描述 #28303中。
• 我不明白为什么你的./gradlew文件被篡改了 Unix 权限。看起来您是从另一个文件系统复制了 Gradle Wrapper 文件。

Changing the version to 5.4.0 will work fine, thanks

[zhangheng0027]

• 看来你没有提供SQL文件，我直接使用h2database重写了你的项目。我在linghengqian/testSharding@ 31549a8中没有看到这个错误。
• 首先，SINGLE配置单表加载是ShardingSphere 5.4.0之后才提供的功能。没有 5.3.2。
• 其次，您尚未为 Java EE 8 配置 JAXB 的任何实现，该实现记录在Spring Boot 文档中添加 Jakarta EE 命名空间的描述 #28303中。
• 我不明白为什么你的./gradlew文件被篡改了 Unix 权限。看起来您是从另一个文件系统复制了 Gradle Wrapper 文件。

https://shardingsphere.apache.org/document/5.3.0/cn/overview/

I remember, the latest version of the document is not 5.4

[linghengqian]

I remember, the latest version of the document is not 5.4

• @zhangheng0027 The URL for the latest version of the documentation is always https://shardingsphere.apache.org/document/current/en/overview/ . Is there anything here that needs to be clarified via a PR?

[zhangheng0027]

我记得文档最新版本不是5.4

• @zhangheng0027最新版本文档的 URL 始终为https://shardingsphere.apache.org/document/current/en/overview/。这里有什么需要通过 PR 澄清的吗？

No, but I hope to know the current version accurately.
The document I was looking at was the latest version, but when I couldn't determine my specific version, I thought 5.3.2 was the latest version。

[linghengqian]

• @zhangheng0027 You can temporarily use https://shardingsphere.apache.org/document/5.4.0/en/overview/ .

• This seems to involve something like 5.3.2 shardingsphere-doc#733 .

• @Mouqiuyu Can you explain why the 5.4.0 Tag is not displayed?

[github-actions]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

[linghengqian]

• I'm late because I've been busy in recent months. Fixing this issue seems to only require dealing with one Hugo configuration file.