You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Python-IBM (via GitHub)" <gi...@apache.org> on 2023/03/01 02:23:06 UTC

[GitHub] [shardingsphere] Python-IBM opened a new issue, #24394: Mybatis does not take effect on batch update of data by table

Python-IBM opened a new issue, #24394:
URL: https://github.com/apache/shardingsphere/issues/24394

   1. Application version
   shardingsphere-jdbc:5.2.0
   mysql:5.7
   mybatis-plus: 3.4.1
   Spring Boot: 2.3.12
   
   2. Mybatis xml
    <update id="updateBatch">
           <foreach collection="transList" item="item" separator=";">
               update reg_bill_trans set req_name= #{item.reqName},req_acct_name= #{item.reqAcctName}
               where trans_id = #{item.transId}
           </foreach>
      </update>
   
   (1) After the batch update of the foreach loop using the mybatis tag.
   (2) Sub-table reg_ bill_ trans_ 01 Data updated successfully. It is divided into table reg_ bill_ trans_ 02 The data was not updated successfully. It is still the old value.
   


-- 
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.apache.org

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


[GitHub] [shardingsphere] Python-IBM closed issue #24394: Mybatis does not take effect on batch update of data by table

Posted by "Python-IBM (via GitHub)" <gi...@apache.org>.
Python-IBM closed issue #24394: Mybatis does not take effect on batch update of data by table
URL: https://github.com/apache/shardingsphere/issues/24394


-- 
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] Python-IBM commented on issue #24394: Mybatis does not take effect on batch update of data by table

Posted by "Python-IBM (via GitHub)" <gi...@apache.org>.
Python-IBM commented on issue #24394:
URL: https://github.com/apache/shardingsphere/issues/24394#issuecomment-1453004559

   > Hi @Python-IBM ShardingSphere works according to SQL and rules, and does not care about specific operations in ORM. Please provide your sharidng rule configuration, Logic SQL and Actual SQL to investigate the issue.
   > 
   > Tip: enable `sql-show` to print out Logic SQL and Actual SQL in the log.
   
   Ok, I understand. I'll check it again


-- 
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] RaigorJiang commented on issue #24394: Mybatis does not take effect on batch update of data by table

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24394:
URL: https://github.com/apache/shardingsphere/issues/24394#issuecomment-1451517614

   Hi @Python-IBM 
   ShardingSphere works according to SQL and rules, and does not care about specific operations in ORM.
   Please provide your sharidng rule configuration, Logic SQL and Actual SQL to investigate the issue.
   
   Tip: enable `sql-show` to print out Logic SQL and Actual SQL 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] wj0530 commented on issue #24394: Mybatis does not take effect on batch update of data by table

Posted by "wj0530 (via GitHub)" <gi...@apache.org>.
wj0530 commented on issue #24394:
URL: https://github.com/apache/shardingsphere/issues/24394#issuecomment-1692683229

   I also have the same problem, how did you ultimately solve it


-- 
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