<h2 dir="auto">1. Environmental description</h2>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="Horizontal sharding database  ssm project + spring-namespace

the question like  issues#24876   I submitted  the two questions    So far it has not been solved."><pre class="notranslate"><code class="notranslate">Horizontal sharding database  ssm project + spring-namespace

the question like  issues#24876   I submitted  the two questions    So far it has not been solved.
</code></pre></div>
<h2 dir="auto">1.1.  dependencies</h2>
<div class="highlight highlight-text-xml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="
    &lt;dependencies&gt;

        &lt;dependency&gt;
            &lt;groupId&gt;mysql&lt;/groupId&gt;
            &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
            &lt;version&gt;8.0.25&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.springframework&lt;/groupId&gt;
            &lt;artifactId&gt;spring-webmvc&lt;/artifactId&gt;
            &lt;version&gt;5.1.9.RELEASE&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.mybatis&lt;/groupId&gt;
            &lt;artifactId&gt;mybatis&lt;/artifactId&gt;
            &lt;version&gt;3.5.4&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.mybatis&lt;/groupId&gt;
            &lt;artifactId&gt;mybatis-spring&lt;/artifactId&gt;
            &lt;version&gt;2.0.3&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.springframework&lt;/groupId&gt;
            &lt;artifactId&gt;spring-jdbc&lt;/artifactId&gt;
            &lt;version&gt;5.1.9.RELEASE&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.aspectj&lt;/groupId&gt;
            &lt;artifactId&gt;aspectjweaver&lt;/artifactId&gt;
            &lt;version&gt;1.9.6&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;com.fasterxml.jackson.core&lt;/groupId&gt;
            &lt;artifactId&gt;jackson-databind&lt;/artifactId&gt;
            &lt;version&gt;2.11.4&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.projectlombok&lt;/groupId&gt;
            &lt;artifactId&gt;lombok&lt;/artifactId&gt;
            &lt;version&gt;1.18.20&lt;/version&gt;
        &lt;/dependency&gt;
        
        &lt;dependency&gt;
            &lt;groupId&gt;org.apache.shardingsphere&lt;/groupId&gt;
            &lt;artifactId&gt;shardingsphere-jdbc-core&lt;/artifactId&gt;
            &lt;version&gt;5.2.1&lt;/version&gt;
        &lt;/dependency&gt;
        &lt;!-- https://mvnrepository.com/artifact/org.apache.shardingsphere/shardingsphere-jdbc-core-spring-namespace --&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.apache.shardingsphere&lt;/groupId&gt;
            &lt;artifactId&gt;shardingsphere-jdbc-core-spring-namespace&lt;/artifactId&gt;
            &lt;version&gt;5.2.1&lt;/version&gt;
        &lt;/dependency&gt;
      
    &lt;/dependencies&gt;"><pre class="notranslate">    &lt;<span class="pl-ent">dependencies</span>&gt;

        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;mysql&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;mysql-connector-java&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;8.0.25&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.springframework&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;spring-webmvc&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;5.1.9.RELEASE&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.mybatis&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;mybatis&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;3.5.4&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.mybatis&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;mybatis-spring&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;2.0.3&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.springframework&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;spring-jdbc&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;5.1.9.RELEASE&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.aspectj&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;aspectjweaver&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;1.9.6&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;com.fasterxml.jackson.core&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;jackson-databind&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;2.11.4&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.projectlombok&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;lombok&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;1.18.20&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.apache.shardingsphere&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;shardingsphere-jdbc-core&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;5.2.1&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
        <span class="pl-c"><span class="pl-c">&lt;!--</span> https://mvnrepository.com/artifact/org.apache.shardingsphere/shardingsphere-jdbc-core-spring-namespace <span class="pl-c">--&gt;</span></span>
        &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.apache.shardingsphere&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;shardingsphere-jdbc-core-spring-namespace&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;5.2.1&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;
      
    &lt;/<span class="pl-ent">dependencies</span>&gt;</pre></div>
