You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2022/01/03 23:27:45 UTC

[shardingsphere] branch master updated: Remove DataSourceParameter usage from DataSourceQueryResultSet (#14489)

This is an automated email from the ASF dual-hosted git repository.

panjuan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new e833ec7  Remove DataSourceParameter usage from DataSourceQueryResultSet (#14489)
e833ec7 is described below

commit e833ec7bd85d08c0c1d2a1ece869412e1f55d6e5
Author: Liang Zhang <te...@163.com>
AuthorDate: Tue Jan 4 07:26:39 2022 +0800

    Remove DataSourceParameter usage from DataSourceQueryResultSet (#14489)
---
 .../distsql/syntax/rql/resource-query.cn.md        |  8 +-
 .../distsql/syntax/rql/resource-query.en.md        |  8 +-
 .../rql/resource/DataSourceQueryResultSet.java     | 56 ++++++++------
 .../DataSourceQueryResultSetConverter.java         | 89 ----------------------
 .../rql/DataSourceQueryResultSetConverterTest.java | 62 ---------------
 .../distsql/rql/DataSourceQueryResultSetTest.java  | 47 ++++++++----
 .../rdl/dataset/empty_rules/mysql/add_resource.xml | 46 +++++------
 .../dataset/empty_rules/mysql/alter_resource.xml   | 40 +++++-----
 .../dataset/empty_rules/mysql/drop_resource.xml    | 40 +++++-----
 .../cases/rql/dataset/db/mysql/show_resources.xml  | 20 ++---
 .../rql/dataset/db/postgresql/show_resources.xml   | 20 ++---
 .../mysql/show_resources.xml                       | 40 +++++-----
 .../postgresql/show_resources.xml                  | 40 +++++-----
 .../mysql/show_resources.xml                       | 40 +++++-----
 .../rql/dataset/encrypt/mysql/show_resources.xml   |  2 +-
 .../dataset/encrypt/postgresql/show_resources.xml  |  2 +-
 .../readwrite_splitting/mysql/show_resources.xml   |  6 +-
 .../postgresql/show_resources.xml                  |  6 +-
 .../sharding_governance/mysql/show_resources.xml   |  2 +-
 .../cases/rql/dataset/tbl/mysql/show_resources.xml |  2 +-
 20 files changed, 224 insertions(+), 352 deletions(-)

diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.cn.md
index 3a66fa7..460a560 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.cn.md
@@ -24,11 +24,11 @@ SHOW SCHEMA RESOURCES [FROM schemaName]
 
 ```sql
 mysql> show schema resources;
-+------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| name | type  | host      | port | db   | attribute                                                                                                                                                                                           |
-+------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++------+-------+-----------+------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type  | host      | port | db   | attribute                                                                                                                                                   |
++------+-------+-----------+------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
 | ds_0 | MySQL | 127.0.0.1 | 3306 | ds_0 | {"minPoolSize":1,"connectionTimeoutMilliseconds":30000,"maxLifetimeMilliseconds":1800000,"readOnly":false,"idleTimeoutMilliseconds":60000,"maxPoolSize":50} |
 | ds_1 | MySQL | 127.0.0.1 | 3306 | ds_1 | {"minPoolSize":1,"connectionTimeoutMilliseconds":30000,"maxLifetimeMilliseconds":1800000,"readOnly":false,"idleTimeoutMilliseconds":60000,"maxPoolSize":50} |
-+------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++------+-------+-----------+------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
 2 rows in set (0.84 sec)
 ```
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.en.md
index b1ecff5..1111fe2 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query.en.md
@@ -24,11 +24,11 @@ SHOW SCHEMA RESOURCES [FROM schemaName]
 
 ```sql
 mysql> show schema resources;
-+------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| name | type  | host      | port | db   | attribute                                                                                                                                                                                           |
-+------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++------+-------+-----------+------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type  | host      | port | db   | attribute                                                                                                                                                   |
++------+-------+-----------+------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
 | ds_0 | MySQL | 127.0.0.1 | 3306 | ds_0 | {"minPoolSize":1,"connectionTimeoutMilliseconds":30000,"maxLifetimeMilliseconds":1800000,"readOnly":false,"idleTimeoutMilliseconds":60000,"maxPoolSize":50} |
 | ds_1 | MySQL | 127.0.0.1 | 3306 | ds_1 | {"minPoolSize":1,"connectionTimeoutMilliseconds":30000,"maxLifetimeMilliseconds":1800000,"readOnly":false,"idleTimeoutMilliseconds":60000,"maxPoolSize":50} |
-+------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++------+-------+-----------+------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
 2 rows in set (0.84 sec)
 ```
diff --git a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSet.java b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSet.java
index 9bf76a6..fecaec0 100644
--- a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSet.java
+++ b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSet.java
@@ -20,8 +20,8 @@ package org.apache.shardingsphere.proxy.backend.text.distsql.rql.resource;
 import com.google.gson.Gson;
 import org.apache.shardingsphere.distsql.parser.statement.rql.show.ShowResourcesStatement;
 import org.apache.shardingsphere.infra.config.datasource.DataSourceConfiguration;
-import org.apache.shardingsphere.infra.config.datasource.pool.creator.DataSourcePoolCreatorUtil;
 import org.apache.shardingsphere.infra.config.datasource.DataSourceParameter;
+import org.apache.shardingsphere.infra.config.datasource.pool.creator.DataSourcePoolCreatorUtil;
 import org.apache.shardingsphere.infra.database.metadata.DataSourceMetaData;
 import org.apache.shardingsphere.infra.distsql.query.DistSQLResultSet;
 import org.apache.shardingsphere.infra.metadata.ShardingSphereMetaData;
@@ -32,8 +32,8 @@ import org.apache.shardingsphere.sql.parser.sql.common.statement.SQLStatement;
 
 import java.util.Arrays;
 import java.util.Collection;
-import java.util.HashMap;
 import java.util.Iterator;
+import java.util.LinkedHashMap;
 import java.util.Map;
 import java.util.Optional;
 
@@ -42,21 +42,20 @@ import java.util.Optional;
  */
 public final class DataSourceQueryResultSet implements DistSQLResultSet {
     
-    private Map<String, DataSourceParameter> dataSourceParameterMap;
+    private ShardingSphereResource resource;
     
-    private Iterator<String> dataSourceNames;
+    private Map<String, DataSourceConfiguration> dataSourceConfigs;
     
-    private ShardingSphereResource resource;
+    private Iterator<String> dataSourceNames;
     
     @Override
     public void init(final ShardingSphereMetaData metaData, final SQLStatement sqlStatement) {
         resource = metaData.getResource();
         Optional<MetaDataPersistService> persistService = ProxyContext.getInstance().getContextManager().getMetaDataContexts().getMetaDataPersistService();
-        Map<String, DataSourceConfiguration> dataSourceConfigs = persistService.isPresent()
+        dataSourceConfigs = persistService.isPresent()
                 ? persistService.get().getDataSourceService().load(metaData.getName())
                 : DataSourcePoolCreatorUtil.getDataSourceConfigurationMap(metaData.getResource().getDataSources());
-        dataSourceParameterMap = DataSourceQueryResultSetConverter.covert(dataSourceConfigs);
-        dataSourceNames = dataSourceParameterMap.keySet().iterator();
+        dataSourceNames = dataSourceConfigs.keySet().iterator();
     }
     
     @Override
@@ -72,28 +71,37 @@ public final class DataSourceQueryResultSet implements DistSQLResultSet {
     @Override
     public Collection<Object> getRowData() {
         String dataSourceName = dataSourceNames.next();
-        DataSourceMetaData dataSourceMetaData = resource.getDataSourcesMetaData().getDataSourceMetaData(dataSourceName);
-        String type = resource.getDatabaseType().getName();
-        String host = dataSourceMetaData.getHostname();
-        int port = dataSourceMetaData.getPort();
-        String db = dataSourceMetaData.getCatalog();
-        return Arrays.asList(dataSourceName, type, host, port, db, (new Gson()).toJson(getAttributeMap(dataSourceParameterMap.get(dataSourceName))));
+        DataSourceMetaData metaData = resource.getDataSourcesMetaData().getDataSourceMetaData(dataSourceName);
+        return Arrays.asList(dataSourceName, resource.getDatabaseType().getName(), 
+                metaData.getHostname(), metaData.getPort(), metaData.getCatalog(), (new Gson()).toJson(getAttributeMap(dataSourceConfigs.get(dataSourceName))));
     }
     
-    private Map<Object, Object> getAttributeMap(final DataSourceParameter dataSourceParameter) {
-        Map<Object, Object> result = new HashMap<>(7, 1);
-        result.put("connectionTimeoutMilliseconds", dataSourceParameter.getConnectionTimeoutMilliseconds());
-        result.put("idleTimeoutMilliseconds", dataSourceParameter.getIdleTimeoutMilliseconds());
-        result.put("maxLifetimeMilliseconds", dataSourceParameter.getMaxLifetimeMilliseconds());
-        result.put("maxPoolSize", dataSourceParameter.getMaxPoolSize());
-        result.put("minPoolSize", dataSourceParameter.getMinPoolSize());
-        result.put("readOnly", dataSourceParameter.isReadOnly());
-        if (null != dataSourceParameter.getCustomPoolProps() && !dataSourceParameter.getCustomPoolProps().isEmpty()) {
-            result.put("customPoolProps", dataSourceParameter.getCustomPoolProps());
+    private Map<String, Object> getAttributeMap(final DataSourceConfiguration dataSourceConfig) {
+        Map<String, Object> result = new LinkedHashMap<>(7, 1);
+        result.put("connectionTimeoutMilliseconds", getProperty(dataSourceConfig, "connectionTimeoutMilliseconds", DataSourceParameter.DEFAULT_CONNECTION_TIMEOUT_MILLISECONDS, "connectionTimeout"));
+        result.put("idleTimeoutMilliseconds", getProperty(dataSourceConfig, "idleTimeoutMilliseconds", DataSourceParameter.DEFAULT_IDLE_TIMEOUT_MILLISECONDS, "idleTimeout"));
+        result.put("maxLifetimeMilliseconds", getProperty(dataSourceConfig, "maxLifetimeMilliseconds", DataSourceParameter.DEFAULT_MAX_LIFETIME_MILLISECONDS, "maxLifetime"));
+        result.put("maxPoolSize", getProperty(dataSourceConfig, "maxPoolSize", DataSourceParameter.DEFAULT_MAX_POOL_SIZE, "maximumPoolSize"));
+        result.put("minPoolSize", getProperty(dataSourceConfig, "minPoolSize", DataSourceParameter.DEFAULT_MIN_POOL_SIZE, "minimumIdle"));
+        result.put("readOnly", getProperty(dataSourceConfig, "readOnly", DataSourceParameter.DEFAULT_READ_ONLY));
+        if (!dataSourceConfig.getCustomPoolProps().isEmpty()) {
+            result.put(DataSourceConfiguration.CUSTOM_POOL_PROPS_KEY, dataSourceConfig.getCustomPoolProps());
         }
         return result;
     }
     
+    private Object getProperty(final DataSourceConfiguration dataSourceConfig, final String key, final Object defaultValue, final String... synonym) {
+        if (dataSourceConfig.getProps().containsKey(key)) {
+            return dataSourceConfig.getProps().get(key);
+        }
+        for (String each : synonym) {
+            if (dataSourceConfig.getProps().containsKey(each)) {
+                return dataSourceConfig.getProps().get(each);
+            }
+        }
+        return defaultValue;
+    }
+    
     @Override
     public String getType() {
         return ShowResourcesStatement.class.getCanonicalName();
diff --git a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSetConverter.java b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSetConverter.java
deleted file mode 100644
index 902c8ca..0000000
--- a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/resource/DataSourceQueryResultSetConverter.java
+++ /dev/null
@@ -1,89 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements.  See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License.  You may obtain a copy of the License at
- *
- *     http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.proxy.backend.text.distsql.rql.resource;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.infra.config.datasource.DataSourceConfiguration;
-import org.apache.shardingsphere.infra.config.datasource.DataSourceParameter;
-
-import java.lang.reflect.Field;
-import java.util.LinkedHashMap;
-import java.util.Map;
-import java.util.Map.Entry;
-import java.util.stream.Collectors;
-
-/**
- * Data source query result set converter.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class DataSourceQueryResultSetConverter {
-    
-    /**
-     * Convert to data source parameter map.
-     *
-     * @param dataSourceConfigMap data source configuration map
-     * @return data source parameter map
-     */
-    public static Map<String, DataSourceParameter> covert(final Map<String, DataSourceConfiguration> dataSourceConfigMap) {
-        return dataSourceConfigMap.entrySet().stream().collect(Collectors.toMap(Entry::getKey, entry -> covert(entry.getValue()), (oldValue, currentValue) -> oldValue, LinkedHashMap::new));
-    }
-    
-    private static DataSourceParameter covert(final DataSourceConfiguration dataSourceConfig) {
-        bindSynonym(dataSourceConfig);
-        DataSourceParameter result = new DataSourceParameter();
-        for (Field each : result.getClass().getDeclaredFields()) {
-            try {
-                Object dataSourceConfigProp =
-                        DataSourceConfiguration.CUSTOM_POOL_PROPS_KEY.equals(each.getName()) ? dataSourceConfig.getCustomPoolProps() : dataSourceConfig.getProps().get(each.getName());
-                if (null == dataSourceConfigProp) {
-                    continue;
-                }
-                each.setAccessible(true);
-                setDataSourceParameterField(each, result, dataSourceConfigProp);
-            } catch (final ReflectiveOperationException ignored) {
-            }
-        }
-        return result;
-    }
-    
-    private static void bindSynonym(final DataSourceConfiguration dataSourceConfig) {
-        dataSourceConfig.addPropertySynonym("url", "jdbcUrl");
-        dataSourceConfig.addPropertySynonym("user", "username");
-        dataSourceConfig.addPropertySynonym("connectionTimeout", "connectionTimeoutMilliseconds");
-        dataSourceConfig.addPropertySynonym("maxLifetime", "maxLifetimeMilliseconds");
-        dataSourceConfig.addPropertySynonym("idleTimeout", "idleTimeoutMilliseconds");
-        dataSourceConfig.addPropertySynonym("maxPoolSize", "maximumPoolSize");
-        dataSourceConfig.addPropertySynonym("minPoolSize", "minimumIdle");
-    }
-    
-    private static void setDataSourceParameterField(final Field field, final DataSourceParameter target, final Object value) throws IllegalAccessException {
-        Class<?> fieldType = field.getType();
-        if (fieldType == int.class) {
-            field.set(target, Integer.parseInt(value.toString()));
-        } else if (fieldType == long.class) {
-            field.set(target, Long.parseLong(value.toString()));
-        } else if (fieldType == boolean.class) {
-            field.set(target, Boolean.parseBoolean(value.toString()));
-        } else if (fieldType == String.class) {
-            field.set(target, value.toString());
-        } else {
-            field.set(target, value);
-        }
-    }
-}
diff --git a/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetConverterTest.java b/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetConverterTest.java
deleted file mode 100644
index cbe6ae6..0000000
--- a/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetConverterTest.java
+++ /dev/null
@@ -1,62 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements.  See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License.  You may obtain a copy of the License at
- *
- *     http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.proxy.backend.text.distsql.rql;
-
-import com.zaxxer.hikari.HikariDataSource;
-import org.apache.shardingsphere.infra.config.datasource.DataSourceConfiguration;
-import org.apache.shardingsphere.infra.config.datasource.DataSourceParameter;
-import org.apache.shardingsphere.proxy.backend.text.distsql.rql.resource.DataSourceQueryResultSetConverter;
-import org.junit.Test;
-
-import java.util.HashMap;
-import java.util.LinkedHashMap;
-import java.util.Map;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.junit.Assert.assertFalse;
-import static org.junit.Assert.assertThat;
-
-public final class DataSourceQueryResultSetConverterTest {
-    
-    @Test
-    public void assertGetDataSourceParameterMap() {
-        Map<String, Object> props = new LinkedHashMap<>();
-        props.put("maximumPoolSize", 10);
-        props.put("connectionTimeout", "30000");
-        props.put("readOnly", false);
-        Map<String, DataSourceConfiguration> dataSourceConfigurationMap = new HashMap<>(2, 1);
-        DataSourceConfiguration dataSourceConfiguration0 = new DataSourceConfiguration(HikariDataSource.class.getName());
-        dataSourceConfiguration0.getProps().put("url", "jdbc:mysql://localhost:3306/demo_ds_0");
-        dataSourceConfiguration0.getProps().putAll(props);
-        dataSourceConfigurationMap.put("ds_0", dataSourceConfiguration0);
-        DataSourceConfiguration dataSourceConfiguration1 = new DataSourceConfiguration(HikariDataSource.class.getName());
-        dataSourceConfiguration1.getProps().put("jdbcUrl", "jdbc:mysql://localhost:3306/demo_ds_1");
-        dataSourceConfiguration1.getProps().putAll(props);
-        dataSourceConfigurationMap.put("ds_1", dataSourceConfiguration1);
-        Map<String, DataSourceParameter> actual = DataSourceQueryResultSetConverter.covert(dataSourceConfigurationMap);
-        assertThat(actual.size(), is(2));
-        assertThat(actual.get("ds_0").getUrl(), is("jdbc:mysql://localhost:3306/demo_ds_0"));
-        assertThat(actual.get("ds_0").getMaxPoolSize(), is(10));
-        assertThat(actual.get("ds_0").getConnectionTimeoutMilliseconds(), is(30000L));
-        assertFalse(actual.get("ds_1").isReadOnly());
-        assertThat(actual.get("ds_1").getUrl(), is("jdbc:mysql://localhost:3306/demo_ds_1"));
-        assertThat(actual.get("ds_1").getMaxPoolSize(), is(10));
-        assertThat(actual.get("ds_1").getConnectionTimeoutMilliseconds(), is(30000L));
-        assertFalse(actual.get("ds_1").isReadOnly());
-    }
-}
diff --git a/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetTest.java b/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetTest.java
index ca25486..975b6f4 100644
--- a/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetTest.java
+++ b/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/distsql/rql/DataSourceQueryResultSetTest.java
@@ -60,19 +60,33 @@ public final class DataSourceQueryResultSetTest {
     
     @Before
     public void before() {
-        String url = "jdbc:mysql://localhost:3306/demo_ds?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8";
-        DatabaseAccessConfiguration configuration = new DatabaseAccessConfiguration(url, "root");
-        Map<String, DatabaseAccessConfiguration> databaseAccessConfigs = new HashMap<>(1, 1);
-        databaseAccessConfigs.put("ds_0", configuration);
-        Map<String, DataSource> dataSourceMap = new HashMap<>(1, 1);
-        MockedDataSource ds0 = mock(MockedDataSource.class);
-        dataSourceMap.put("ds_0", ds0);
         DatabaseType databaseType = new MySQLDatabaseType();
-        DataSourcesMetaData dataSourcesMetaData = new DataSourcesMetaData(databaseType, databaseAccessConfigs);
-        ShardingSphereResource resource = new ShardingSphereResource(dataSourceMap, dataSourcesMetaData, null, databaseType);
+        DataSourcesMetaData dataSourcesMetaData = new DataSourcesMetaData(databaseType, createDatabaseAccessConfigurationMap());
+        ShardingSphereResource resource = new ShardingSphereResource(createDataSourceMap(), dataSourcesMetaData, null, databaseType);
         when(shardingSphereMetaData.getResource()).thenReturn(resource);
     }
     
+    private Map<String, DatabaseAccessConfiguration> createDatabaseAccessConfigurationMap() {
+        Map<String, DatabaseAccessConfiguration> result = new HashMap<>(1, 1);
+        result.put("ds_0", new DatabaseAccessConfiguration("jdbc:mysql://localhost/demo_ds", "root"));
+        return result;
+    }
+    
+    private Map<String, DataSource> createDataSourceMap() {
+        Map<String, DataSource> result = new HashMap<>(1, 1);
+        MockedDataSource ds0 = createDataSource();
+        result.put("ds_0", ds0);
+        return result;
+    }
+    
+    private MockedDataSource createDataSource() {
+        MockedDataSource result = new MockedDataSource();
+        result.setUrl("jdbc:mysql://localhost/demo_ds");
+        result.setUsername("root");
+        result.setPassword("password");
+        return result;
+    }
+    
     @Test
     public void assertGetRowData() {
         ContextManager manager = mock(ContextManager.class);
@@ -89,11 +103,11 @@ public final class DataSourceQueryResultSetTest {
         assertThat(rowData.next(), is("localhost"));
         assertThat(rowData.next(), is(3306));
         assertThat(rowData.next(), is("demo_ds"));
-        assertThat(rowData.next(), is("{\"maxLifetimeMilliseconds\":1800000,\"readOnly\":false,"
-                + "\"minPoolSize\":1,\"idleTimeoutMilliseconds\":60000,\"maxPoolSize\":50,\"connectionTimeoutMilliseconds\":30000}"));
+        assertThat(rowData.next(), 
+                is("{\"connectionTimeoutMilliseconds\":30000,\"idleTimeoutMilliseconds\":60000,\"maxLifetimeMilliseconds\":1800000,\"maxPoolSize\":50,\"minPoolSize\":1,\"readOnly\":false}"));
         MetaDataPersistService persistService = mock(MetaDataPersistService.class, RETURNS_DEEP_STUBS);
-        when(persistService.getDataSourceService().load(any())).thenReturn(mockDataSourceConfigurationMap());
-        when(manager.getMetaDataContexts().getMetaDataPersistService()).thenReturn(Optional.ofNullable(persistService));
+        when(persistService.getDataSourceService().load(any())).thenReturn(createDataSourceConfigurationMap());
+        when(manager.getMetaDataContexts().getMetaDataPersistService()).thenReturn(Optional.of(persistService));
         resultSet.init(shardingSphereMetaData, mock(ShowResourcesStatement.class));
         actual = resultSet.getRowData();
         assertThat(actual.size(), is(6));
@@ -103,11 +117,12 @@ public final class DataSourceQueryResultSetTest {
         assertThat(rowData.next(), is("localhost"));
         assertThat(rowData.next(), is(3306));
         assertThat(rowData.next(), is("demo_ds"));
-        assertThat(rowData.next(), is("{\"maxLifetimeMilliseconds\":1800000,\"readOnly\":true,\"customPoolProps\":{\"test\":\"test\"},"
-                + "\"minPoolSize\":1,\"idleTimeoutMilliseconds\":60000,\"maxPoolSize\":50,\"connectionTimeoutMilliseconds\":30000}"));
+        assertThat(rowData.next(), 
+                is("{\"connectionTimeoutMilliseconds\":30000,\"idleTimeoutMilliseconds\":60000,\"maxLifetimeMilliseconds\":1800000,\"maxPoolSize\":50,\"minPoolSize\":1,"
+                        + "\"readOnly\":true,\"customPoolProps\":{\"test\":\"test\"}}"));
     }
     
-    private Map<String, DataSourceConfiguration> mockDataSourceConfigurationMap() {
+    private Map<String, DataSourceConfiguration> createDataSourceConfigurationMap() {
         Map<String, DataSourceConfiguration> result = new HashMap<>();
         DataSourceConfiguration ds0 = new DataSourceConfiguration("ds_0");
         ds0.getCustomPoolProps().put("test", "test");
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml
index eff0c3ae..e2e62a6 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml
@@ -24,27 +24,27 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="rdl_test_1| MySQL| mysql.empty_rules.host| 3306| rdl_test_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="rdl_test_2| MySQL| mysql.empty_rules.host| 3306| rdl_test_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="rdl_test_1| MySQL| mysql.empty_rules.host| 3306| rdl_test_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="rdl_test_2| MySQL| mysql.empty_rules.host| 3306| rdl_test_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml
index fe57231..dff23b2 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml
@@ -24,25 +24,25 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
     <row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;180000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;10&#44;&quot;idleTimeoutMilliseconds&quot;&#58;6000&#44;&quot;maxPoolSize&quot;&#58;10&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;3000&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml
index b7b99a8..9645da3 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml
@@ -24,24 +24,24 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/mysql/show_resources.xml
index a7ed8be..6491f8d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/mysql/show_resources.xml
@@ -24,14 +24,14 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="ds_0| MySQL| mysql.db.host| 3306| db_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_1| MySQL| mysql.db.host| 3306| db_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_2| MySQL| mysql.db.host| 3306| db_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_3| MySQL| mysql.db.host| 3306| db_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_4| MySQL| mysql.db.host| 3306| db_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_5| MySQL| mysql.db.host| 3306| db_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_6| MySQL| mysql.db.host| 3306| db_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_7| MySQL| mysql.db.host| 3306| db_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_8| MySQL| mysql.db.host| 3306| db_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_9| MySQL| mysql.db.host| 3306| db_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="ds_0| MySQL| mysql.db.host| 3306| db_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_1| MySQL| mysql.db.host| 3306| db_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_2| MySQL| mysql.db.host| 3306| db_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_3| MySQL| mysql.db.host| 3306| db_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_4| MySQL| mysql.db.host| 3306| db_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_5| MySQL| mysql.db.host| 3306| db_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_6| MySQL| mysql.db.host| 3306| db_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_7| MySQL| mysql.db.host| 3306| db_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_8| MySQL| mysql.db.host| 3306| db_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_9| MySQL| mysql.db.host| 3306| db_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml
index 1a570e6..b3d734d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml
@@ -24,14 +24,14 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="ds_0| PostgreSQL| postgresql.db.host| 5432| db_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="ds_0| PostgreSQL| postgresql.db.host| 5432| db_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_resources.xml
index 48e3bf3..9f300b1 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_resources.xml
@@ -24,24 +24,24 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml
index ad5ddc2..66e57d4 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml
@@ -24,24 +24,24 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/mysql/show_resources.xml
index 9d7b5fd..ad9dfe9 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/mysql/show_resources.xml
@@ -24,24 +24,24 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="encrypt_write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_2| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_3| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_4| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_5| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_6| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_7| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_8| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="encrypt_read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_9| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="encrypt_write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_2| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_3| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_4| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_5| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_6| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_7| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_8| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="encrypt_read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_9| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/mysql/show_resources.xml
index c43bec9..005e96f 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/mysql/show_resources.xml
@@ -24,5 +24,5 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="encrypt| MySQL| mysql.encrypt.host| 3306| encrypt| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="encrypt| MySQL| mysql.encrypt.host| 3306| encrypt| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml
index 8bd6492..8cc0337 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml
@@ -24,5 +24,5 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="encrypt| PostgreSQL| postgresql.encrypt.host| 5432| encrypt| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="encrypt| PostgreSQL| postgresql.encrypt.host| 5432| encrypt| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/mysql/show_resources.xml
index 335bfee..377a6ef 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/mysql/show_resources.xml
@@ -24,7 +24,7 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="write_ds| MySQL| mysql.readwrite_splitting.host| 3306| write_ds| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_0| MySQL| mysql.readwrite_splitting.host| 3306| read_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_1| MySQL| mysql.readwrite_splitting.host| 3306| read_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="write_ds| MySQL| mysql.readwrite_splitting.host| 3306| write_ds| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_0| MySQL| mysql.readwrite_splitting.host| 3306| read_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_1| MySQL| mysql.readwrite_splitting.host| 3306| read_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml
index d495a01..4fdf021 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml
@@ -24,7 +24,7 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="write_ds| PostgreSQL| postgresql.readwrite_splitting.host| 5432| write_ds| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_0| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
-    <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_1| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="write_ds| PostgreSQL| postgresql.readwrite_splitting.host| 5432| write_ds| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_0| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
+    <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_1| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_governance/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_governance/mysql/show_resources.xml
index fd480d8..47e1e18 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_governance/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_governance/mysql/show_resources.xml
@@ -24,5 +24,5 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="governance_db| MySQL| mysql.sharding_governance.host| 3306| governance_db| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="governance_db| MySQL| mysql.sharding_governance.host| 3306| governance_db| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/mysql/show_resources.xml
index 5690682..6a0c12c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/mysql/show_resources.xml
@@ -24,5 +24,5 @@
         <column name="db" />
         <column name="attribute" />
     </metadata>
-    <row values="tbl| MySQL| mysql.tbl.host| 3306| tbl| &#123;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;readOnly&quot;&#58;false&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#125;" />
+    <row values="tbl| MySQL| mysql.tbl.host| 3306| tbl| &#123;&quot;connectionTimeoutMilliseconds&quot;&#58;30000&#44;&quot;idleTimeoutMilliseconds&quot;&#58;60000&#44;&quot;maxLifetimeMilliseconds&quot;&#58;1800000&#44;&quot;maxPoolSize&quot;&#58;2&#44;&quot;minPoolSize&quot;&#58;2&#44;&quot;readOnly&quot;&#58;false&#125;" />
 </dataset>