[GitHub] [incubator-shardingsphere] DongJigong 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
DongJigong 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-521208390
 
 
   > Other solution, I think, is add where clause with sharding column to query 
SQL, it can route SQL to actual node and find data.
   
   I have understood what you mean. many thanks. But I think according to my 
data columns, the actual node should be found.


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] DongJigong 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
DongJigong 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-52127
 
 
   > From your example code, I find you do not config `actual_node`, it will 
cause 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.
   
   Obviously, I need a table slice . I cannot config like this way. Is there 
any other solution?


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] DongJigong 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
DongJigong 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-521175238
 
 
   > 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.
   
   https://github.com/DongJigong/shardingsphere-issues-issue2865.git  
   It turns out that the saveAll method changed nothing which also is a 
problem. but not reproduce my situation.


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] DongJigong 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
DongJigong 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-521156819
 
 
   > 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.
   
   https://gitter.im  I have send a message to you. I hope could have a talk 
privately´╝îmany thanks


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] DongJigong 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
DongJigong 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-521149060
 
 
   > Of course, the stack is your application -> jpa -> sharding -> hikari pool 
-> origin jdbc
   
   I found that after My saveAll every row data will select by id once again 
then insert it.But insert row data without my primary auto increment ID. I 
think this is the place where error happened. Is this the correct situation?


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] DongJigong 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
DongJigong 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-521149060
 
 
   > Of course, the stack is your application -> jpa -> sharding -> hikari pool 
-> origin jdbc
   
   I found that every row data will select by id then insert it.But insert row 
data without my primary auto increment ID. I think this is the place where 
error happened. Is this the correct;y situation?


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] DongJigong 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
DongJigong 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-521149060
 
 
   > Of course, the stack is your application -> jpa -> sharding -> hikari pool 
-> origin jdbc
   
   I found that every row data will select by id then insert it.But insert row 
data without my primary auto increment ID. I think this is the place where 
error happened. Is this the correct situation?


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] DongJigong 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
DongJigong 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-521078319
 
 
   Ok,I will checkout this problem myself,if I have a conclusion,I will reply 
you,thanks


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] DongJigong 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
DongJigong 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-521071440
 
 
   This is a very common scenes,I think you could reproduce it easily.I am 
using spring boot jpa findAll method get some data then I changed some columns 
saveAll these data. sharding will insert new data


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] DongJigong 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
DongJigong 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-521071440
 
 
   This is a very common scenes,I think you could reproduce it easily


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] DongJigong 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
DongJigong 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-521070737
 
 
   > > I have tracked my code, I found sharding sql log show that sharding-jdbc 
will select one row with id and insert it. I have 24 rows data. sharding 
iterate 24 times.
   > 
   > Sorry, I can't understand your situation accurately. You means that you 
have found 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] DongJigong 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
DongJigong 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-521070737
 
 
   > > I have tracked my code, I found sharding sql log show that sharding-jdbc 
will select one row with id and insert it. I have 24 rows data. sharding 
iterate 24 times.
   > 
   > Sorry, I can't understand your situation accurately. You means that you 
have found the reason?
   This is a very common situation,I think you could reproduce it easily


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