[GitHub] [shardingsphere] roodkcab removed a comment on issue #12771: how to use xa transaction in shardingsphere-proxy

[GitBox <gi...@apache.org>]

roodkcab removed a comment on issue #12771:
URL: https://github.com/apache/shardingsphere/issues/12771#issuecomment-939243513


   > > Well, I understand that this TansactionManager is used by Shardingsphere internal to commit to the backend database servers especially in the case of splitting a origin insert sql statment into two or more statments and routing to the different databases, which should be running with XA or SEAT transaction mode to make the data consistency. @RaigorJiang , is it right ?
   > > In @roodkcab scenario, it seems that he wants to use a XA transaction in the application and connect to the shardingsphere-proxy. So @roodkcab can you describe your question in more detail ? e.g. what is your application want to do in XA transaction ?
   > 
   > right, I have to use XA statements without jdbc. It's actually some PHP scripts connect to shardingsphere-proxy with PDO extension, using XA statements to get distribution transaction done.
   > 
   > I've solved this problem by using a SchemaAssignedDatabaseHandler in TransactionBackendHandlerFactory when tclStatement is an instance of MySQLXAStatement.
   > 
   > ![image](https://user-images.githubusercontent.com/1700820/135231739-fd5e3f65-7268-4fe4-97d6-a8636ad9be6c.png)
   
   this is a wrong implementation, and there's no transaction at all on backend database.


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

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