[GitHub] [shardingsphere] kimmking commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),

[GitBox]

kimmking commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718364246


   > @Lucas-307
   > I change my MyBatis select sql to Actual Sql and change url to 
jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false ,the result 
is correct, data been returned;
   > 
   > <img alt="图片10" width="564" 
src="https://user-images.githubusercontent.com/46663706/97520796-00fa5180-19d7-11eb-8042-1f9b1a002dcd.png";>
   > 
   > <img alt="图片11" width="797" 
src="https://user-images.githubusercontent.com/46663706/97520808-08215f80-19d7-11eb-8da0-2b0ea8ce2bf1.png";>
   > 
   > <img alt="图片12" width="894" 
src="https://user-images.githubusercontent.com/46663706/97520817-0d7eaa00-19d7-11eb-9a59-313bd18b0269.png";>
   > 
   > By the way,
   > When I switched the data source from mysql to ShardingProxy, I just 
changed the datesouce configuration,
   > Is there anything else 1 need to do, like import the corresponding 
dependencies
   
   
   It shows proxy works well.
   So the reason maybe something wrong in your web controller or service method.
   


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