You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/11/15 09:46:45 UTC
[GitHub] [shardingsphere] xr2117 opened a new issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
xr2117 opened a new issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615
shardingJDBC 5.0.0-alpha
mybatis 3.1.1
The execution of the savebatch method is split into one save instead of a batch insert
--
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
[GitHub] [shardingsphere] userkdg commented on issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615#issuecomment-984338423
+1
shardingshpere-proxy had batch CRUD Bug , too!
--
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
[GitHub] [shardingsphere] terrymanu closed issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615
--
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
[GitHub] [shardingsphere] xr2117 commented on issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
Posted by GitBox <gi...@apache.org>.
xr2117 commented on issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615#issuecomment-969661240
Mybatis savebatch method used
Print SQL
INSERT INTO internal_questions (
pick_count,
parent_id,
is_choice,
questions_type_id,
questions_type_name,
questions_type_detail_id,
questions_type_detail_name,
content,
answer,
line_number,
option_a,
option_b,
difficulty_id,
difficulty_name,
is_charged,
is_group_question,
origin,
upload_batch,
examine_status,
is_down,
is_check,
create_time,
create_by,
update_time,
update_by,
is_deleted
)
VALUES
(
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
)
config:
spring:
shardingsphere:
props:
sql-show: true
datasource:
common:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
names: ds1
ds1:
password: xxx
url: xxx
username: xxx
rules:
sharding:
key-generators:
snowflake:
props:
max-vibration-offset: 2048
worker-id: 1
type: SNOWFLAKE
sharding-algorithms:
tbstrategy:
props:
algorithm-expression: questions_$->{id % 2 + 1}
type: INLINE
tables:
questions:
actual-data-nodes: ds1.questions_$->{1..2}
key-generate-strategy:
column: id
key-generator-name: snowflake
table-strategy:
standard:
sharding-algorithm-name: tbstrategy
sharding-column: id
--
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
[GitHub] [shardingsphere] menghaoranss commented on issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615#issuecomment-968772934
could you try with the 5.0.0 GA version , and provide your configurations and logic sql, actual sql printed in the log
--
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
[GitHub] [shardingsphere] terrymanu edited a comment on issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
Posted by GitBox <gi...@apache.org>.
terrymanu edited a comment on issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615#issuecomment-997429421
Please try to version 5.0.0.
Because of no response anymore, I just close this issue.
Any new questions please submit new issue.
--
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
[GitHub] [shardingsphere] terrymanu commented on issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615#issuecomment-997429421
Please try to version 5.0.0.
--
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