[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-14 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521205179
 
 
   It can config as groovy program, like 
`ds0.t_order_${0..100}_${201901..201912}`, it means t_order_0_201901, 
t_order_0_201902 . t_order_100_ 201911, t_order_100_201912.
   
   But I think this kind of sharding maybe not best way. I suggest to do 
sharding with table name for non-business meaning


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-14 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521196220
 
 
   From your example code, I find you do not config `actual_node`, it can not 
find data with full-routing.
   
   After add 
`spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds0.t_order_100_201908`,
 the problem solved.
   


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-14 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521158818
 
 
   Sorry, I don't have full time to talk privately, I suggest you provide a the 
simplest example code without your business information or full 
configuration/entity,repo/SQL.
   We will reply after reproducing and finding the reason.
   
   And if you provide them in issue can help others understand the problem and 
context.


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-14 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521158818
 
 
   Sorry, I don't have full time to talk privately, I suggest you provide a the 
simplest example code without your business information or full 
configuration/entity,repo/SQL.
   We will reply after reproducing and finding the reason.
   
   And if you provide them in issue can help other understand the problem and 
context.


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-14 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521153242
 
 
   I don't know, the information you provide is so dispersed, I can't locate 
where or what problem caused.
   
   1. What's your sharding configuration?
   2. What's your logic SQL?
   3. What's the actual SQL after shardingsphere rewrite?
   4. Primary is auto increment ID, Make sure whether JPA/Hibernate cached the 
entity you select by ID.
   
   I suggest you provide enough information let us reproduce your problem, or 
example code which can reproduce so that we can help you find the reason.


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-13 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521074125
 
 
   > > OK, I will try to reproduce.
   > 
   > 
![image](https://user-images.githubusercontent.com/8855265/62989204-b0eaaa00-be79-11e9-9b0e-6060317188de.png)
   > This table has a complex column slices. All my descriptions depend on 
operating this table
   
   Can you provide full sharding configuration and sharding algorithm?
   
   I still think that if there is a example code will be better, which can 
avoid our meaningless information exchange and improve efficiency.


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:
us...@infra.apache.org


With regards,
Apache Git Services


[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change some values and save shoud update Row Data rather then insert

2019-08-13 Thread GitBox
KomachiSion edited a comment on issue #2865: 4.0.0-RC1 jpa select result change 
some values and save shoud update Row Data rather then insert 
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2865#issuecomment-521074125
 
 
   > > OK, I will try to reproduce.
   > 
   > 
![image](https://user-images.githubusercontent.com/8855265/62989204-b0eaaa00-be79-11e9-9b0e-6060317188de.png)
   > This table has a complex column slices. All my descriptions depend on 
operating this table
   
   Can you provide full sharding configuration and sharding algorithm?
   
   I still think that if there is a example code will be better, which can 
avoid our meaningless intelligence exchange and improve efficiency.


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:
us...@infra.apache.org


With regards,
Apache Git Services