<p dir="auto">亮哥，我也知道目前支持批量插入了，但是我执行批量插入仍然报错是为什么</p>
<h3 dir="auto">SQL: INSERT INTO hs_testerabc(ids,version) VALUES   (?, ?) , (?, ?) , (?, ?) ;</h3>
<h3 dir="auto">Cause: io.shardingjdbc.core.exception.ShardingJdbcException: Invoke jdbc method exception</h3>
<p dir="auto">。。。。<br>
Caused by: java.sql.SQLException: Parameter index out of range (1 &gt; number of parameters, which is 0).<br>
。。。。。</p>
<p dir="auto">报错为：<br>
Exception in thread "main" java.lang.ClassCastException: java.lang.String cannot be cast to org.apache.shardingsphere.infra.yaml.config.pojo.YamlRuleConfiguration<br>
at org.apache.shardingsphere.infra.yaml.config.swapper.YamlRuleConfigurationSwapperEngine$$Lambda$16/557023567.apply(Unknown Source)<br>
at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)<br>
at java.util.Iterator.forEachRemaining(Iterator.java:116)<br>
at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)<br>
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512)<br>
at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:502)<br>
at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)<br>
at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)<br>
at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)<br>
at org.apache.shardingsphere.infra.yaml.config.swapper.YamlRuleConfigurationSwapperEngine.swapToRuleConfigurations(YamlRuleConfigurationSwapperEngine.java:59)<br>
at org.apache.shardingsphere.proxy.backend.config.yaml.swapper.YamlProxyConfigurationSwapper.swapDatabaseConfigurations(YamlProxyConfigurationSwapper.java:63)<br>
at org.apache.shardingsphere.proxy.backend.config.yaml.swapper.YamlProxyConfigurationSwapper.swap(YamlProxyConfigurationSwapper.java:52)<br>
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.createContextManager(BootstrapInitializer.java:62)<br>
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:55)<br>
at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:50)</p>
<p dir="auto">配置文件server.xml：<br>
rules:</p>
<ul dir="auto">
<li>!AUTHORITY<br>
users:
<ul dir="auto">
<li>root@%:root</li>
<li>sharding@:sharding<br>
provider:<br>
type: ALL_PERMITTED</li>
</ul>
</li>
</ul>
<h1 dir="auto">- !TRANSACTION</h1>
<h1 dir="auto">defaultType: XA</h1>
<h1 dir="auto">providerType: Atomikos</h1>
<h1 dir="auto"># When the provider type is Narayana, the following properties can be configured or not</h1>
<h1 dir="auto">props:</h1>
<h1 dir="auto">recoveryStoreUrl: jdbc:mysql://127.0.0.1:3306/jbossts</h1>
<h1 dir="auto">recoveryStoreDataSource: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</h1>
<h1 dir="auto">recoveryStoreUser: root</h1>
<h1 dir="auto">recoveryStorePassword: 12345678</h1>
<h1 dir="auto">- !SQL_PARSER</h1>
<h1 dir="auto">sqlCommentParseEnabled: true</h1>
<h1 dir="auto">sqlStatementCache:</h1>
<h1 dir="auto">initialCapacity: 2000</h1>
<h1 dir="auto">maximumSize: 65535</h1>
<h1 dir="auto">parseTreeCache:</h1>
<h1 dir="auto">initialCapacity: 128</h1>
<h1 dir="auto">maximumSize: 1024</h1>
<p dir="auto">props:<br>
max-connections-size-per-query: 1<br>
kernel-executor-size: 16  # Infinite by default.<br>
proxy-frontend-flush-threshold: 128  # The default value is 128.<br>
proxy-hint-enabled: false<br>
sql-show: true<br>
sql-simple: true<br>
check-table-metadata-enabled: false<br>
show-process-list-enabled: false<br>
# Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.<br>
# The default value is -1, which means set the minimum value for different JDBC drivers.<br>
proxy-backend-query-fetch-size: -1<br>
check-duplicate-table-enabled: false<br>
proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.<br>
# Available options of proxy backend executor suitable: OLAP(default), OLTP. The OLTP option may reduce time cost of writing packets to client, but it may increase the latency of SQL execution<br>
# and block other clients if client connections are more than <code class="notranslate">proxy-frontend-executor-size</code>, especially executing slow SQL.<br>
proxy-backend-executor-suitable: OLAP<br>
proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.<br>
sql-federation-enabled: false<br>
# Available proxy backend driver type: JDBC (default), ExperimentalVertx<br>
proxy-backend-driver-type: JDBC<br>
proxy-mysql-default-version: 5.7.22 # In the absence of schema name, the default version will be used.<br>
proxy-default-port: 3307 # Proxy default port.<br>
proxy-netty-backlog: 1024 # Proxy netty backlog.</p>
<p dir="auto">配置文件config-sharding.xml：<br>
databaseName: decard_pay_dev</p>
<p dir="auto">dataSources:<br>
ds0:<br>
url: jdbc:mysql://127.0.0.1:3306/decard_pay_dev?serverTimezone=UTC&amp;useSSL=false<br>
username: root<br>
password: root<br>
connectionTimeoutMilliseconds: 30000<br>
idleTimeoutMilliseconds: 60000<br>
maxLifetimeMilliseconds: 1800000<br>
maxPoolSize: 50</p>
<p dir="auto">rules:<br>
sharding:<br>
tables:<br>
dp_trade_payment_order:<br>
# 配置数据节点<br>
actual-data-nodes: ds0.dp_trade_payment_order_$-&gt;{2020..2025}<em>0$-&gt;{1..4}<br>
# 分表策略<br>
table-strategy:<br>
complex:<br>
sharding-columns: platform_order_no,order_time,pay_success_time<br>
sharding-algorithm-name: order-algorithm<br>
dp_trade_payment_record:<br>
# 配置数据节点<br>
actual-data-nodes: ds0.dp_trade_payment_record</em><math-renderer class="js-inline-math" style="display: inline" data-static-url="https://github.githubassets.com/static" data-run-id="86aa0a4703ba02cec16715f49ee7ae58">$-&amp;gt;{2020..2025}_0$</math-renderer>-&gt;{1..4}<br>
# 分表策略<br>
table-strategy:<br>
complex:<br>
sharding-columns: platform_order_no,pay_success_time<br>
sharding-algorithm-name: order-algorithm<br>
sharding-algorithms:<br>
order-algorithm:<br>
type: CLASS_BASED<br>
props:<br>
strategy: COMPLEX<br>
algorithmClassName: com.decard.sharding.config.OrderComplexKeysShardingAlgorithm<br>
binding-tables: dp_trade_payment_order,dp_trade_payment_record</p>