<h2 dir="auto">1.2. spring config</h2>
<div class="highlight highlight-text-xml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="&lt;beans xmlns=&quot;http://www.springframework.org/schema/beans&quot;
       xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;
       xmlns:context=&quot;http://www.springframework.org/schema/context&quot;
       xmlns:tx=&quot;http://www.springframework.org/schema/tx&quot;
       xmlns:shardingsphere=&quot;http://shardingsphere.apache.org/schema/shardingsphere/datasource&quot;
       xmlns:sharding=&quot;http://shardingsphere.apache.org/schema/shardingsphere/sharding&quot;
       xsi:schemaLocation=&quot;http://www.springframework.org/schema/beans
                           http://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/tx
                           http://www.springframework.org/schema/tx/spring-tx.xsd
                           http://www.springframework.org/schema/context
                           http://www.springframework.org/schema/context/spring-context.xsd
                           http://shardingsphere.apache.org/schema/shardingsphere/datasource
                           http://shardingsphere.apache.org/schema/shardingsphere/datasource/datasource.xsd
                           http://shardingsphere.apache.org/schema/shardingsphere/sharding
                           http://shardingsphere.apache.org/schema/shardingsphere/sharding/sharding.xsd
                           &quot;&gt;


    &lt;context:component-scan base-package=&quot;com.baidu.cn.mapper&quot; /&gt;

    &lt;bean id=&quot;demo_ds_0&quot; class=&quot;com.zaxxer.hikari.HikariDataSource&quot; destroy-method=&quot;close&quot;&gt;
        &lt;property name=&quot;driverClassName&quot; value=&quot;com.mysql.cj.jdbc.Driver&quot;/&gt;
        &lt;property name=&quot;jdbcUrl&quot; value=&quot;jdbc:mysql://localhost:3306/aaaa?serverTimezone=UTC&amp;amp;useSSL=false&amp;amp;useUnicode=true&amp;amp;characterEncoding=UTF-8&quot;/&gt;
        &lt;property name=&quot;username&quot; value=&quot;root&quot;/&gt;
        &lt;property name=&quot;password&quot; value=&quot;rootroot&quot;/&gt;
    &lt;/bean&gt;

    &lt;bean id=&quot;demo_ds_1&quot; class=&quot;com.zaxxer.hikari.HikariDataSource&quot; destroy-method=&quot;close&quot;&gt;
        &lt;property name=&quot;driverClassName&quot; value=&quot;com.mysql.cj.jdbc.Driver&quot;/&gt;
        &lt;property name=&quot;jdbcUrl&quot; value=&quot;jdbc:mysql://localhost:3306/bbbb?serverTimezone=UTC&amp;amp;useSSL=false&amp;amp;useUnicode=true&amp;amp;characterEncoding=UTF-8&quot;/&gt;
        &lt;property name=&quot;username&quot; value=&quot;root&quot;/&gt;
        &lt;property name=&quot;password&quot; value=&quot;rootroot&quot;/&gt;
    &lt;/bean&gt;

    &lt;sharding:standard-strategy id=&quot;databaseStrategy&quot; sharding-column=&quot;id&quot; algorithm-ref=&quot;inlineStrategyShardingAlgorithm&quot; /&gt;

    &lt;sharding:sharding-algorithm id=&quot;inlineStrategyShardingAlgorithm&quot; type=&quot;INLINE&quot;&gt;
        &lt;props&gt;
            &lt;prop key=&quot;algorithm-expression&quot;&gt;demo_ds_${id % 2}&lt;/prop&gt;
        &lt;/props&gt;
    &lt;/sharding:sharding-algorithm&gt;

    &lt;sharding:key-generate-algorithm id=&quot;snowflakeAlgorithm&quot; type=&quot;SNOWFLAKE&quot;&gt;
    &lt;/sharding:key-generate-algorithm&gt;

    &lt;sharding:key-generate-strategy id=&quot;empKeyGenerator&quot; column=&quot;id&quot; algorithm-ref=&quot;snowflakeAlgorithm&quot; /&gt;


    &lt;sharding:rule id=&quot;shardingRule&quot;&gt;
        &lt;sharding:table-rules&gt;
            &lt;sharding:table-rule logic-table=&quot;t_emp&quot; database-strategy-ref=&quot;databaseStrategy&quot; key-generate-strategy-ref=&quot;empKeyGenerator&quot; /&gt;
        &lt;/sharding:table-rules&gt;
    &lt;/sharding:rule&gt;

    &lt;shardingsphere:data-source id=&quot;shardingDataSource&quot; database-name=&quot;sharding-databases&quot; data-source-names=&quot;demo_ds_0, demo_ds_1&quot; rule-refs=&quot;shardingRule&quot; /&gt;

    &lt;bean id=&quot;transactionManager&quot; class=&quot;org.springframework.jdbc.datasource.DataSourceTransactionManager&quot;&gt;
        &lt;property name=&quot;dataSource&quot; ref=&quot;shardingDataSource&quot; /&gt;
    &lt;/bean&gt;
    &lt;tx:annotation-driven /&gt;

    &lt;bean id=&quot;sqlSessionFactory&quot; class=&quot;org.mybatis.spring.SqlSessionFactoryBean&quot;&gt;
        &lt;property name=&quot;dataSource&quot; ref=&quot;shardingDataSource&quot;/&gt;
    &lt;/bean&gt;

    &lt;bean class=&quot;org.mybatis.spring.mapper.MapperScannerConfigurer&quot;&gt;
        &lt;property name=&quot;basePackage&quot; value=&quot;com.baidu.cn.mapper&quot;/&gt;
        &lt;property name=&quot;sqlSessionFactoryBeanName&quot; value=&quot;sqlSessionFactory&quot;/&gt;
    &lt;/bean&gt;
"><pre class="notranslate">&lt;<span class="pl-ent">beans</span> <span class="pl-e">xmlns</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/beans<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">xsi</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.w3.org/2001/XMLSchema-instance<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">context</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/context<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">tx</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/tx<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">shardingsphere</span>=<span class="pl-s"><span class="pl-pds">"</span>http://shardingsphere.apache.org/schema/shardingsphere/datasource<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">sharding</span>=<span class="pl-s"><span class="pl-pds">"</span>http://shardingsphere.apache.org/schema/shardingsphere/sharding<span class="pl-pds">"</span></span>
       <span class="pl-e">xsi</span><span class="pl-e">:</span><span class="pl-e">schemaLocation</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/beans</span>
