[GitHub] [shardingsphere] userkdg edited a comment on issue #14541: on proxy, in release application, do update, delete, add transaction sql operation will throw read only Exception.

[GitBox]

userkdg edited a comment on issue #14541:
URL: 
https://github.com/apache/shardingsphere/issues/14541#issuecomment-1006248750


   > 
   @jingshanglu 
   yes, i give a app logic sql now. 
   as: 
   step1: scheduler job 
   <img width="586" alt="1641438128(1)" 
src="https://user-images.githubusercontent.com/21057449/148321532-0a8b2ae4-be2a-4cbf-83bf-a7c86df024c7.png";>
   step2:  service no set transaction 
   <img width="260" alt="1641438282(1)" 
src="https://user-images.githubusercontent.com/21057449/148321760-7d19e78e-b3d7-443f-9429-301e6fe40e4f.png";>
   step3: update
   <img width="573" alt="1641438354(1)" 
src="https://user-images.githubusercontent.com/21057449/148321865-c4725edf-c485-415a-b480-f1ab6dc576dc.png";>
   step4: update sql using tk-mybatis 
   <img width="645" alt="1641438386(1)" 
src="https://user-images.githubusercontent.com/21057449/148321914-af7693d1-85b8-4506-b44e-60c65fa6d4c7.png";>
   
   remark: this is one case in app
   other biz features had used ``` @Transactional(readOnly = true) ```, but  
the above situation not used.  maybe proxy connection  to be contaminated as 
read-only?


-- 
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-unsubscr...@shardingsphere.apache.org

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