<p dir="auto">In sagaconfigurationloader.loadconfigurationproperties method of distributed transaction saga, sagaconfigurationloader. Class. Getclassloader(). Getresource (configuration_file) is used to read saga.properties. When the project runs as a jar package, it will report the wrong path and cannot find the file. A policy can be added to use sagaconfiguration when it cannot be read. Load. Class. Getclassloader(). Getresourceasstream (configuration file); to read</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!<br>
开源不易，我们希望将精力放在完成新功能和解决有价值的问题上，为了让大家的配合更具有效率，请填写以下列出的全部问题</p>
<h3 dir="auto">Which version of Sharding-Jdbc do you using?（您使用的Sharding-Jdbc版本为？）</h3>
<p dir="auto">2.0.3</p>
<h3 dir="auto">Expected behavior （您预期的结果是）</h3>
<p dir="auto">support show table structure expresses like "SHOW TABLES LIKE 'table_name'" or "SHOW CREATE TABLE table_name"</p>
<h3 dir="auto">Actual behavior （实际运行的结果是）</h3>
<p dir="auto">io.shardingjdbc.core.parsing.parser.exception.SQLParsingUnsupportedException: Not supported token 'SHOW'</p>
<h3 dir="auto">Steps to reproduce the behavior （可重现问题的操作步骤）</h3>
<p dir="auto">private static boolean isTableExists(Connection connection, String tableName) throws SQLException{<br>
String sql = "SHOW TABLES LIKE '" + tableName + "'";<br>
logger.debug("check if the table is exists: {}", sql);<br>
Statement statement = connection.createStatement();<br>
try {<br>
ResultSet resultSet = statement.executeQuery(sql);<br>
return resultSet.next();<br>
}<br>
catch (SQLException exp) {<br>
logger.debug("table {} is not exits.", tableName);<br>
}<br>
finally {<br>
statement.close();<br>
}<br>
return false;<br>
}</p>
<h3 dir="auto">Please provide the reproduce example codes (such as github link)，otherwise we will label the issue as Invalid and close it.（为了节省复现问题的时间，请务必提供可重现的代码，否则我们会将issue直接标记为invalid并关闭）</h3>
<p dir="auto">Code should based on <a href="https://github.com/shardingjdbc/sharding-jdbc-example">https://github.com/shardingjdbc/sharding-jdbc-example</a><br>
（代码请基于 <a href="https://github.com/shardingjdbc/sharding-jdbc-example%EF%BC%89">https://github.com/shardingjdbc/sharding-jdbc-example）</a></p>