Encounter error "org.apache.shardingsphere.infra.exception.kernel.metadata.TableNotFoundException: Table or view '%s' does not exist" with Read-Write Splitting about shardingsphere HOT 5 CLOSED

Hi @jonaskahn @airh2o, you can try config single rule to load related table metadata. For more details, you can refer this doc - https://shardingsphere.apache.org/document/current/cn/faq/#%E5%8D%95%E8%A1%A8-table-or-view-s-does-not-exist-%E5%BC%82%E5%B8%B8%E5%A6%82%E4%BD%95%E8%A7%A3%E5%86%B3.

from shardingsphere.

so do i

from shardingsphere.

I'll try in next week

from shardingsphere.

"I'm encountering the same issue when trying to implement sharding rules."
sharding version: 5.5.0
springboot version: 3.2.1

from shardingsphere.

Hi @jonaskahn @airh2o, you can try config single rule to load related table metadata. For more details, you can refer this doc - https://shardingsphere.apache.org/document/current/cn/faq/#%E5%8D%95%E8%A1%A8-table-or-view-s-does-not-exist-%E5%BC%82%E5%B8%B8%E5%A6%82%E4%BD%95%E8%A7%A3%E5%86%B3.

I confirmed this page will solve the issue.
If you're using Kotlin or Java, you can take a glance on my configuration:

    private fun createRuleConfiguration(): Collection<RuleConfiguration> {
        val result: MutableCollection<RuleConfiguration> = LinkedList()

        // Add new configuration to load single rule
        result.add(createSingleRuleConfiguration())

        result.add(createReadwriteSplittingRuleConfiguration())
        return result
    }

    private fun createSingleRuleConfiguration(): SingleRuleConfiguration {
        val rule = SingleRuleConfiguration()
        rule.tables = listOf("*.*")
        return rule
    }

Thanks @strongduanmu

from shardingsphere.