When only use shardingsphere : sharding is OK (only choise one db and one table)
When only use shardingsphere with seata : sharding is ERROR(Scan all db and table) like
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_0 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_1 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_2 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_3 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_4 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_5 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_6 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_7 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_8 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_9 LIMIT 1
15:16:15.371 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_10 LIMIT 1
......
sharding-transaction-base-seata-at It doesn't help.
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-namespace</artifactId>
<version>4.1.1</version>
</dependency>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-transaction-base-seata-at</artifactId>
<version>4.1.2</version>
</dependency>
notice :4.1.2 is my version be used for fix SeataATShardingTransactionManager can't read seata.conf
<dependency>
<groupId>io.seata</groupId>
<artifactId>seata-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
When only use shardingsphere : sharding is OK (only choise one db and one table)
When only use shardingsphere with seata : sharding is ERROR(Scan all db and table) like 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_0 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_1 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_2 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_3 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_4 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_5 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_6 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_7 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_8 LIMIT 1 15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT FROM shelf_book_key_9 LIMIT 1 15:16:15.371 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_10 LIMIT 1 ...... sharding-transaction-base-seata-at It doesn't help.