<h2 dir="auto">Bug Report</h2>
<p dir="auto"><strong>For English only</strong>, other languages will not accept.</p>
<p dir="auto">Before report a bug, make sure you have:</p>
<ul dir="auto">
<li>Searched open and closed <a href="https://github.com/apache/incubator-shardingsphere/issues">GitHub issues</a>.</li>
<li>Read documentation: <a href="https://shardingsphere.apache.org/document/current/en/overview" rel="nofollow">ShardingSphere Doc</a>.</li>
</ul>
<p dir="auto">Please pay attention on issues you submitted, because we maybe need more details.<br>
If no response <strong>more than 7 days</strong> and we cannot reproduce it on current information, we will <strong>close it</strong>.</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>

            org.apache.shardingsphere
            sharding-jdbc-spring-boot-starter
            4.0.0-RC1
  
<h3 dir="auto">Which project did you use? Sharding-JDBC or Sharding-Proxy?</h3>
<p dir="auto">sharding-jdbc</p>
<h3 dir="auto">Expected behavior</h3>
<h3 dir="auto">Actual behavior</h3>
<h3 dir="auto">Reason analyze (If you can)</h3>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.0.0-alpha</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">I use XA transaction configuation, but the sharding-proxy does not send XA SQL to the physics node, the XA transaction is invalid.</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="props:
#    # LOCAL: Proxy will run with LOCAL transaction.
#    # XA: Proxy will run with XA transaction.
#    # BASE: Proxy will run with B.A.S.E transaction.
  proxy-transaction-type: XA"><pre class="notranslate"><code class="notranslate">props:
#    # LOCAL: Proxy will run with LOCAL transaction.
#    # XA: Proxy will run with XA transaction.
#    # BASE: Proxy will run with B.A.S.E transaction.
  proxy-transaction-type: XA
</code></pre></div>
<p dir="auto">I write the SQL in sharding-proxy mysql client,the SQL is:</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="start transaction;
update activity set startTime=&quot;2020-08-01 18:00:01&quot; where activityId=30;
rollback;"><pre class="notranslate"><span class="pl-k">start transaction</span>;
<span class="pl-k">update</span> activity <span class="pl-k">set</span> startTime<span class="pl-k">=</span><span class="pl-s"><span class="pl-pds">"</span>2020-08-01 18:00:01<span class="pl-pds">"</span></span> <span class="pl-k">where</span> activityId<span class="pl-k">=</span><span class="pl-c1">30</span>;
<span class="pl-k">rollback</span>;</pre></div>
<p dir="auto">The result is change, transaction does not rollback.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">This is my Wireshark analysis chart:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="�   ��  �   �   H   �update activity set startTime=&quot;2020-08-01 18:00:01&quot; where activityId=300  � � �   (Rows matched: 1  Changed: 0  Warnings: 0"><pre class="notranslate"><code class="notranslate">�   ��  �   �   H   �update activity set startTime="2020-08-01 18:00:01" where activityId=300  � � �   (Rows matched: 1  Changed: 0  Warnings: 0
</code></pre></div>
<p dir="auto">I can't see any XA SQL in the analysis.So I think the XA configuration is invalid.</p>