<span class="pl-s">                           http://www.springframework.org/schema/beans/spring-beans.xsd</span>
<span class="pl-s">                           http://www.springframework.org/schema/tx</span>
<span class="pl-s">                           http://www.springframework.org/schema/tx/spring-tx.xsd</span>
<span class="pl-s">                           http://www.springframework.org/schema/context</span>
<span class="pl-s">                           http://www.springframework.org/schema/context/spring-context.xsd</span>
<span class="pl-s">                           http://shardingsphere.apache.org/schema/shardingsphere/datasource</span>
<span class="pl-s">                           http://shardingsphere.apache.org/schema/shardingsphere/datasource/datasource.xsd</span>
<span class="pl-s">                           http://shardingsphere.apache.org/schema/shardingsphere/sharding</span>
<span class="pl-s">                           http://shardingsphere.apache.org/schema/shardingsphere/sharding/sharding.xsd</span>
<span class="pl-s">                           <span class="pl-pds">"</span></span>&gt;


    &lt;<span class="pl-ent">context</span><span class="pl-ent">:</span><span class="pl-ent">component-scan</span> <span class="pl-e">base-package</span>=<span class="pl-s"><span class="pl-pds">"</span>com.baidu.cn.mapper<span class="pl-pds">"</span></span> /&gt;

    &lt;<span class="pl-ent">bean</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>demo_ds_0<span class="pl-pds">"</span></span> <span class="pl-e">class</span>=<span class="pl-s"><span class="pl-pds">"</span>com.zaxxer.hikari.HikariDataSource<span class="pl-pds">"</span></span> <span class="pl-e">destroy-method</span>=<span class="pl-s"><span class="pl-pds">"</span>close<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>driverClassName<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>com.mysql.cj.jdbc.Driver<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>jdbcUrl<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>jdbc:mysql://localhost:3306/aaaa?serverTimezone=UTC<span class="pl-c1">&amp;amp;</span>useSSL=false<span class="pl-c1">&amp;amp;</span>useUnicode=true<span class="pl-c1">&amp;amp;</span>characterEncoding=UTF-8<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>username<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>root<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>password<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>rootroot<span class="pl-pds">"</span></span>/&gt;
    &lt;/<span class="pl-ent">bean</span>&gt;

    &lt;<span class="pl-ent">bean</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>demo_ds_1<span class="pl-pds">"</span></span> <span class="pl-e">class</span>=<span class="pl-s"><span class="pl-pds">"</span>com.zaxxer.hikari.HikariDataSource<span class="pl-pds">"</span></span> <span class="pl-e">destroy-method</span>=<span class="pl-s"><span class="pl-pds">"</span>close<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>driverClassName<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>com.mysql.cj.jdbc.Driver<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>jdbcUrl<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>jdbc:mysql://localhost:3306/bbbb?serverTimezone=UTC<span class="pl-c1">&amp;amp;</span>useSSL=false<span class="pl-c1">&amp;amp;</span>useUnicode=true<span class="pl-c1">&amp;amp;</span>characterEncoding=UTF-8<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>username<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>root<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>password<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>rootroot<span class="pl-pds">"</span></span>/&gt;
    &lt;/<span class="pl-ent">bean</span>&gt;

    &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">standard-strategy</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>databaseStrategy<span class="pl-pds">"</span></span> <span class="pl-e">sharding-column</span>=<span class="pl-s"><span class="pl-pds">"</span>id<span class="pl-pds">"</span></span> <span class="pl-e">algorithm-ref</span>=<span class="pl-s"><span class="pl-pds">"</span>inlineStrategyShardingAlgorithm<span class="pl-pds">"</span></span> /&gt;

    &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">sharding-algorithm</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>inlineStrategyShardingAlgorithm<span class="pl-pds">"</span></span> <span class="pl-e">type</span>=<span class="pl-s"><span class="pl-pds">"</span>INLINE<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">props</span>&gt;
            &lt;<span class="pl-ent">prop</span> <span class="pl-e">key</span>=<span class="pl-s"><span class="pl-pds">"</span>algorithm-expression<span class="pl-pds">"</span></span>&gt;demo_ds_${id % 2}&lt;/<span class="pl-ent">prop</span>&gt;
        &lt;/<span class="pl-ent">props</span>&gt;
    &lt;/<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">sharding-algorithm</span>&gt;

    &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">key-generate-algorithm</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>snowflakeAlgorithm<span class="pl-pds">"</span></span> <span class="pl-e">type</span>=<span class="pl-s"><span class="pl-pds">"</span>SNOWFLAKE<span class="pl-pds">"</span></span>&gt;
    &lt;/<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">key-generate-algorithm</span>&gt;

    &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">key-generate-strategy</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>empKeyGenerator<span class="pl-pds">"</span></span> <span class="pl-e">column</span>=<span class="pl-s"><span class="pl-pds">"</span>id<span class="pl-pds">"</span></span> <span class="pl-e">algorithm-ref</span>=<span class="pl-s"><span class="pl-pds">"</span>snowflakeAlgorithm<span class="pl-pds">"</span></span> /&gt;


    &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">rule</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>shardingRule<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">table-rules</span>&gt;
            &lt;<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">table-rule</span> <span class="pl-e">logic-table</span>=<span class="pl-s"><span class="pl-pds">"</span>t_emp<span class="pl-pds">"</span></span> <span class="pl-e">database-strategy-ref</span>=<span class="pl-s"><span class="pl-pds">"</span>databaseStrategy<span class="pl-pds">"</span></span> <span class="pl-e">key-generate-strategy-ref</span>=<span class="pl-s"><span class="pl-pds">"</span>empKeyGenerator<span class="pl-pds">"</span></span> /&gt;
        &lt;/<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">table-rules</span>&gt;
    &lt;/<span class="pl-ent">sharding</span><span class="pl-ent">:</span><span class="pl-ent">rule</span>&gt;

    &lt;<span class="pl-ent">shardingsphere</span><span class="pl-ent">:</span><span class="pl-ent">data-source</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>shardingDataSource<span class="pl-pds">"</span></span> <span class="pl-e">database-name</span>=<span class="pl-s"><span class="pl-pds">"</span>sharding-databases<span class="pl-pds">"</span></span> <span class="pl-e">data-source-names</span>=<span class="pl-s"><span class="pl-pds">"</span>demo_ds_0, demo_ds_1<span class="pl-pds">"</span></span> <span class="pl-e">rule-refs</span>=<span class="pl-s"><span class="pl-pds">"</span>shardingRule<span class="pl-pds">"</span></span> /&gt;

    &lt;<span class="pl-ent">bean</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>transactionManager<span class="pl-pds">"</span></span> <span class="pl-e">class</span>=<span class="pl-s"><span class="pl-pds">"</span>org.springframework.jdbc.datasource.DataSourceTransactionManager<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>dataSource<span class="pl-pds">"</span></span> <span class="pl-e">ref</span>=<span class="pl-s"><span class="pl-pds">"</span>shardingDataSource<span class="pl-pds">"</span></span> /&gt;
    &lt;/<span class="pl-ent">bean</span>&gt;
    &lt;<span class="pl-ent">tx</span><span class="pl-ent">:</span><span class="pl-ent">annotation-driven</span> /&gt;

    &lt;<span class="pl-ent">bean</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>sqlSessionFactory<span class="pl-pds">"</span></span> <span class="pl-e">class</span>=<span class="pl-s"><span class="pl-pds">"</span>org.mybatis.spring.SqlSessionFactoryBean<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>dataSource<span class="pl-pds">"</span></span> <span class="pl-e">ref</span>=<span class="pl-s"><span class="pl-pds">"</span>shardingDataSource<span class="pl-pds">"</span></span>/&gt;
    &lt;/<span class="pl-ent">bean</span>&gt;

    &lt;<span class="pl-ent">bean</span> <span class="pl-e">class</span>=<span class="pl-s"><span class="pl-pds">"</span>org.mybatis.spring.mapper.MapperScannerConfigurer<span class="pl-pds">"</span></span>&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>basePackage<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>com.baidu.cn.mapper<span class="pl-pds">"</span></span>/&gt;
        &lt;<span class="pl-ent">property</span> <span class="pl-e">name</span>=<span class="pl-s"><span class="pl-pds">"</span>sqlSessionFactoryBeanName<span class="pl-pds">"</span></span> <span class="pl-e">value</span>=<span class="pl-s"><span class="pl-pds">"</span>sqlSessionFactory<span class="pl-pds">"</span></span>/&gt;
    &lt;/<span class="pl-ent">bean</span>&gt;
</pre></div>
<h2 dir="auto">1.3 springmvc config</h2>
<div class="highlight highlight-text-xml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
&lt;beans xmlns=&quot;http://www.springframework.org/schema/beans&quot;
       xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;
       xmlns:context=&quot;http://www.springframework.org/schema/context&quot;
       xmlns:mvc=&quot;http://www.springframework.org/schema/mvc&quot;
       xsi:schemaLocation=&quot;http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd&quot;&gt;


    &lt;context:component-scan base-package=&quot;com.baidu.cn.controller&quot;/&gt;

    &lt;mvc:annotation-driven/&gt;
