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 2020/12/31 08:03:17 UTC

[GitHub] [shardingsphere] huoleihu opened a new issue #8845: Can not update sharding key, error using JPA 

huoleihu opened a new issue #8845:
URL: https://github.com/apache/shardingsphere/issues/8845


   ### Which version of ShardingSphere did you use?
   
   Sharding-JDBC 4.0.0
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere JDBC
   
   ### Expected behavior
   
   Normal update
   
   ### Actual behavior
   
   Can not update sharding key error in update
   
   ### Reason analyze (If you can)
   
   JPA SQL :update tb_hd_task set .... where id = ?
   I guess the correct SQL should be-->update tb_hd_task set .... where id = ? and share_key = ?
   
   Does shardingjdbc support adding table keys automatically?


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

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

[GitHub] [shardingsphere] huoleihu commented on issue #8845: Can not update sharding key, error using JPA

Posted by GitBox <gi...@apache.org>.
huoleihu commented on issue #8845:
URL: https://github.com/apache/shardingsphere/issues/8845#issuecomment-752883013


   <img width="2128" alt="WX20201231-154833@2x" src="https://user-images.githubusercontent.com/47547437/103401063-770b6800-4b82-11eb-82a0-8495182f37bb.png">
   


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

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

[GitHub] [shardingsphere] kimmking closed issue #8845: Can not update sharding key, error using JPA

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #8845:
URL: https://github.com/apache/shardingsphere/issues/8845


   


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

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

[GitHub] [shardingsphere] kimmking commented on issue #8845: Can not update sharding key, error using JPA

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #8845:
URL: https://github.com/apache/shardingsphere/issues/8845#issuecomment-752900683


   Users should add sharding-key to sql, shardingsphere can't know the 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.

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