search

apache / incubator-seata-samples

Apache Seata(incubating) Samples for Java
https://seata.apache.org/
Apache License 2.0
2.26k stars 1.91k forks source link

shardingsphere conflict with seata #389

Open kpioneer123 opened 4 years ago

kpioneer123 commented 4 years ago

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>
linghengqian commented 2 months ago