&lt;/beans&gt;"><pre class="notranslate">&lt;?<span class="pl-ent">xml</span><span class="pl-e"> version</span>=<span class="pl-s"><span class="pl-pds">"</span>1.0<span class="pl-pds">"</span></span><span class="pl-e"> encoding</span>=<span class="pl-s"><span class="pl-pds">"</span>UTF-8<span class="pl-pds">"</span></span>?&gt;
&lt;<span class="pl-ent">beans</span> <span class="pl-e">xmlns</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/beans<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">xsi</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.w3.org/2001/XMLSchema-instance<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">context</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/context<span class="pl-pds">"</span></span>
       <span class="pl-e">xmlns</span><span class="pl-e">:</span><span class="pl-e">mvc</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/mvc<span class="pl-pds">"</span></span>
       <span class="pl-e">xsi</span><span class="pl-e">:</span><span class="pl-e">schemaLocation</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd<span class="pl-pds">"</span></span>&gt;


    &lt;<span class="pl-ent">context</span><span class="pl-ent">:</span><span class="pl-ent">component-scan</span> <span class="pl-e">base-package</span>=<span class="pl-s"><span class="pl-pds">"</span>com.baidu.cn.controller<span class="pl-pds">"</span></span>/&gt;

    &lt;<span class="pl-ent">mvc</span><span class="pl-ent">:</span><span class="pl-ent">annotation-driven</span>/&gt;
&lt;/<span class="pl-ent">beans</span>&gt;</pre></div>
<h2 dir="auto">1.4 web.xml</h2>
<div class="highlight highlight-text-xml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="&lt;web-app&gt;
 &lt;context-param&gt;
   &lt;param-name&gt;contextConfigLocation&lt;/param-name&gt;
   &lt;param-value&gt;classpath:spring.xml&lt;/param-value&gt;
 &lt;/context-param&gt;
  &lt;listener&gt;
    &lt;listener-class&gt;org.springframework.web.context.ContextLoaderListener&lt;/listener-class&gt;
  &lt;/listener&gt;
  
  &lt;servlet&gt;
    &lt;servlet-name&gt;dispatcher&lt;/servlet-name&gt;
    &lt;servlet-class&gt;org.springframework.web.servlet.DispatcherServlet&lt;/servlet-class&gt;
    &lt;init-param&gt;
      &lt;param-name&gt;contextConfigLocation&lt;/param-name&gt;
      &lt;param-value&gt;classpath:mvc.xml&lt;/param-value&gt;
    &lt;/init-param&gt;
  &lt;/servlet&gt;
  
  &lt;servlet-mapping&gt;
    &lt;servlet-name&gt;dispatcher&lt;/servlet-name&gt;
    &lt;url-pattern&gt;/&lt;/url-pattern&gt;
  &lt;/servlet-mapping&gt;
&lt;/web-app&gt;"><pre class="notranslate">&lt;<span class="pl-ent">web-app</span>&gt;
 &lt;<span class="pl-ent">context-param</span>&gt;
   &lt;<span class="pl-ent">param-name</span>&gt;contextConfigLocation&lt;/<span class="pl-ent">param-name</span>&gt;
   &lt;<span class="pl-ent">param-value</span>&gt;classpath:spring.xml&lt;/<span class="pl-ent">param-value</span>&gt;
 &lt;/<span class="pl-ent">context-param</span>&gt;
  &lt;<span class="pl-ent">listener</span>&gt;
    &lt;<span class="pl-ent">listener-class</span>&gt;org.springframework.web.context.ContextLoaderListener&lt;/<span class="pl-ent">listener-class</span>&gt;
  &lt;/<span class="pl-ent">listener</span>&gt;
  
  &lt;<span class="pl-ent">servlet</span>&gt;
    &lt;<span class="pl-ent">servlet-name</span>&gt;dispatcher&lt;/<span class="pl-ent">servlet-name</span>&gt;
    &lt;<span class="pl-ent">servlet-class</span>&gt;org.springframework.web.servlet.DispatcherServlet&lt;/<span class="pl-ent">servlet-class</span>&gt;
    &lt;<span class="pl-ent">init-param</span>&gt;
      &lt;<span class="pl-ent">param-name</span>&gt;contextConfigLocation&lt;/<span class="pl-ent">param-name</span>&gt;
      &lt;<span class="pl-ent">param-value</span>&gt;classpath:mvc.xml&lt;/<span class="pl-ent">param-value</span>&gt;
    &lt;/<span class="pl-ent">init-param</span>&gt;
  &lt;/<span class="pl-ent">servlet</span>&gt;
  
  &lt;<span class="pl-ent">servlet-mapping</span>&gt;
    &lt;<span class="pl-ent">servlet-name</span>&gt;dispatcher&lt;/<span class="pl-ent">servlet-name</span>&gt;
    &lt;<span class="pl-ent">url-pattern</span>&gt;/&lt;/<span class="pl-ent">url-pattern</span>&gt;
  &lt;/<span class="pl-ent">servlet-mapping</span>&gt;
