[GitHub] [shardingsphere] balainit removed a comment on issue #11882: Could not commit JDBC transaction; nested exception is java.sql.SQLExcept

[GitBox <gi...@apache.org>]

balainit removed a comment on issue #11882:
URL: https://github.com/apache/shardingsphere/issues/11882#issuecomment-901745391


   
   
   ### configuration 
   
   
   ```
   #数据源配置
   spring.shardingsphere.datasource.names=ds0,ds1
   
   spring.shardingsphere.datasource.ds0.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.cj.jdbc.Driver
   spring.shardingsphere.datasource.ds0.jdbc-url=jdbc:mysql://db:3306/xxx?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=true
   spring.shardingsphere.datasource.ds0.username=xxxx
   spring.shardingsphere.datasource.ds0.password=xxxx
   
   spring.shardingsphere.datasource.ds1.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.cj.jdbc.Driver
   spring.shardingsphere.datasource.ds1.jdbc-url=jdbc:mysql://db:3306/xxxxxx?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=true
   spring.shardingsphere.datasource.ds1.username=xxxx
   spring.shardingsphere.datasource.ds1.password=xxxxx
   
   spring.shardingsphere.datasource.ds0.hikari.minimum-idle=10
   spring.shardingsphere.datasource.ds0.hikari.maximum-pool-size=65
   spring.shardingsphere.datasource.ds0.hikari.connection-timeout=30000
   spring.shardingsphere.datasource.ds0.hikari.idle-timeout=60000
   spring.shardingsphere.datasource.ds0.hikari.max-lifetime=1800000
   
   spring.shardingsphere.sharding.default-data-source-name=ds0
   spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=id
   spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds$->{0}
   
   spring.shardingsphere.sharding.tables.product_spu.actual-data-nodes=ds$->{0..0}.product_spu_$->{0..1}
   spring.shardingsphere.sharding.tables.product_spu.table-strategy.inline.sharding-column=id
   spring.shardingsphere.sharding.tables.product_spu.table-strategy.inline.algorithm-expression=product_spu_$->{id % 2}
   
   spring.shardingsphere.sharding.tables.product_sku.actual-data-nodes=ds0.product_sku_$->{0..1}
   spring.shardingsphere.sharding.tables.product_sku.table-strategy.inline.sharding-column=spu_id
   spring.shardingsphere.sharding.tables.product_sku.table-strategy.inline.algorithm-expression=product_sku_$->{spu_id % 2}
   
   spring.shardingsphere.sharding.tables.product_spu_snapshot.actual-data-nodes=ds0.product_spu_snapshot_$->{0..1}
   spring.shardingsphere.sharding.tables.product_spu_snapshot.table-strategy.inline.sharding-column=spu_id
   spring.shardingsphere.sharding.tables.product_spu_snapshot.table-strategy.inline.algorithm-expression=product_spu_snapshot_$->{spu_id % 2}
   
   spring.shardingsphere.sharding.tables.product_sku_snapshot.actual-data-nodes=ds0.product_sku_snapshot_$->{0..1}
   spring.shardingsphere.sharding.tables.product_sku_snapshot.table-strategy.inline.sharding-column=sku_id
   spring.shardingsphere.sharding.tables.product_sku_snapshot.table-strategy.inline.algorithm-expression=product_sku_snapshot_$->{sku_id % 2}
   
   spring.shardingsphere.sharding.tables.product_daily_calendar.actual-data-nodes=ds0.product_daily_calendar_$->{0..1}
   spring.shardingsphere.sharding.tables.product_daily_calendar.table-strategy.inline.sharding-column=product_id
   spring.shardingsphere.sharding.tables.product_daily_calendar.table-strategy.inline.algorithm-expression=product_daily_calendar_$->{product_id % 2}
   
   
   spring.shardingsphere.sharding.tables.product_distribution.actual-data-nodes=ds0.product_distribution_$->{0..1}
   spring.shardingsphere.sharding.tables.product_distribution.table-strategy.inline.sharding-column=product_id
   spring.shardingsphere.sharding.tables.product_distribution.table-strategy.inline.algorithm-expression=product_distribution_$->{product_id % 2}
   
   
   spring.shardingsphere.sharding.tables.product_warehouse_bills.actual-data-nodes=ds0.product_warehouse_bills_$->{0..1}
   spring.shardingsphere.sharding.tables.product_warehouse_bills.table-strategy.inline.sharding-column=id
   spring.shardingsphere.sharding.tables.product_warehouse_bills.table-strategy.inline.algorithm-expression=product_warehouse_bills_$->{id % 2}
   
   
   spring.shardingsphere.sharding.tables.product_warehouse_detail.actual-data-nodes=ds0.product_warehouse_detail_$->{0..1}
   spring.shardingsphere.sharding.tables.product_warehouse_detail.table-strategy.inline.sharding-column=warehouse_bills_id
   spring.shardingsphere.sharding.tables.product_warehouse_detail.table-strategy.inline.algorithm-expression=product_warehouse_detail_$->{warehouse_bills_id % 2}
   
   
   spring.shardingsphere.sharding.broadcast-tables[0]=product_category
   spring.shardingsphere.sharding.tables.product_category.actual-data-nodes=ds$->{0}.product_category
   
   spring.shardingsphere.props.sql.show=true
   
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org