You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2022/08/18 14:20:40 UTC
[shardingsphere] branch master updated: Filter poolName when execute show database resources (#20274)
This is an automated email from the ASF dual-hosted git repository.
zhonghongsheng 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 6108f185607 Filter poolName when execute show database resources (#20274)
6108f185607 is described below
commit 6108f18560738baba98b359c9219e8d0dd91d313
Author: zhaojinchao <zh...@apache.org>
AuthorDate: Thu Aug 18 22:20:34 2022 +0800
Filter poolName when execute show database resources (#20274)
* Add poolName to TRANSIENT_FIELD_NAMES
* Remove poolName for xml
---
.../type/hikari/HikariDataSourcePoolMetaData.java | 1 +
.../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 +++++++++++-----------
.../postgresql/show_resources.xml | 40 +++++++++++-----------
.../rql/dataset/encrypt/mysql/show_resources.xml | 2 +-
.../dataset/encrypt/postgresql/show_resources.xml | 2 +-
.../mysql/show_resources.xml | 4 +--
.../postgresql/show_resources.xml | 4 +--
.../readwrite_splitting/mysql/show_resources.xml | 6 ++--
.../postgresql/show_resources.xml | 6 ++--
.../sharding_and_encrypt/mysql/show_resources.xml | 20 +++++------
.../postgresql/show_resources.xml | 20 +++++------
.../sharding_governance/mysql/show_resources.xml | 2 +-
.../cases/rql/dataset/tbl/mysql/show_resources.xml | 2 +-
.../rql/dataset/tbl/postgresql/show_resources.xml | 2 +-
18 files changed, 136 insertions(+), 135 deletions(-)
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/datasource/pool/metadata/type/hikari/HikariDataSourcePoolMetaData.java b/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/datasource/pool/metadata/type/hikari/HikariDataSourcePoolMetaData.java
index f0686a0a712..88a67ef1254 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/datasource/pool/metadata/type/hikari/HikariDataSourcePoolMetaData.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/datasource/pool/metadata/type/hikari/HikariDataSourcePoolMetaData.java
@@ -69,6 +69,7 @@ public final class HikariDataSourcePoolMetaData implements DataSourcePoolMetaDat
private static void buildTransientFieldNames() {
TRANSIENT_FIELD_NAMES.add("running");
+ TRANSIENT_FIELD_NAMES.add("poolName");
TRANSIENT_FIELD_NAMES.add("closed");
}
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 206f8bcb6db..5b09e702983 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
@@ -30,14 +30,14 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="ds_0| MySQL| mysql.db.host| 3306| db_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_1| MySQL| mysql.db.host| 3306| db_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_2| MySQL| mysql.db.host| 3306| db_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_3| MySQL| mysql.db.host| 3306| db_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_4| MySQL| mysql.db.host| 3306| db_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_5| MySQL| mysql.db.host| 3306| db_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_6| MySQL| mysql.db.host| 3306| db_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_7| MySQL| mysql.db.host| 3306| db_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_8| MySQL| mysql.db.host| 3306| db_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
- <row values="ds_9| MySQL| mysql.db.host| 3306| db_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_0| MySQL| mysql.db.host| 3306| db_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_1| MySQL| mysql.db.host| 3306| db_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_2| MySQL| mysql.db.host| 3306| db_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_3| MySQL| mysql.db.host| 3306| db_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_4| MySQL| mysql.db.host| 3306| db_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_5| MySQL| mysql.db.host| 3306| db_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_6| MySQL| mysql.db.host| 3306| db_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_7| MySQL| mysql.db.host| 3306| db_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_8| MySQL| mysql.db.host| 3306| db_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false", [...]
+ <row values="ds_9| MySQL| mysql.db.host| 3306| db_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"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 a1a0fcffb49..4024fe38883 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
@@ -30,14 +30,14 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="ds_0| PostgreSQL| postgresql.db.host| 5432| db_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-2","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-3","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-4","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-5","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-6","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-7","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-8","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-9","registerMbeans":false,"allowPoolSuspension":false&# [...]
- <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-10","registerMbeans":false,"allowPoolSuspension":false& [...]
+ <row values="ds_0| PostgreSQL| postgresql.db.host| 5432| db_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
+ <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateIn [...]
</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 89315f775c2..8e91f5f9adc 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
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
- <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
- <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetM [...]
+ <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
+ <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host| 3306| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMet [...]
</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 e3eff190213..bc53b8ac452 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
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans":false,&qu [...]
- <row values="write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-2","registerMbeans":false,&qu [...]
- <row values="write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-3","registerMbeans":false,&qu [...]
- <row values="write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-4","registerMbeans":false,&qu [...]
- <row values="write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-5","registerMbeans":false,&qu [...]
- <row values="write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-6","registerMbeans":false,&qu [...]
- <row values="write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-7","registerMbeans":false,&qu [...]
- <row values="write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-8","registerMbeans":false,&qu [...]
- <row values="write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-9","registerMbeans":false,&qu [...]
- <row values="write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-10","registerMbeans":false,&q [...]
- <row values="read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-11","registerMbeans":false,&quo [...]
- <row values="read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-12","registerMbeans":false,&quo [...]
- <row values="read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-13","registerMbeans":false,&quo [...]
- <row values="read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-14","registerMbeans":false,&quo [...]
- <row values="read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-15","registerMbeans":false,&quo [...]
- <row values="read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-16","registerMbeans":false,&quo [...]
- <row values="read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-17","registerMbeans":false,&quo [...]
- <row values="read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-18","registerMbeans":false,&quo [...]
- <row values="read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-19","registerMbeans":false,&quo [...]
- <row values="read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-20","registerMbeans":false,&quo [...]
+ <row values="write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoC [...]
+ <row values="read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
+ <row values="read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCom [...]
</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 21a583cd0de..84e9bb36a1e 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
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
- <row values="encrypt_read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
- <row values="encrypt_read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true&quo [...]
+ <row values="encrypt_read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
+ <row values="encrypt_read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting_and_encrypt.host| 3306| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true" [...]
</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/postgresql/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/postgresql/show_resources.xml
index 7f4a2f5e8ec..ec5e2f9e847 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/postgresql/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/postgresql/show_resources.xml
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMb [...]
- <row values="encrypt_write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-2","registerMb [...]
- <row values="encrypt_write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-3","registerMb [...]
- <row values="encrypt_write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-4","registerMb [...]
- <row values="encrypt_write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-5","registerMb [...]
- <row values="encrypt_write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-6","registerMb [...]
- <row values="encrypt_write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-7","registerMb [...]
- <row values="encrypt_write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-8","registerMb [...]
- <row values="encrypt_write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-9","registerMb [...]
- <row values="encrypt_write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-10","registerM [...]
- <row values="encrypt_read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-11","registerMbe [...]
- <row values="encrypt_read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-12","registerMbe [...]
- <row values="encrypt_read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-13","registerMbe [...]
- <row values="encrypt_read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-14","registerMbe [...]
- <row values="encrypt_read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-15","registerMbe [...]
- <row values="encrypt_read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-16","registerMbe [...]
- <row values="encrypt_read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-17","registerMbe [...]
- <row values="encrypt_read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-18","registerMbe [...]
- <row values="encrypt_read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-19","registerMbe [...]
- <row values="encrypt_read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-20","registerMbe [...]
+ <row values="encrypt_write_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_write_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension&quo [...]
+ <row values="encrypt_read_ds_0| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_1| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_2| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_3| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_4| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_5| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_6| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_7| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_8| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
+ <row values="encrypt_read_ds_9| PostgreSQL| postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host| 5432| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension" [...]
</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 9fdeeca41ab..99af187277b 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
@@ -30,5 +30,5 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt| MySQL| mysql.encrypt.host| 3306| encrypt| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false [...]
+ <row values="encrypt| MySQL| mysql.encrypt.host| 3306| encrypt| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"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 f8b17394d49..7e240e98c61 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
@@ -30,5 +30,5 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt| PostgreSQL| postgresql.encrypt.host| 5432| encrypt| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans":false,"allowPoolSuspension"& [...]
+ <row values="encrypt| PostgreSQL| postgresql.encrypt.host| 5432| encrypt| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&quo [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/mysql/show_resources.xml
index 16f3773d914..37ae8d097f5 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/mysql/show_resources.xml
@@ -30,6 +30,6 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds| MySQL| mysql.encrypt_and_readwrite_splitting.host| 3306| encrypt_write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","ca [...]
- <row values="encrypt_read_ds| MySQL| mysql.encrypt_and_readwrite_splitting.host| 3306| encrypt_read_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cach [...]
+ <row values="encrypt_write_ds| MySQL| mysql.encrypt_and_readwrite_splitting.host| 3306| encrypt_write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","ca [...]
+ <row values="encrypt_read_ds| MySQL| mysql.encrypt_and_readwrite_splitting.host| 3306| encrypt_read_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cach [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/postgresql/show_resources.xml
index b8547ef8f54..0916f0777f6 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt_and_readwrite_splitting/postgresql/show_resources.xml
@@ -30,6 +30,6 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds| PostgreSQL| postgresql.encrypt_and_readwrite_splitting.host| 5432| encrypt_write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans": [...]
- <row values="encrypt_read_ds| PostgreSQL| postgresql.encrypt_and_readwrite_splitting.host| 5432| encrypt_read_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-2","registerMbeans":fa [...]
+ <row values="encrypt_write_ds| PostgreSQL| postgresql.encrypt_and_readwrite_splitting.host| 5432| encrypt_write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false [...]
+ <row values="encrypt_read_ds| PostgreSQL| postgresql.encrypt_and_readwrite_splitting.host| 5432| encrypt_read_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":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 91306b170ae..eb5df1efebb 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
@@ -30,7 +30,7 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds| MySQL| mysql.readwrite_splitting.host| 3306| write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata"&# [...]
- <row values="read_0| MySQL| mysql.readwrite_splitting.host| 3306| read_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
- <row values="read_1| MySQL| mysql.readwrite_splitting.host| 3306| read_1| 30000| 60000| 1800000| 2| 2| false|{"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&q [...]
+ <row values="write_ds| MySQL| mysql.readwrite_splitting.host| 3306| write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata"&# [...]
+ <row values="read_0| MySQL| mysql.readwrite_splitting.host| 3306| read_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="read_1| MySQL| mysql.readwrite_splitting.host| 3306| read_1| 30000| 60000| 1800000| 2| 2| false|{"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&q [...]
</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 18b24e779a0..c5039ead3f4 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
@@ -30,7 +30,7 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds| PostgreSQL| postgresql.readwrite_splitting.host| 5432| write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans":false,"allowPoolSus [...]
- <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-2","registerMbeans":false,"allowPoolSuspens [...]
- <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-3","registerMbeans":false,"allowPoolSuspens [...]
+ <row values="write_ds| PostgreSQL| postgresql.readwrite_splitting.host| 5432| write_ds| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit": [...]
+ <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host| 5432| read_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/mysql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/mysql/show_resources.xml
index 098d3537da0..7af49996244 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/mysql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/mysql/show_resources.xml
@@ -30,14 +30,14 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_ds_0| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_1| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_2| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_3| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_4| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_5| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_6| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_7| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_8| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
- <row values="encrypt_ds_9| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_0| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_1| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_2| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_3| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_4| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_5| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_6| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_7| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_8| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
+ <row values="encrypt_ds_9| MySQL| mysql.sharding_and_encrypt.host| 3306| encrypt_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadat [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/postgresql/show_resources.xml
index dabc33fd635..8511c0d53a4 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/sharding_and_encrypt/postgresql/show_resources.xml
@@ -30,14 +30,14 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_ds_0| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans":false,"all [...]
- <row values="encrypt_ds_1| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-2","registerMbeans":false,"all [...]
- <row values="encrypt_ds_2| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-3","registerMbeans":false,"all [...]
- <row values="encrypt_ds_3| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-4","registerMbeans":false,"all [...]
- <row values="encrypt_ds_4| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-5","registerMbeans":false,"all [...]
- <row values="encrypt_ds_5| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-6","registerMbeans":false,"all [...]
- <row values="encrypt_ds_6| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-7","registerMbeans":false,"all [...]
- <row values="encrypt_ds_7| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-8","registerMbeans":false,"all [...]
- <row values="encrypt_ds_8| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-9","registerMbeans":false,"all [...]
- <row values="encrypt_ds_9| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-10","registerMbeans":false,"al [...]
+ <row values="encrypt_ds_0| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_1| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_2| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_3| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_4| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_5| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_6| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_7| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_8| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
+ <row values="encrypt_ds_9| PostgreSQL| postgresql.sharding_and_encrypt.host| 5432| encrypt_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit& [...]
</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 e1bb5178e96..713f2575608 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
@@ -30,5 +30,5 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="governance_db| MySQL| mysql.sharding_governance.host| 3306| governance_db| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
+ <row values="governance_db| MySQL| mysql.sharding_governance.host| 3306| governance_db| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
</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 65959650f53..4ed9ea4d63f 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
@@ -30,5 +30,5 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="tbl| MySQL| mysql.tbl.host| 3306| tbl| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false",& [...]
+ <row values="tbl| MySQL| mysql.tbl.host| 3306| tbl| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false",& [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/postgresql/show_resources.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/postgresql/show_resources.xml
index 3980356b286..7c6266b6270 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/postgresql/show_resources.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/postgresql/show_resources.xml
@@ -30,5 +30,5 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="tbl| PostgreSQL| postgresql.tbl.host| 5432| tbl| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"poolName":"HikariPool-1","registerMbeans":false,"allowPoolSuspension":false [...]
+ <row values="tbl| PostgreSQL| postgresql.tbl.host| 5432| tbl| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInt [...]
</dataset>