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 <[email protected]>
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>