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/05/23 15:17:49 UTC
[shardingsphere] branch master updated: Support poolName configuration (#17883)
This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 cb745f9b340 Support poolName configuration (#17883)
cb745f9b340 is described below
commit cb745f9b340169a9fccbd459eee0401822e3f6b7
Author: zhaojinchao <zh...@apache.org>
AuthorDate: Mon May 23 23:17:37 2022 +0800
Support poolName configuration (#17883)
---
.../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 +-
.../readwrite_splitting/mysql/show_resources.xml | 6 ++--
.../postgresql/show_resources.xml | 6 ++--
.../sharding_governance/mysql/show_resources.xml | 2 +-
.../cases/rql/dataset/tbl/mysql/show_resources.xml | 2 +-
.../rql/dataset/tbl/postgresql/show_resources.xml | 2 +-
14 files changed, 111 insertions(+), 112 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 88a67ef1254..f0686a0a712 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,7 +69,6 @@ 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 6a81309f811..1550a763187 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 4024fe38883..a1a0fcffb49 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,"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 [...]
+ <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& [...]
</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 9b40e0a164e..a63ce75232d 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 bc53b8ac452..e3eff190213 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,"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 [...]
+ <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 [...]
</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 2738d3b9889..9b86d4c6e65 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 ec5e2f9e847..7f4a2f5e8ec 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,"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" [...]
+ <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 [...]
</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 27de8c044b8..1a7f56c57a5 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 7e240e98c61..f8b17394d49 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,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&quo [...]
+ <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"& [...]
</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 9af3200f5b4..502f53016ac 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 c5039ead3f4..18b24e779a0 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,"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 [...]
+ <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 [...]
</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 a2178379818..0ddf24debdc 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 372ee867485..8dbbbe4ed2f 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 7c6266b6270..3980356b286 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,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInt [...]
+ <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 [...]
</dataset>