&lt;/<span class="pl-ent">web-app</span>&gt;</pre></div>
<h2 dir="auto">1.5. tomcat start error</h2>
<div class="highlight highlight-source-java notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="	org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingDataSource': Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource]: Constructor threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
		at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:304)
		at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:285)
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1341)
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1187)
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
		at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
		at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
		at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
		at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
		at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
		at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:845)
		at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:877)
		at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
		at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:400)
		at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291)
		at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
		at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4678)
		at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5139)
		at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
		at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
		at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
		at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
		at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1727)
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
		at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
		at java.base/java.lang.reflect.Method.invoke(Method.java:566)
		at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:288)
		at java.management/com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:809)
		at java.management/com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
		at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:456)
		at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:405)
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
		at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
		at java.base/java.lang.reflect.Method.invoke(Method.java:566)
		at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:288)
		at java.management/com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:809)
		at java.management/com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
		at java.management/com.sun.jmx.remote.security.MBeanServerAccessController.invoke(MBeanServerAccessController.java:468)
		at java.management.rmi/javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1466)
		at java.management.rmi/javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1307)
		at java.base/java.security.AccessController.doPrivileged(Native Method)
		at java.management.rmi/javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1406)
		at java.management.rmi/javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:827)
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
		at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
		at java.base/java.lang.reflect.Method.invoke(Method.java:566)
		at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:359)
		at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
		at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
		at java.base/java.security.AccessController.doPrivileged(Native Method)
		at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
		at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:562)
		at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:796)
		at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:677)
		at java.base/java.security.AccessController.doPrivileged(Native Method)
		at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:676)
		at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
		at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
		at java.base/java.lang.Thread.run(Thread.java:834)
	Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource]: Constructor threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
		at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:184)
		at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:117)
		at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:300)
		... 61 more
	Caused by: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
		at com.zaxxer.hikari.util.DriverDataSource.&lt;init&gt;(DriverDataSource.java:114)
		at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:321)
		at com.zaxxer.hikari.pool.PoolBase.&lt;init&gt;(PoolBase.java:110)
		at com.zaxxer.hikari.pool.HikariPool.&lt;init&gt;(HikariPool.java:108)
		at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
		at org.apache.shardingsphere.mode.repository.standalone.jdbc.JDBCRepository.init(JDBCRepository.java:67)
		at org.apache.shardingsphere.infra.util.spi.type.required.RequiredSPIRegistry.getRegisteredService(RequiredSPIRegistry.java:45)
		at org.apache.shardingsphere.mode.repository.standalone.StandalonePersistRepositoryFactory.getInstance(StandalonePersistRepositoryFactory.java:44)
		at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:44)
		at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.createContextManager(ShardingSphereDataSource.java:76)
		at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.&lt;init&gt;(ShardingSphereDataSource.java:64)
		at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
		at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
		at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
		at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
		at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:172)
		... 63 more
	Caused by: java.sql.SQLException: No suitable driver
		at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
		at com.zaxxer.hikari.util.DriverDataSource.&lt;init&gt;(DriverDataSource.java:106)
		... 78 more"><pre class="notranslate">	<span class="pl-smi">org</span>.<span class="pl-smi">springframework</span>.<span class="pl-smi">beans</span>.<span class="pl-smi">factory</span>.<span class="pl-smi">BeanCreationException</span>: <span class="pl-s1">Error</span> <span class="pl-s1">creating</span> <span class="pl-s1">bean</span> <span class="pl-s1">with</span> <span class="pl-s1">name</span> <span class="pl-s">'shardingDataSource'</span>: <span class="pl-s1">Bean</span> <span class="pl-s1">instantiation</span> <span class="pl-s1">via</span> <span class="pl-s1">constructor</span> <span class="pl-s1">failed</span>; <span class="pl-smi">nested</span> <span class="pl-s1">exception</span> <span class="pl-smi">is</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">BeanInstantiationException</span>: <span class="pl-s1">Failed</span> <span class="pl-s1">to</span> <span class="pl-s1">instantiate</span> [<span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">driver</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">core</span>.<span class="pl-s1">datasource</span>.<span class="pl-s1">ShardingSphereDataSource</span>]: <span class="pl-s1">Constructor</span> <span class="pl-s1">threw</span> <span class="pl-s1">exception</span>; <span class="pl-smi">nested</span> <span class="pl-s1">exception</span> <span class="pl-smi">is</span> <span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">RuntimeException</span>: <span class="pl-s1">Failed</span> <span class="pl-s1">to</span> <span class="pl-s1">get</span> <span class="pl-s1">driver</span> <span class="pl-s1">instance</span> <span class="pl-s1">for</span> <span class="pl-s1">jdbcUrl</span>=<span class="pl-s1">jdbc</span>:<span class="pl-s1">h2</span>:<span class="pl-s1">mem</span>:<span class="pl-s1">config</span>;<span class="pl-c1">DB_CLOSE_DELAY</span>=-<span class="pl-c1">1</span>;<span class="pl-c1">DATABASE_TO_UPPER</span>=<span class="pl-c1">false</span>;<span class="pl-c1">MODE</span>=<span class="pl-smi">MYSQL</span>
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">ConstructorResolver</span>.<span class="pl-en">instantiate</span>(<span class="pl-smi">ConstructorResolver</span>.<span class="pl-smi">java</span>:<span class="pl-c1">304</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">ConstructorResolver</span>.<span class="pl-en">autowireConstructor</span>(<span class="pl-smi">ConstructorResolver</span>.<span class="pl-smi">java</span>:<span class="pl-c1">285</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractAutowireCapableBeanFactory</span>.<span class="pl-en">autowireConstructor</span>(<span class="pl-smi">AbstractAutowireCapableBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1341</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractAutowireCapableBeanFactory</span>.<span class="pl-en">createBeanInstance</span>(<span class="pl-smi">AbstractAutowireCapableBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1187</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractAutowireCapableBeanFactory</span>.<span class="pl-en">doCreateBean</span>(<span class="pl-smi">AbstractAutowireCapableBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">555</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractAutowireCapableBeanFactory</span>.<span class="pl-en">createBean</span>(<span class="pl-smi">AbstractAutowireCapableBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">515</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractBeanFactory</span>.<span class="pl-en">lambda$doGetBean$0</span>(<span class="pl-smi">AbstractBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">320</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">DefaultSingletonBeanRegistry</span>.<span class="pl-en">getSingleton</span>(<span class="pl-smi">DefaultSingletonBeanRegistry</span>.<span class="pl-smi">java</span>:<span class="pl-c1">222</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractBeanFactory</span>.<span class="pl-en">doGetBean</span>(<span class="pl-smi">AbstractBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">318</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractBeanFactory</span>.<span class="pl-en">getBean</span>(<span class="pl-smi">AbstractBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">199</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">DefaultListableBeanFactory</span>.<span class="pl-en">preInstantiateSingletons</span>(<span class="pl-smi">DefaultListableBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">845</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">context</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractApplicationContext</span>.<span class="pl-en">finishBeanFactoryInitialization</span>(<span class="pl-smi">AbstractApplicationContext</span>.<span class="pl-smi">java</span>:<span class="pl-c1">877</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">context</span>.<span class="pl-s1">support</span>.<span class="pl-s1">AbstractApplicationContext</span>.<span class="pl-en">refresh</span>(<span class="pl-smi">AbstractApplicationContext</span>.<span class="pl-smi">java</span>:<span class="pl-c1">549</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">web</span>.<span class="pl-s1">context</span>.<span class="pl-s1">ContextLoader</span>.<span class="pl-en">configureAndRefreshWebApplicationContext</span>(<span class="pl-smi">ContextLoader</span>.<span class="pl-smi">java</span>:<span class="pl-c1">400</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">web</span>.<span class="pl-s1">context</span>.<span class="pl-s1">ContextLoader</span>.<span class="pl-en">initWebApplicationContext</span>(<span class="pl-smi">ContextLoader</span>.<span class="pl-smi">java</span>:<span class="pl-c1">291</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">web</span>.<span class="pl-s1">context</span>.<span class="pl-s1">ContextLoaderListener</span>.<span class="pl-en">contextInitialized</span>(<span class="pl-smi">ContextLoaderListener</span>.<span class="pl-smi">java</span>:<span class="pl-c1">103</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">core</span>.<span class="pl-s1">StandardContext</span>.<span class="pl-en">listenerStart</span>(<span class="pl-smi">StandardContext</span>.<span class="pl-smi">java</span>:<span class="pl-c1">4678</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">core</span>.<span class="pl-s1">StandardContext</span>.<span class="pl-en">startInternal</span>(<span class="pl-smi">StandardContext</span>.<span class="pl-smi">java</span>:<span class="pl-c1">5139</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">util</span>.<span class="pl-s1">LifecycleBase</span>.<span class="pl-en">start</span>(<span class="pl-smi">LifecycleBase</span>.<span class="pl-smi">java</span>:<span class="pl-c1">183</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">core</span>.<span class="pl-s1">ContainerBase</span>.<span class="pl-en">addChildInternal</span>(<span class="pl-smi">ContainerBase</span>.<span class="pl-smi">java</span>:<span class="pl-c1">717</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">core</span>.<span class="pl-s1">ContainerBase</span>.<span class="pl-en">addChild</span>(<span class="pl-smi">ContainerBase</span>.<span class="pl-smi">java</span>:<span class="pl-c1">690</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">core</span>.<span class="pl-s1">StandardHost</span>.<span class="pl-en">addChild</span>(<span class="pl-smi">StandardHost</span>.<span class="pl-smi">java</span>:<span class="pl-c1">705</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">startup</span>.<span class="pl-s1">HostConfig</span>.<span class="pl-en">manageApp</span>(<span class="pl-smi">HostConfig</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1727</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeMethodAccessorImpl</span>.<span class="pl-en">invoke0</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeMethodAccessorImpl</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">NativeMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">62</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">566</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">tomcat</span>.<span class="pl-s1">util</span>.<span class="pl-s1">modeler</span>.<span class="pl-s1">BaseModelMBean</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">BaseModelMBean</span>.<span class="pl-smi">java</span>:<span class="pl-c1">288</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>/<span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">jmx</span>.<span class="pl-s1">interceptor</span>.<span class="pl-s1">DefaultMBeanServerInterceptor</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DefaultMBeanServerInterceptor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">809</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>/<span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">jmx</span>.<span class="pl-s1">mbeanserver</span>.<span class="pl-s1">JmxMBeanServer</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">JmxMBeanServer</span>.<span class="pl-smi">java</span>:<span class="pl-c1">801</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">mbeans</span>.<span class="pl-s1">MBeanFactory</span>.<span class="pl-en">createStandardContext</span>(<span class="pl-smi">MBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">456</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">catalina</span>.<span class="pl-s1">mbeans</span>.<span class="pl-s1">MBeanFactory</span>.<span class="pl-en">createStandardContext</span>(<span class="pl-smi">MBeanFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">405</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeMethodAccessorImpl</span>.<span class="pl-en">invoke0</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeMethodAccessorImpl</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">NativeMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">62</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">566</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">tomcat</span>.<span class="pl-s1">util</span>.<span class="pl-s1">modeler</span>.<span class="pl-s1">BaseModelMBean</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">BaseModelMBean</span>.<span class="pl-smi">java</span>:<span class="pl-c1">288</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>/<span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">jmx</span>.<span class="pl-s1">interceptor</span>.<span class="pl-s1">DefaultMBeanServerInterceptor</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DefaultMBeanServerInterceptor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">809</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>/<span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">jmx</span>.<span class="pl-s1">mbeanserver</span>.<span class="pl-s1">JmxMBeanServer</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">JmxMBeanServer</span>.<span class="pl-smi">java</span>:<span class="pl-c1">801</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>/<span class="pl-s1">com</span>.<span class="pl-s1">sun</span>.<span class="pl-s1">jmx</span>.<span class="pl-s1">remote</span>.<span class="pl-s1">security</span>.<span class="pl-s1">MBeanServerAccessController</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">MBeanServerAccessController</span>.<span class="pl-smi">java</span>:<span class="pl-c1">468</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">javax</span>.<span class="pl-s1">management</span>.<span class="pl-s1">remote</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">RMIConnectionImpl</span>.<span class="pl-s1">doOperation</span>(<span class="pl-smi">RMIConnectionImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1466</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">javax</span>.<span class="pl-s1">management</span>.<span class="pl-s1">remote</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">RMIConnectionImpl$PrivilegedOperation</span>.<span class="pl-en">run</span>(<span class="pl-smi">RMIConnectionImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1307</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">security</span>.<span class="pl-s1">AccessController</span>.<span class="pl-s1">doPrivileged</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">javax</span>.<span class="pl-s1">management</span>.<span class="pl-s1">remote</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">RMIConnectionImpl</span>.<span class="pl-en">doPrivilegedOperation</span>(<span class="pl-smi">RMIConnectionImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1406</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">management</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">javax</span>.<span class="pl-s1">management</span>.<span class="pl-s1">remote</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">RMIConnectionImpl</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">RMIConnectionImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">827</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeMethodAccessorImpl</span>.<span class="pl-en">invoke0</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeMethodAccessorImpl</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">NativeMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">62</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingMethodAccessorImpl</span>.<span class="pl-en">invoke</span>(<span class="pl-smi">DelegatingMethodAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">43</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Method</span>.<span class="pl-s1">invoke</span>(<span class="pl-smi">Method</span>.<span class="pl-smi">java</span>:<span class="pl-c1">566</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">server</span>.<span class="pl-s1">UnicastServerRef</span>.<span class="pl-en">dispatch</span>(<span class="pl-smi">UnicastServerRef</span>.<span class="pl-smi">java</span>:<span class="pl-c1">359</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">Transport$1</span>.<span class="pl-s1">run</span>(<span class="pl-smi">Transport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">200</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">Transport$1</span>.<span class="pl-en">run</span>(<span class="pl-smi">Transport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">197</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">security</span>.<span class="pl-s1">AccessController</span>.<span class="pl-s1">doPrivileged</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">Transport</span>.<span class="pl-en">serviceCall</span>(<span class="pl-smi">Transport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">196</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">tcp</span>.<span class="pl-s1">TCPTransport</span>.<span class="pl-s1">handleMessages</span>(<span class="pl-smi">TCPTransport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">562</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">tcp</span>.<span class="pl-s1">TCPTransport$ConnectionHandler</span>.<span class="pl-en">run0</span>(<span class="pl-smi">TCPTransport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">796</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">tcp</span>.<span class="pl-s1">TCPTransport$ConnectionHandler</span>.<span class="pl-s1">lambda$run$0</span>(<span class="pl-smi">TCPTransport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">677</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">security</span>.<span class="pl-s1">AccessController</span>.<span class="pl-en">doPrivileged</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">rmi</span>/<span class="pl-s1">sun</span>.<span class="pl-s1">rmi</span>.<span class="pl-s1">transport</span>.<span class="pl-s1">tcp</span>.<span class="pl-s1">TCPTransport$ConnectionHandler</span>.<span class="pl-s1">run</span>(<span class="pl-smi">TCPTransport</span>.<span class="pl-smi">java</span>:<span class="pl-c1">676</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">util</span>.<span class="pl-s1">concurrent</span>.<span class="pl-s1">ThreadPoolExecutor</span>.<span class="pl-en">runWorker</span>(<span class="pl-smi">ThreadPoolExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">1128</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">util</span>.<span class="pl-s1">concurrent</span>.<span class="pl-s1">ThreadPoolExecutor$Worker</span>.<span class="pl-s1">run</span>(<span class="pl-smi">ThreadPoolExecutor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">628</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">Thread</span>.<span class="pl-en">run</span>(<span class="pl-smi">Thread</span>.<span class="pl-smi">java</span>:<span class="pl-c1">834</span>)
	<span class="pl-smi">Caused</span> <span class="pl-s1">by</span>: <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">BeanInstantiationException</span>: <span class="pl-s1">Failed</span> <span class="pl-s1">to</span> <span class="pl-s1">instantiate</span> [<span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">driver</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">core</span>.<span class="pl-s1">datasource</span>.<span class="pl-s1">ShardingSphereDataSource</span>]: <span class="pl-s1">Constructor</span> <span class="pl-s1">threw</span> <span class="pl-s1">exception</span>; <span class="pl-smi">nested</span> <span class="pl-s1">exception</span> <span class="pl-smi">is</span> <span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">RuntimeException</span>: <span class="pl-s1">Failed</span> <span class="pl-s1">to</span> <span class="pl-s1">get</span> <span class="pl-s1">driver</span> <span class="pl-s1">instance</span> <span class="pl-s1">for</span> <span class="pl-s1">jdbcUrl</span>=<span class="pl-s1">jdbc</span>:<span class="pl-s1">h2</span>:<span class="pl-s1">mem</span>:<span class="pl-s1">config</span>;<span class="pl-c1">DB_CLOSE_DELAY</span>=-<span class="pl-c1">1</span>;<span class="pl-c1">DATABASE_TO_UPPER</span>=<span class="pl-c1">false</span>;<span class="pl-c1">MODE</span>=<span class="pl-smi">MYSQL</span>
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">BeanUtils</span>.<span class="pl-en">instantiateClass</span>(<span class="pl-smi">BeanUtils</span>.<span class="pl-smi">java</span>:<span class="pl-c1">184</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">SimpleInstantiationStrategy</span>.<span class="pl-en">instantiate</span>(<span class="pl-smi">SimpleInstantiationStrategy</span>.<span class="pl-smi">java</span>:<span class="pl-c1">117</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">factory</span>.<span class="pl-s1">support</span>.<span class="pl-s1">ConstructorResolver</span>.<span class="pl-en">instantiate</span>(<span class="pl-smi">ConstructorResolver</span>.<span class="pl-smi">java</span>:<span class="pl-c1">300</span>)
		... <span class="pl-c1">61</span> <span class="pl-s1">more</span>
	<span class="pl-smi">Caused</span> <span class="pl-s1">by</span>: <span class="pl-smi">java</span>.<span class="pl-smi">lang</span>.<span class="pl-smi">RuntimeException</span>: <span class="pl-s1">Failed</span> <span class="pl-k">to</span> <span class="pl-s1">get</span> <span class="pl-s1">driver</span> <span class="pl-s1">instance</span> <span class="pl-k">for</span> <span class="pl-s1">jdbcUrl</span>=<span class="pl-s1">jdbc</span>:<span class="pl-s1">h2</span>:<span class="pl-s1">mem</span>:<span class="pl-s1">config</span>;<span class="pl-c1">DB_CLOSE_DELAY</span>=-<span class="pl-c1">1</span>;<span class="pl-c1">DATABASE_TO_UPPER</span>=<span class="pl-c1">false</span>;<span class="pl-c1">MODE</span>=<span class="pl-smi">MYSQL</span>
		<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">zaxxer</span>.<span class="pl-s1">hikari</span>.<span class="pl-s1">util</span>.<span class="pl-s1">DriverDataSource</span>.&lt;<span class="pl-smi">init</span>&gt;(<span class="pl-smi">DriverDataSource</span>.<span class="pl-smi">java</span>:<span class="pl-c1">114</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">zaxxer</span>.<span class="pl-s1">hikari</span>.<span class="pl-s1">pool</span>.<span class="pl-s1">PoolBase</span>.<span class="pl-en">initializeDataSource</span>(<span class="pl-smi">PoolBase</span>.<span class="pl-smi">java</span>:<span class="pl-c1">321</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">zaxxer</span>.<span class="pl-s1">hikari</span>.<span class="pl-s1">pool</span>.<span class="pl-s1">PoolBase</span>.&lt;<span class="pl-smi">init</span>&gt;(<span class="pl-smi">PoolBase</span>.<span class="pl-smi">java</span>:<span class="pl-c1">110</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">zaxxer</span>.<span class="pl-s1">hikari</span>.<span class="pl-s1">pool</span>.<span class="pl-s1">HikariPool</span>.&lt;<span class="pl-smi">init</span>&gt;(<span class="pl-smi">HikariPool</span>.<span class="pl-smi">java</span>:<span class="pl-c1">108</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">zaxxer</span>.<span class="pl-s1">hikari</span>.<span class="pl-s1">HikariDataSource</span>.<span class="pl-en">getConnection</span>(<span class="pl-smi">HikariDataSource</span>.<span class="pl-smi">java</span>:<span class="pl-c1">112</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">mode</span>.<span class="pl-s1">repository</span>.<span class="pl-s1">standalone</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">JDBCRepository</span>.<span class="pl-en">init</span>(<span class="pl-smi">JDBCRepository</span>.<span class="pl-smi">java</span>:<span class="pl-c1">67</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">infra</span>.<span class="pl-s1">util</span>.<span class="pl-s1">spi</span>.<span class="pl-s1">type</span>.<span class="pl-s1">required</span>.<span class="pl-s1">RequiredSPIRegistry</span>.<span class="pl-en">getRegisteredService</span>(<span class="pl-smi">RequiredSPIRegistry</span>.<span class="pl-smi">java</span>:<span class="pl-c1">45</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">mode</span>.<span class="pl-s1">repository</span>.<span class="pl-s1">standalone</span>.<span class="pl-s1">StandalonePersistRepositoryFactory</span>.<span class="pl-en">getInstance</span>(<span class="pl-smi">StandalonePersistRepositoryFactory</span>.<span class="pl-smi">java</span>:<span class="pl-c1">44</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">mode</span>.<span class="pl-s1">manager</span>.<span class="pl-s1">standalone</span>.<span class="pl-s1">StandaloneContextManagerBuilder</span>.<span class="pl-en">build</span>(<span class="pl-smi">StandaloneContextManagerBuilder</span>.<span class="pl-smi">java</span>:<span class="pl-c1">44</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">driver</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">core</span>.<span class="pl-s1">datasource</span>.<span class="pl-s1">ShardingSphereDataSource</span>.<span class="pl-en">createContextManager</span>(<span class="pl-smi">ShardingSphereDataSource</span>.<span class="pl-smi">java</span>:<span class="pl-c1">76</span>)
		<span class="pl-s1">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">apache</span>.<span class="pl-s1">shardingsphere</span>.<span class="pl-s1">driver</span>.<span class="pl-s1">jdbc</span>.<span class="pl-s1">core</span>.<span class="pl-s1">datasource</span>.<span class="pl-s1">ShardingSphereDataSource</span>.&lt;<span class="pl-smi">init</span>&gt;(<span class="pl-smi">ShardingSphereDataSource</span>.<span class="pl-smi">java</span>:<span class="pl-c1">64</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeConstructorAccessorImpl</span>.<span class="pl-en">newInstance0</span>(<span class="pl-smi">Native</span> <span class="pl-s1">Method</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">NativeConstructorAccessorImpl</span>.<span class="pl-s1">newInstance</span>(<span class="pl-smi">NativeConstructorAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">62</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">jdk</span>.<span class="pl-s1">internal</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">DelegatingConstructorAccessorImpl</span>.<span class="pl-en">newInstance</span>(<span class="pl-smi">DelegatingConstructorAccessorImpl</span>.<span class="pl-smi">java</span>:<span class="pl-c1">45</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">java</span>.<span class="pl-s1">base</span>/<span class="pl-s1">java</span>.<span class="pl-s1">lang</span>.<span class="pl-s1">reflect</span>.<span class="pl-s1">Constructor</span>.<span class="pl-s1">newInstance</span>(<span class="pl-smi">Constructor</span>.<span class="pl-smi">java</span>:<span class="pl-c1">490</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">org</span>.<span class="pl-s1">springframework</span>.<span class="pl-s1">beans</span>.<span class="pl-s1">BeanUtils</span>.<span class="pl-en">instantiateClass</span>(<span class="pl-smi">BeanUtils</span>.<span class="pl-smi">java</span>:<span class="pl-c1">172</span>)
		... <span class="pl-c1">63</span> <span class="pl-s1">more</span>
	<span class="pl-smi">Caused</span> <span class="pl-s1">by</span>: <span class="pl-smi">java</span>.<span class="pl-smi">sql</span>.<span class="pl-smi">SQLException</span>: <span class="pl-s1">No</span> <span class="pl-s1">suitable</span> <span class="pl-s1">driver</span>
		<span class="pl-s1">at</span> <span class="pl-s1">java</span>.<span class="pl-smi">sql</span>/<span class="pl-s1">java</span>.<span class="pl-smi">sql</span>.<span class="pl-smi">DriverManager</span>.<span class="pl-smi">getDriver</span>(<span class="pl-smi">DriverManager</span>.<span class="pl-smi">java</span>:<span class="pl-c1">298</span>)
		<span class="pl-smi">at</span> <span class="pl-s1">com</span>.<span class="pl-s1">zaxxer</span>.<span class="pl-s1">hikari</span>.<span class="pl-s1">util</span>.<span class="pl-s1">DriverDataSource</span>.&lt;<span class="pl-smi">init</span>&gt;(<span class="pl-smi">DriverDataSource</span>.<span class="pl-smi">java</span>:<span class="pl-c1">106</span>)
		... <span class="pl-c1">78</span> <span class="pl-s1">more</span></pre></div>
<h2 dir="auto">2. My Question</h2>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="I write it  the same to Official example . Why report an error?  how to solve"><pre class="notranslate"><code class="notranslate">I write it  the same to Official example . Why report an error?  how to solve
</code></pre></div>
<p dir="auto">Sometimes shardingValue have been removed in hintShardingAlgorithm？</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="HintManager hintManager = HintManager.getInstance();
hintManager.setDatabaseShardingValue(ShardingActivitiConstant.ALL_DATASOURCES);
List&lt;Order&gt; orderList = orderService.getOrderList(); "><pre class="notranslate"><code class="notranslate">HintManager hintManager = HintManager.getInstance();
hintManager.setDatabaseShardingValue(ShardingActivitiConstant.ALL_DATASOURCES);
List&lt;Order&gt; orderList = orderService.getOrderList(); 
</code></pre></div>
<p dir="auto">same code，some times the value of the shardingValue variable as follow.<br>
<code class="notranslate">ListShardingValue(logicTableName=DB_TABLE_NAME, columnName=DB_COLUMN_NAME, values=[all])</code><br>
but sometimes, the value of the shardingValue variable as follow.<br>
<code class="notranslate">ListShardingValue(logicTableName=DB_TABLE_NAME, columnName=DB_COLUMN_NAME, values=[])</code><br>
<strong>Is shardingValue value limited?</strong></p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="@SuppressWarnings(&quot;unchecked&quot;)
    private static ShardingValue getShardingValue(final String logicTable, final Collection&lt;Comparable&lt;?&gt;&gt; values) {
        Preconditions.checkArgument(null != values &amp;&amp; !values.isEmpty());
        return new ListShardingValue(logicTable, DB_COLUMN_NAME, values);
    }"><pre class="notranslate"><code class="notranslate">@SuppressWarnings("unchecked")
    private static ShardingValue getShardingValue(final String logicTable, final Collection&lt;Comparable&lt;?&gt;&gt; values) {
        Preconditions.checkArgument(null != values &amp;&amp; !values.isEmpty());
        return new ListShardingValue(logicTable, DB_COLUMN_NAME, values);
    }
</code></pre></div>
<p dir="auto">ps: I use this version</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="&lt;dependency&gt;
	&lt;groupId&gt;io.shardingsphere&lt;/groupId&gt;
	&lt;artifactId&gt;sharding-jdbc-spring-boot-starter&lt;/artifactId&gt;
	&lt;version&gt;3.0.0&lt;/version&gt;
&lt;/dependency&gt;
"><pre class="notranslate"><code class="notranslate">&lt;dependency&gt;
	&lt;groupId&gt;io.shardingsphere&lt;/groupId&gt;
	&lt;artifactId&gt;sharding-jdbc-spring-boot-starter&lt;/artifactId&gt;
	&lt;version&gt;3.0.0&lt;/version&gt;
&lt;/dependency&gt;

</code></pre></div>
<p dir="auto">I find this class.<br>
HintManagerHolder.Class:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content=" private static final Multimap&lt;String, Comparable&lt;?&gt;&gt; DATABASE_SHARDING_VALUES = HashMultimap.create();
    
private static final Multimap&lt;String, Comparable&lt;?&gt;&gt; TABLE_SHARDING_VALUES = HashMultimap.create();"><pre class="notranslate"><code class="notranslate"> private static final Multimap&lt;String, Comparable&lt;?&gt;&gt; DATABASE_SHARDING_VALUES = HashMultimap.create();
    
private static final Multimap&lt;String, Comparable&lt;?&gt;&gt; TABLE_SHARDING_VALUES = HashMultimap.create();
</code></pre></div>
<p dir="auto">not threadlocal params, I think this may be problem!</p>