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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="rdl_test_1| MySQL| mysql.empty_rules.host| 3306| rdl_test_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="rdl_test_2| MySQL| mysql.empty_rules.host| 3306| rdl_test_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="rdl_test_1| MySQL| mysql.empty_rules.host| 3306| rdl_test_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="rdl_test_2| MySQL| mysql.empty_rules.host| 3306| rdl_test_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
<row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| {"maxLifetimeMilliseconds":180000,"readOnly":false,"minPoolSize":10,"idleTimeoutMilliseconds":6000,"maxPoolSize":10,"connectionTimeoutMilliseconds":3000}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_1| MySQL| mysql.db.host| 3306| db_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_2| MySQL| mysql.db.host| 3306| db_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_3| MySQL| mysql.db.host| 3306| db_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_4| MySQL| mysql.db.host| 3306| db_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_5| MySQL| mysql.db.host| 3306| db_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_6| MySQL| mysql.db.host| 3306| db_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_7| MySQL| mysql.db.host| 3306| db_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_8| MySQL| mysql.db.host| 3306| db_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_9| MySQL| mysql.db.host| 3306| db_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="ds_0| MySQL| mysql.db.host| 3306| db_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_1| MySQL| mysql.db.host| 3306| db_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_2| MySQL| mysql.db.host| 3306| db_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_3| MySQL| mysql.db.host| 3306| db_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_4| MySQL| mysql.db.host| 3306| db_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_5| MySQL| mysql.db.host| 3306| db_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_6| MySQL| mysql.db.host| 3306| db_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_7| MySQL| mysql.db.host| 3306| db_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_8| MySQL| mysql.db.host| 3306| db_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_9| MySQL| mysql.db.host| 3306| db_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="ds_0| PostgreSQL| postgresql.db.host| 5432| db_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_2| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_3| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_4| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_5| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_6| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_7| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_8| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="encrypt_read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_9| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="encrypt_write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_2| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_3| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_4| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_5| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_6| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_7| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_8| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="encrypt_read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_9| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="encrypt| MySQL| mysql.encrypt.host| 3306| encrypt| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="encrypt| PostgreSQL| postgresql.encrypt.host| 5432| encrypt| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_0| MySQL| mysql.readwrite_splitting.host| 3306| read_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_1| MySQL| mysql.readwrite_splitting.host| 3306| read_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="write_ds| MySQL| mysql.readwrite_splitting.host| 3306| write_ds| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_0| MySQL| mysql.readwrite_splitting.host| 3306| read_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_1| MySQL| mysql.readwrite_splitting.host| 3306| read_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_0| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
- <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_1| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="write_ds| PostgreSQL| postgresql.readwrite_splitting.host| 5432| write_ds| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_0| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
+ <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_1| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="governance_db| MySQL| mysql.sharding_governance.host| 3306| governance_db| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</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| {"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}" />
+ <row values="tbl| MySQL| mysql.tbl.host| 3306| tbl| {"connectionTimeoutMilliseconds":30000,"idleTimeoutMilliseconds":60000,"maxLifetimeMilliseconds":1800000,"maxPoolSize":2,"minPoolSize":2,"readOnly":false}" />
</dataset>