This is an automated email from the ASF dual-hosted git repository.
zhonghongsheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new be4bf8466d9 Remove serverTimezone=UTC at unit test and config file
(#29070)
be4bf8466d9 is described below
commit be4bf8466d900356799cf47731cd466b649d5602
Author: Xinze Guo <[email protected]>
AuthorDate: Mon Nov 20 09:57:59 2023 +0800
Remove serverTimezone=UTC at unit test and config file (#29070)
* Remove serverTimezone=UTC at unit test and config file
* Fix unit test
---
.../core/connector/url/JdbcUrlAppenderTest.java | 3 +-
.../connector/url/StandardJdbcUrlParserTest.java | 5 ++-
.../MySQLConnectionPropertiesParserTest.java | 6 ++--
.../DriverDatabaseConnectionManagerTest.java | 10 +++---
...gSpherePipelineDataSourceConfigurationTest.java | 4 +--
...tandardPipelineDataSourceConfigurationTest.java | 2 +-
.../resources/conf/convert/config-encrypt.yaml | 4 +--
.../test/resources/conf/convert/config-mix.yaml | 12 +++----
.../conf/convert/config-readwrite-splitting.yaml | 6 ++--
.../test/resources/conf/convert/config-shadow.yaml | 4 +--
.../conf/convert/config-sharding-auto-tables.yaml | 4 +--
.../resources/conf/convert/config-sharding.yaml | 4 +--
.../test/resources/expected/convert-encrypt.yaml | 4 +--
.../src/test/resources/expected/convert-mix.yaml | 12 +++----
.../expected/convert-readwrite-splitting.yaml | 6 ++--
.../test/resources/expected/convert-shadow.yaml | 4 +--
.../expected/convert-sharding-auto-tables.yaml | 4 +--
.../test/resources/expected/convert-sharding.yaml | 4 +--
.../src/main/resources/conf/config-encrypt.yaml | 4 +--
.../src/main/resources/conf/config-mask.yaml | 4 +--
.../resources/conf/config-readwrite-splitting.yaml | 6 ++--
.../src/main/resources/conf/config-shadow.yaml | 4 +--
.../jdbc-project/src/main/resources/config.yaml | 4 +--
.../test/resources/docker/jdbc/conf/config.yaml | 4 +--
.../resources/docker/proxy/conf/config-db.yaml | 4 +--
.../src/test/resources/env/engine-env.properties | 2 +-
.../test/resources/docker/jdbc/conf/config.yaml | 4 +--
.../resources/docker/proxy/conf/config-db.yaml | 4 +--
.../src/test/resources/env/engine-env.properties | 2 +-
.../test/resources/docker/jdbc/conf/config.yaml | 4 +--
.../resources/docker/proxy/conf/config-db.yaml | 4 +--
.../src/test/resources/env/engine-env.properties | 2 +-
.../test/resources/docker/jdbc/conf/config.yaml | 4 +--
.../resources/docker/proxy/conf/config-db.yaml | 4 +--
.../src/test/resources/env/engine-env.properties | 2 +-
.../e2e/env/runtime/DataSourceEnvironment.java | 2 +-
.../conf/mysql/config-cluster-jdbc-proxy.yaml | 2 +-
.../default/proxy/conf/mysql/config-sharding.yaml | 4 +--
.../mysql/config-readwrite-splitting-local.yaml | 6 ++--
.../config-readwrite-splitting-xa-atomikos.yaml | 6 ++--
.../config-readwrite-splitting-xa-narayana.yaml | 6 ++--
.../conf/mysql/config-readwrite-splitting.yaml | 8 ++---
.../resources/cases/rdl/rdl-integration-alter.xml | 2 +-
.../cases/rdl/rdl-integration-register.xml | 2 +-
.../scenario/db/proxy/conf/mysql/config-db.yaml | 20 +++++------
.../config-dbtbl-with-readwrite-splitting.yaml | 40 ++++++++++-----------
...dbtbl-with-readwrite-splitting-and-encrypt.yaml | 40 ++++++++++-----------
.../proxy/conf/mysql/config-empty-rules.yaml | 42 +++++++++++-----------
.../encrypt/proxy/conf/mysql/config-encrypt.yaml | 2 +-
.../mysql/config-encrypt-readwrite-splitting.yaml | 4 +--
.../proxy/conf/mysql/config-encrypt-shadow.yaml | 4 +--
.../mask/proxy/conf/mysql/config-mask.yaml | 2 +-
.../proxy/conf/mysql/config-mask-encrypt.yaml | 2 +-
.../conf/mysql/config-mask-encrypt-sharding.yaml | 20 +++++------
.../proxy/conf/mysql/config-mask-sharding.yaml | 20 +++++------
.../proxy/conf/mysql/config-passthrough.yaml | 2 +-
.../proxy/conf/mysql/config-rdl-empty-rules.yaml | 6 ++--
.../conf/mysql/config-readwrite-splitting.yaml | 6 ++--
.../proxy/conf/mysql/config-shadow.yaml | 8 ++---
.../shadow/proxy/conf/mysql/config-shadow.yaml | 4 +--
.../conf/mysql/config-sharding-and-encrypt.yaml | 20 +++++------
.../conf/mysql/config-sharding-and-shadow.yaml | 40 ++++++++++-----------
.../conf/mysql/config-sharding-encrypt-shadow.yaml | 40 ++++++++++-----------
.../scenario/tbl/proxy/conf/mysql/config-tbl.yaml | 2 +-
64 files changed, 260 insertions(+), 262 deletions(-)
diff --git
a/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/JdbcUrlAppenderTest.java
b/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/JdbcUrlAppenderTest.java
index 2757038cba7..6c5acc868a5 100644
---
a/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/JdbcUrlAppenderTest.java
+++
b/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/JdbcUrlAppenderTest.java
@@ -39,10 +39,9 @@ class JdbcUrlAppenderTest {
@Test
void assertAppendQueryPropertiesWithOriginalQueryProperties() {
String actual = new JdbcUrlAppender().appendQueryProperties(
-
"jdbc:trunk://192.168.0.1:3306/foo_ds?serverTimezone=UTC&useSSL=false&rewriteBatchedStatements=true",
+
"jdbc:trunk://192.168.0.1:3306/foo_ds?useSSL=false&rewriteBatchedStatements=true",
PropertiesBuilder.build(new Property("useSSL",
Boolean.FALSE.toString()), new Property("rewriteBatchedStatements",
Boolean.TRUE.toString())));
assertThat(actual,
startsWith("jdbc:trunk://192.168.0.1:3306/foo_ds?"));
- assertThat(actual, containsString("serverTimezone=UTC"));
assertThat(actual, containsString("rewriteBatchedStatements=true"));
assertThat(actual, containsString("useSSL=false"));
}
diff --git
a/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/StandardJdbcUrlParserTest.java
b/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/StandardJdbcUrlParserTest.java
index b4bd4092830..3f907a7663e 100644
---
a/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/StandardJdbcUrlParserTest.java
+++
b/infra/database/core/src/test/java/org/apache/shardingsphere/infra/database/core/connector/url/StandardJdbcUrlParserTest.java
@@ -37,12 +37,11 @@ class StandardJdbcUrlParserTest {
@Test
void assertParseMySQLJdbcUrl() {
- JdbcUrl actual = new
StandardJdbcUrlParser().parse("jdbc:mysql://127.0.0.1:3306/demo_ds?serverTimezone=UTC&useSSL=false&sessionVariables=group_concat_max_len=204800,SQL_SAFE_UPDATES=0");
+ JdbcUrl actual = new
StandardJdbcUrlParser().parse("jdbc:mysql://127.0.0.1:3306/demo_ds?useSSL=false&sessionVariables=group_concat_max_len=204800,SQL_SAFE_UPDATES=0");
assertThat(actual.getHostname(), is("127.0.0.1"));
assertThat(actual.getPort(), is(3306));
assertThat(actual.getDatabase(), is("demo_ds"));
- assertThat(actual.getQueryProperties().size(), is(3));
- assertThat(actual.getQueryProperties().get("serverTimezone"),
is("UTC"));
+ assertThat(actual.getQueryProperties().size(), is(2));
assertThat(actual.getQueryProperties().get("useSSL"),
is(Boolean.FALSE.toString()));
assertThat(actual.getQueryProperties().get("sessionVariables"),
is("group_concat_max_len=204800,SQL_SAFE_UPDATES=0"));
}
diff --git
a/infra/database/type/mysql/src/test/java/org/apache/shardingsphere/infra/database/mysql/connector/MySQLConnectionPropertiesParserTest.java
b/infra/database/type/mysql/src/test/java/org/apache/shardingsphere/infra/database/mysql/connector/MySQLConnectionPropertiesParserTest.java
index 4128f672f62..9b348051b1b 100644
---
a/infra/database/type/mysql/src/test/java/org/apache/shardingsphere/infra/database/mysql/connector/MySQLConnectionPropertiesParserTest.java
+++
b/infra/database/type/mysql/src/test/java/org/apache/shardingsphere/infra/database/mysql/connector/MySQLConnectionPropertiesParserTest.java
@@ -17,9 +17,9 @@
package org.apache.shardingsphere.infra.database.mysql.connector;
+import
org.apache.shardingsphere.infra.database.core.connector.ConnectionProperties;
import
org.apache.shardingsphere.infra.database.core.connector.ConnectionPropertiesParser;
import
org.apache.shardingsphere.infra.database.core.connector.url.UnrecognizedDatabaseURLException;
-import
org.apache.shardingsphere.infra.database.core.connector.ConnectionProperties;
import
org.apache.shardingsphere.infra.database.core.spi.DatabaseTypedSPILoader;
import org.apache.shardingsphere.infra.database.core.type.DatabaseType;
import org.apache.shardingsphere.infra.spi.type.typed.TypedSPILoader;
@@ -65,8 +65,8 @@ class MySQLConnectionPropertiesParserTest {
public Stream<? extends Arguments> provideArguments(final
ExtensionContext extensionContext) {
return Stream.of(
Arguments.of("simple", "jdbc:mysql://127.0.0.1/foo_ds",
"127.0.0.1", 3306, "foo_ds", null, new Properties()),
- Arguments.of("complex",
"jdbc:mysql:loadbalance://127.0.0.1:9999,127.0.0.2:9999/foo_ds?serverTimezone=UTC&useSSL=false",
"127.0.0.1", 9999, "foo_ds", null,
- PropertiesBuilder.build(new
Property("serverTimezone", "UTC"), new Property("useSSL",
Boolean.FALSE.toString()))));
+ Arguments.of("complex",
"jdbc:mysql:loadbalance://127.0.0.1:9999,127.0.0.2:9999/foo_ds?useSSL=false",
"127.0.0.1", 9999, "foo_ds", null,
+ PropertiesBuilder.build(new Property("useSSL",
Boolean.FALSE.toString()))));
}
}
}
diff --git
a/jdbc/core/src/test/java/org/apache/shardingsphere/driver/jdbc/core/connection/DriverDatabaseConnectionManagerTest.java
b/jdbc/core/src/test/java/org/apache/shardingsphere/driver/jdbc/core/connection/DriverDatabaseConnectionManagerTest.java
index ef8909825be..2ec99176ea4 100644
---
a/jdbc/core/src/test/java/org/apache/shardingsphere/driver/jdbc/core/connection/DriverDatabaseConnectionManagerTest.java
+++
b/jdbc/core/src/test/java/org/apache/shardingsphere/driver/jdbc/core/connection/DriverDatabaseConnectionManagerTest.java
@@ -113,7 +113,7 @@ class DriverDatabaseConnectionManagerTest {
private Map<String, Object> createProperties() {
Map<String, Object> result = new LinkedHashMap<>(3, 1F);
- result.put("jdbcUrl",
"jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false");
+ result.put("jdbcUrl",
"jdbc:mysql://127.0.0.1:3306/demo_ds_0?useSSL=false");
result.put("username", "root");
result.put("password", "123456");
return result;
@@ -121,7 +121,7 @@ class DriverDatabaseConnectionManagerTest {
private Map<String, DataSource> mockTrafficDataSourceMap() throws
SQLException {
MockedDataSource result = new MockedDataSource(mock(Connection.class,
RETURNS_DEEP_STUBS));
-
result.setUrl("jdbc:mysql://127.0.0.1:3307/logic_db?serverTimezone=UTC&useSSL=false");
+ result.setUrl("jdbc:mysql://127.0.0.1:3307/logic_db?useSSL=false");
result.setUsername("root");
result.setPassword("123456");
when(result.getConnection().getMetaData().getURL()).thenReturn(result.getUrl());
@@ -165,7 +165,7 @@ class DriverDatabaseConnectionManagerTest {
assertThat(actual,
is(databaseConnectionManager.getConnections("127.0.0.1@3307", 0, 1,
ConnectionMode.MEMORY_STRICTLY)));
assertThat(actual.size(), is(1));
assertThat(actual.get(0).getMetaData().getUserName(), is("root"));
- assertThat(actual.get(0).getMetaData().getURL(),
is("jdbc:mysql://127.0.0.1:3307/logic_db?serverTimezone=UTC&useSSL=false"));
+ assertThat(actual.get(0).getMetaData().getURL(),
is("jdbc:mysql://127.0.0.1:3307/logic_db?useSSL=false"));
}
@Test
@@ -183,7 +183,7 @@ class DriverDatabaseConnectionManagerTest {
assertThat(actual.size(), is(1));
assertThat(actual.get(0), is(expected));
assertThat(actual.get(0).getMetaData().getUserName(), is("root"));
- assertThat(actual.get(0).getMetaData().getURL(),
is("jdbc:mysql://127.0.0.1:3307/logic_db?serverTimezone=UTC&useSSL=false"));
+ assertThat(actual.get(0).getMetaData().getURL(),
is("jdbc:mysql://127.0.0.1:3307/logic_db?useSSL=false"));
}
@Test
@@ -197,7 +197,7 @@ class DriverDatabaseConnectionManagerTest {
List<Connection> actual =
databaseConnectionManager.getConnections("127.0.0.1@3307", 0, 1,
ConnectionMode.MEMORY_STRICTLY);
assertThat(actual.size(), is(1));
assertThat(actual.get(0).getMetaData().getUserName(), is("root"));
- assertThat(actual.get(0).getMetaData().getURL(),
is("jdbc:mysql://127.0.0.1:3307/logic_db?serverTimezone=UTC&useSSL=false"));
+ assertThat(actual.get(0).getMetaData().getURL(),
is("jdbc:mysql://127.0.0.1:3307/logic_db?useSSL=false"));
}
@Test
diff --git
a/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/ShardingSpherePipelineDataSourceConfigurationTest.java
b/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/ShardingSpherePipelineDataSourceConfigurationTest.java
index ea77113d053..792e0acbe08 100644
---
a/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/ShardingSpherePipelineDataSourceConfigurationTest.java
+++
b/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/ShardingSpherePipelineDataSourceConfigurationTest.java
@@ -75,11 +75,11 @@ class ShardingSpherePipelineDataSourceConfigurationTest {
+ " minPoolSize: 20\n"
+ " minimumIdle: 20\n"
+ " dataSourceClassName:
com.zaxxer.hikari.HikariDataSource\n"
- + " url:
jdbc:mysql://192.168.0.2:3306/ds_1?serverTimezone=UTC&useSSL=false\n"
+ + " url: jdbc:mysql://192.168.0.2:3306/ds_1?useSSL=false\n"
+ " ds_0:\n"
+ " minPoolSize: 20\n"
+ " minimumIdle: 20\n"
+ " dataSourceClassName:
com.zaxxer.hikari.HikariDataSource\n"
- + " url:
jdbc:mysql://192.168.0.1:3306/ds_0?serverTimezone=UTC&useSSL=false\n";
+ + " url: jdbc:mysql://192.168.0.1:3306/ds_0?useSSL=false\n";
}
}
diff --git
a/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/StandardPipelineDataSourceConfigurationTest.java
b/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/StandardPipelineDataSourceConfigurationTest.java
index b5bd9f6aa90..610f63f1588 100644
---
a/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/StandardPipelineDataSourceConfigurationTest.java
+++
b/kernel/data-pipeline/api/src/test/java/org/apache/shardingsphere/data/pipeline/api/type/StandardPipelineDataSourceConfigurationTest.java
@@ -31,7 +31,7 @@ import static org.junit.jupiter.api.Assertions.assertNotNull;
class StandardPipelineDataSourceConfigurationTest {
- private static final String JDBC_URL =
"jdbc:mysql://127.0.0.1:3306/demo_ds?serverTimezone=UTC&useSSL=false";
+ private static final String JDBC_URL =
"jdbc:mysql://127.0.0.1:3306/demo_ds?useSSL=false";
private static final String USERNAME = "userName";
diff --git
a/proxy/backend/core/src/test/resources/conf/convert/config-encrypt.yaml
b/proxy/backend/core/src/test/resources/conf/convert/config-encrypt.yaml
index d8cddaa74b9..b5402a83f68 100644
--- a/proxy/backend/core/src/test/resources/conf/convert/config-encrypt.yaml
+++ b/proxy/backend/core/src/test/resources/conf/convert/config-encrypt.yaml
@@ -19,7 +19,7 @@ databaseName: encrypt_db
dataSources:
ds_0:
- url:
jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_1:
- url:
jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_1?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_1?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
diff --git a/proxy/backend/core/src/test/resources/conf/convert/config-mix.yaml
b/proxy/backend/core/src/test/resources/conf/convert/config-mix.yaml
index 8e728914475..a2bdf3fc492 100644
--- a/proxy/backend/core/src/test/resources/conf/convert/config-mix.yaml
+++ b/proxy/backend/core/src/test/resources/conf/convert/config-mix.yaml
@@ -19,7 +19,7 @@ databaseName: mix_db
dataSources:
ds_0:
- url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_1:
- url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_2:
- url: jdbc:mysql://127.0.0.1:3306/demo_ds_2?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_ds_2?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_3:
- url: jdbc:mysql://127.0.0.1:3306/demo_ds_3?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_ds_3?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_4:
- url: jdbc:mysql://127.0.0.1:3306/demo_ds_4?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_ds_4?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_5:
- url: jdbc:mysql://127.0.0.1:3306/demo_ds_5?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_ds_5?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
diff --git
a/proxy/backend/core/src/test/resources/conf/convert/config-readwrite-splitting.yaml
b/proxy/backend/core/src/test/resources/conf/convert/config-readwrite-splitting.yaml
index 9a67bc70387..47e0bcb6515 100644
---
a/proxy/backend/core/src/test/resources/conf/convert/config-readwrite-splitting.yaml
+++
b/proxy/backend/core/src/test/resources/conf/convert/config-readwrite-splitting.yaml
@@ -19,7 +19,7 @@ databaseName: readwrite_splitting_db
dataSources:
write_ds_0:
- url:
jdbc:mysql://127.0.0.1:3306/demo_write_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_write_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
read_ds_0:
- url:
jdbc:mysql://127.0.0.1:3306/demo_read_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_read_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
read_ds_1:
- url:
jdbc:mysql://127.0.0.1:3306/demo_read_ds_1?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_read_ds_1?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
diff --git
a/proxy/backend/core/src/test/resources/conf/convert/config-shadow.yaml
b/proxy/backend/core/src/test/resources/conf/convert/config-shadow.yaml
index 83a412652ac..369385a2a77 100644
--- a/proxy/backend/core/src/test/resources/conf/convert/config-shadow.yaml
+++ b/proxy/backend/core/src/test/resources/conf/convert/config-shadow.yaml
@@ -19,7 +19,7 @@ databaseName: shadow_db
dataSources:
ds:
- url:
jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
shadow_ds:
- url:
jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_1?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_1?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
diff --git
a/proxy/backend/core/src/test/resources/conf/convert/config-sharding-auto-tables.yaml
b/proxy/backend/core/src/test/resources/conf/convert/config-sharding-auto-tables.yaml
index 2a09acb2de8..17e65829317 100644
---
a/proxy/backend/core/src/test/resources/conf/convert/config-sharding-auto-tables.yaml
+++
b/proxy/backend/core/src/test/resources/conf/convert/config-sharding-auto-tables.yaml
@@ -19,7 +19,7 @@ databaseName: sharding_db
dataSources:
ds_0:
- url:
jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_1:
- url:
jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
diff --git
a/proxy/backend/core/src/test/resources/conf/convert/config-sharding.yaml
b/proxy/backend/core/src/test/resources/conf/convert/config-sharding.yaml
index e8129cfcead..47293f1d007 100644
--- a/proxy/backend/core/src/test/resources/conf/convert/config-sharding.yaml
+++ b/proxy/backend/core/src/test/resources/conf/convert/config-sharding.yaml
@@ -19,7 +19,7 @@ databaseName: sharding_db
dataSources:
ds_0:
- url:
jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 1
ds_1:
- url:
jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?serverTimezone=UTC&useSSL=false
+ url: jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?useSSL=false
username: root
password: 12345678
connectionTimeoutMilliseconds: 30000
diff --git
a/proxy/backend/core/src/test/resources/expected/convert-encrypt.yaml
b/proxy/backend/core/src/test/resources/expected/convert-encrypt.yaml
index 40e3b4c7c88..9a7676ae0ee 100644
--- a/proxy/backend/core/src/test/resources/expected/convert-encrypt.yaml
+++ b/proxy/backend/core/src/test/resources/expected/convert-encrypt.yaml
@@ -18,12 +18,12 @@ CREATE DATABASE encrypt_db;
USE encrypt_db;
REGISTER STORAGE UNIT ds_0 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_1 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_1?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_encrypt_ds_1?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
diff --git a/proxy/backend/core/src/test/resources/expected/convert-mix.yaml
b/proxy/backend/core/src/test/resources/expected/convert-mix.yaml
index 9f0a92fae5d..05ee1195666 100644
--- a/proxy/backend/core/src/test/resources/expected/convert-mix.yaml
+++ b/proxy/backend/core/src/test/resources/expected/convert-mix.yaml
@@ -18,32 +18,32 @@ CREATE DATABASE mix_db;
USE mix_db;
REGISTER STORAGE UNIT ds_0 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_1 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_ds_1?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_2 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_ds_2?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_ds_2?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_3 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_ds_3?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_ds_3?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_4 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_ds_4?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_ds_4?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_5 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_ds_5?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_ds_5?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
diff --git
a/proxy/backend/core/src/test/resources/expected/convert-readwrite-splitting.yaml
b/proxy/backend/core/src/test/resources/expected/convert-readwrite-splitting.yaml
index b7235762466..415f211ff1c 100644
---
a/proxy/backend/core/src/test/resources/expected/convert-readwrite-splitting.yaml
+++
b/proxy/backend/core/src/test/resources/expected/convert-readwrite-splitting.yaml
@@ -18,17 +18,17 @@ CREATE DATABASE readwrite_splitting_db;
USE readwrite_splitting_db;
REGISTER STORAGE UNIT write_ds_0 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_write_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_write_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), read_ds_0 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_read_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_read_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), read_ds_1 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_read_ds_1?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_read_ds_1?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
diff --git a/proxy/backend/core/src/test/resources/expected/convert-shadow.yaml
b/proxy/backend/core/src/test/resources/expected/convert-shadow.yaml
index 2d6d2b15d3d..563559443de 100644
--- a/proxy/backend/core/src/test/resources/expected/convert-shadow.yaml
+++ b/proxy/backend/core/src/test/resources/expected/convert-shadow.yaml
@@ -18,12 +18,12 @@ CREATE DATABASE shadow_db;
USE shadow_db;
REGISTER STORAGE UNIT ds (
-URL='jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), shadow_ds (
-URL='jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_1?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_shadow_ds_1?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
diff --git
a/proxy/backend/core/src/test/resources/expected/convert-sharding-auto-tables.yaml
b/proxy/backend/core/src/test/resources/expected/convert-sharding-auto-tables.yaml
index feb604ff1a3..198077d7df6 100644
---
a/proxy/backend/core/src/test/resources/expected/convert-sharding-auto-tables.yaml
+++
b/proxy/backend/core/src/test/resources/expected/convert-sharding-auto-tables.yaml
@@ -18,12 +18,12 @@ CREATE DATABASE sharding_db;
USE sharding_db;
REGISTER STORAGE UNIT ds_0 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_1 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
diff --git
a/proxy/backend/core/src/test/resources/expected/convert-sharding.yaml
b/proxy/backend/core/src/test/resources/expected/convert-sharding.yaml
index 33352396b09..5d5a5bc77f9 100644
--- a/proxy/backend/core/src/test/resources/expected/convert-sharding.yaml
+++ b/proxy/backend/core/src/test/resources/expected/convert-sharding.yaml
@@ -18,12 +18,12 @@ CREATE DATABASE sharding_db;
USE sharding_db;
REGISTER STORAGE UNIT ds_0 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_0?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
), ds_1 (
-URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?serverTimezone=UTC&useSSL=false',
+URL='jdbc:mysql://127.0.0.1:3306/demo_sharding_ds_1?useSSL=false',
USER='root',
PASSWORD='12345678',
PROPERTIES('minPoolSize'='1', 'connectionTimeoutMilliseconds'='30000',
'maxLifetimeMilliseconds'='1800000', 'idleTimeoutMilliseconds'='60000',
'maxPoolSize'='50')
diff --git a/proxy/bootstrap/src/main/resources/conf/config-encrypt.yaml
b/proxy/bootstrap/src/main/resources/conf/config-encrypt.yaml
index 962a84f16e1..0132c7b0a2e 100644
--- a/proxy/bootstrap/src/main/resources/conf/config-encrypt.yaml
+++ b/proxy/bootstrap/src/main/resources/conf/config-encrypt.yaml
@@ -73,7 +73,7 @@
#
#dataSources:
# ds_0:
-# url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@
# maxPoolSize: 50
# minPoolSize: 1
# ds_1:
-# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
diff --git a/proxy/bootstrap/src/main/resources/conf/config-mask.yaml
b/proxy/bootstrap/src/main/resources/conf/config-mask.yaml
index 44ee9ebda64..b7a8259a87e 100644
--- a/proxy/bootstrap/src/main/resources/conf/config-mask.yaml
+++ b/proxy/bootstrap/src/main/resources/conf/config-mask.yaml
@@ -81,7 +81,7 @@
#
#dataSources:
# ds_0:
-# url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
@@ -90,7 +90,7 @@
# maxPoolSize: 50
# minPoolSize: 1
# ds_1:
-# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
diff --git
a/proxy/bootstrap/src/main/resources/conf/config-readwrite-splitting.yaml
b/proxy/bootstrap/src/main/resources/conf/config-readwrite-splitting.yaml
index 3c61a35f293..f654255f750 100644
--- a/proxy/bootstrap/src/main/resources/conf/config-readwrite-splitting.yaml
+++ b/proxy/bootstrap/src/main/resources/conf/config-readwrite-splitting.yaml
@@ -76,7 +76,7 @@
#
#dataSources:
# write_ds:
-# url:
jdbc:mysql://127.0.0.1:3306/demo_write_ds?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_write_ds?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
@@ -85,7 +85,7 @@
# maxPoolSize: 50
# minPoolSize: 1
# read_ds_0:
-# url:
jdbc:mysql://127.0.0.1:3306/demo_read_ds_0?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_read_ds_0?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
@@ -94,7 +94,7 @@
# maxPoolSize: 50
# minPoolSize: 1
# read_ds_1:
-# url:
jdbc:mysql://127.0.0.1:3306/demo_read_ds_1?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_read_ds_1?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
diff --git a/proxy/bootstrap/src/main/resources/conf/config-shadow.yaml
b/proxy/bootstrap/src/main/resources/conf/config-shadow.yaml
index 34f0db928a6..b77ba5582d7 100644
--- a/proxy/bootstrap/src/main/resources/conf/config-shadow.yaml
+++ b/proxy/bootstrap/src/main/resources/conf/config-shadow.yaml
@@ -105,7 +105,7 @@
#
#dataSources:
# ds:
-# url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
@@ -114,7 +114,7 @@
# maxPoolSize: 50
# minPoolSize: 1
# shadow_ds:
-# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
+# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
diff --git a/test/e2e/agent/jdbc-project/src/main/resources/config.yaml
b/test/e2e/agent/jdbc-project/src/main/resources/config.yaml
index 1b8311e542f..ca3ed5b4a32 100644
--- a/test/e2e/agent/jdbc-project/src/main/resources/config.yaml
+++ b/test/e2e/agent/jdbc-project/src/main/resources/config.yaml
@@ -21,13 +21,13 @@ dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://localhost:3306/jdbc_test_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
+ jdbcUrl:
jdbc:mysql://localhost:3306/jdbc_test_0?useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: 123456
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://localhost:3306/jdbc_test_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
+ jdbcUrl:
jdbc:mysql://localhost:3306/jdbc_test_1?useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: 123456
diff --git
a/test/e2e/agent/plugins/logging/file/src/test/resources/docker/jdbc/conf/config.yaml
b/test/e2e/agent/plugins/logging/file/src/test/resources/docker/jdbc/conf/config.yaml
index ab564d043c0..84b4bf12ed7 100644
---
a/test/e2e/agent/plugins/logging/file/src/test/resources/docker/jdbc/conf/config.yaml
+++
b/test/e2e/agent/plugins/logging/file/src/test/resources/docker/jdbc/conf/config.yaml
@@ -21,13 +21,13 @@ dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.logging.host:3306/agent_file_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.logging.host:3306/agent_file_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.logging.host:3306/agent_file_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.logging.host:3306/agent_file_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
diff --git
a/test/e2e/agent/plugins/logging/file/src/test/resources/docker/proxy/conf/config-db.yaml
b/test/e2e/agent/plugins/logging/file/src/test/resources/docker/proxy/conf/config-db.yaml
index fbcd7a5bcf2..ced958b7a63 100644
---
a/test/e2e/agent/plugins/logging/file/src/test/resources/docker/proxy/conf/config-db.yaml
+++
b/test/e2e/agent/plugins/logging/file/src/test/resources/docker/proxy/conf/config-db.yaml
@@ -19,7 +19,7 @@ databaseName: agent-file-db
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.agent.proxy.logging.host:3306/agent_file_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.logging.host:3306/agent_file_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 10
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.agent.proxy.logging.host:3306/agent_file_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.logging.host:3306/agent_file_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/agent/plugins/logging/file/src/test/resources/env/engine-env.properties
b/test/e2e/agent/plugins/logging/file/src/test/resources/env/engine-env.properties
index 4431edb760b..9c454706515 100644
---
a/test/e2e/agent/plugins/logging/file/src/test/resources/env/engine-env.properties
+++
b/test/e2e/agent/plugins/logging/file/src/test/resources/env/engine-env.properties
@@ -18,7 +18,7 @@
it.env.type=${it.env}
it.env.value=file
-proxy.url=jdbc:mysql://127.0.0.1:43072/agent-file-db?serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
+proxy.url=jdbc:mysql://127.0.0.1:43072/agent-file-db?useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
proxy.username=root
proxy.password=root
diff --git
a/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/jdbc/conf/config.yaml
b/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/jdbc/conf/config.yaml
index 15067b04b2e..7d6269bd3e8 100644
---
a/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/jdbc/conf/config.yaml
+++
b/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/jdbc/conf/config.yaml
@@ -21,13 +21,13 @@ dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.metrics.host:3306/agent_metrics_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.metrics.host:3306/agent_metrics_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.metrics.host:3306/agent_metrics_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.metrics.host:3306/agent_metrics_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
diff --git
a/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/proxy/conf/config-db.yaml
b/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/proxy/conf/config-db.yaml
index fa801ea614f..04c2f774c3b 100644
---
a/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/proxy/conf/config-db.yaml
+++
b/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/docker/proxy/conf/config-db.yaml
@@ -19,7 +19,7 @@ databaseName: agent-metrics-db
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.agent.proxy.metrics.host:3306/agent_metrics_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.metrics.host:3306/agent_metrics_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 10
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.agent.proxy.metrics.host:3306/agent_metrics_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.metrics.host:3306/agent_metrics_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/env/engine-env.properties
b/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/env/engine-env.properties
index e779fcc6e23..714eec81914 100644
---
a/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/env/engine-env.properties
+++
b/test/e2e/agent/plugins/metrics/prometheus/src/test/resources/env/engine-env.properties
@@ -18,7 +18,7 @@
it.env.type=${it.env}
it.env.value=prometheus
-proxy.url=jdbc:mysql://127.0.0.1:43070/agent-metrics-db?serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
+proxy.url=jdbc:mysql://127.0.0.1:43070/agent-metrics-db?useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
proxy.username=root
proxy.password=root
diff --git
a/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/jdbc/conf/config.yaml
b/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/jdbc/conf/config.yaml
index 3f0684bb14c..58e03ff42f4 100644
---
a/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/jdbc/conf/config.yaml
+++
b/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/jdbc/conf/config.yaml
@@ -21,13 +21,13 @@ dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.jaeger.host:3306/agent_jaeger_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.jaeger.host:3306/agent_jaeger_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.jaeger.host:3306/agent_jaeger_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.jaeger.host:3306/agent_jaeger_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
diff --git
a/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/proxy/conf/config-db.yaml
b/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/proxy/conf/config-db.yaml
index 98c552875db..b2b2088815e 100644
---
a/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/proxy/conf/config-db.yaml
+++
b/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/docker/proxy/conf/config-db.yaml
@@ -19,7 +19,7 @@ databaseName: agent-tracing-jaeger-db
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.agent.proxy.jaeger.host:3306/agent_jaeger_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.jaeger.host:3306/agent_jaeger_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 10
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.agent.proxy.jaeger.host:3306/agent_jaeger_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.jaeger.host:3306/agent_jaeger_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/env/engine-env.properties
b/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/env/engine-env.properties
index c732c0c08b5..76bc5fe0dc9 100644
---
a/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/env/engine-env.properties
+++
b/test/e2e/agent/plugins/tracing/jaeger/src/test/resources/env/engine-env.properties
@@ -18,7 +18,7 @@
it.env.type=${it.env}
it.env.value=jaeger
-proxy.url=jdbc:mysql://127.0.0.1:43071/agent-tracing-jaeger-db?serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
+proxy.url=jdbc:mysql://127.0.0.1:43071/agent-tracing-jaeger-db?useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
proxy.username=root
proxy.password=root
diff --git
a/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/jdbc/conf/config.yaml
b/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/jdbc/conf/config.yaml
index 9ca0165c591..9687c5d4242 100644
---
a/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/jdbc/conf/config.yaml
+++
b/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/jdbc/conf/config.yaml
@@ -21,13 +21,13 @@ dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.zipkin.host:3306/agent_zipkin_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.zipkin.host:3306/agent_zipkin_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.zipkin.host:3306/agent_zipkin_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ jdbcUrl:
jdbc:mysql://mysql.agent.jdbc.zipkin.host:3306/agent_zipkin_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
diff --git
a/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/proxy/conf/config-db.yaml
b/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/proxy/conf/config-db.yaml
index 617f99f315c..ffdc80c8440 100644
---
a/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/proxy/conf/config-db.yaml
+++
b/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/docker/proxy/conf/config-db.yaml
@@ -19,7 +19,7 @@ databaseName: agent-tracing-zipkin-db
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.agent.proxy.zipkin.host:3306/agent_zipkin_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.zipkin.host:3306/agent_zipkin_db_0?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 10
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.agent.proxy.zipkin.host:3306/agent_zipkin_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.agent.proxy.zipkin.host:3306/agent_zipkin_db_1?useSSL=false&characterEncoding=utf-8
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/env/engine-env.properties
b/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/env/engine-env.properties
index 3658c0b87a1..699fe744b16 100644
---
a/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/env/engine-env.properties
+++
b/test/e2e/agent/plugins/tracing/zipkin/src/test/resources/env/engine-env.properties
@@ -18,7 +18,7 @@
it.env.type=${it.env}
it.env.value=zipkin
-proxy.url=jdbc:mysql://127.0.0.1:43071/agent-tracing-zipkin-db?serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
+proxy.url=jdbc:mysql://127.0.0.1:43071/agent-tracing-zipkin-db?useSSL=false&useLocalSessionState=true&characterEncoding=utf-8
proxy.username=root
proxy.password=root
diff --git
a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
index 9501b2c9d27..c715bfc5cc7 100644
---
a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
+++
b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
@@ -61,7 +61,7 @@ public final class DataSourceEnvironment {
return
"jdbc:h2:mem:test_db;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MySQL;USER=root;PASSWORD=Root@123";
case "MySQL":
return
String.format("jdbc:mysql://%s:%s?useSSL=true&requireSSL=true&enabledTLSProtocols=TLSv1.2,TLSv1.3&verifyServerCertificate=false"
- +
"&useServerPrepStmts=true&serverTimezone=UTC&useLocalSessionState=true&characterEncoding=utf-8",
host, port);
+ +
"&useServerPrepStmts=true&useLocalSessionState=true&characterEncoding=utf-8",
host, port);
case "PostgreSQL":
return
String.format("jdbc:postgresql://%s:%s/?ssl=on&sslmode=prefer", host, port);
case "openGauss":
diff --git
a/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/proxy/conf/mysql/config-cluster-jdbc-proxy.yaml
b/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/proxy/conf/mysql/config-cluster-jdbc-proxy.yaml
index 35de7738234..b7d0bf1c0c4 100644
---
a/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/proxy/conf/mysql/config-cluster-jdbc-proxy.yaml
+++
b/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/proxy/conf/mysql/config-cluster-jdbc-proxy.yaml
@@ -19,7 +19,7 @@ databaseName: cluster_jdbc_proxy
dataSources:
db:
- url:
jdbc:mysql://mysql.cluster_jdbc_proxy.host:3306/db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.cluster_jdbc_proxy.host:3306/db?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/operation/transaction/src/test/resources/env/scenario/default/proxy/conf/mysql/config-sharding.yaml
b/test/e2e/operation/transaction/src/test/resources/env/scenario/default/proxy/conf/mysql/config-sharding.yaml
index 04220b62717..43382110790 100644
---
a/test/e2e/operation/transaction/src/test/resources/env/scenario/default/proxy/conf/mysql/config-sharding.yaml
+++
b/test/e2e/operation/transaction/src/test/resources/env/scenario/default/proxy/conf/mysql/config-sharding.yaml
@@ -24,7 +24,7 @@
databaseName: sharding_db
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.default.host:3306/ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.default.host:3306/ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -33,7 +33,7 @@ dataSources:
maxPoolSize: 4
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.default.host:3306/ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.default.host:3306/ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-local.yaml
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-local.yaml
index 027995e369e..7902579b83b 100644
---
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-local.yaml
+++
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-local.yaml
@@ -24,7 +24,7 @@
databaseName: sharding_db
dataSources:
write_ds:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -33,7 +33,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -42,7 +42,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-atomikos.yaml
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-atomikos.yaml
index 814815dcced..b1d107409ea 100644
---
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-atomikos.yaml
+++
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-atomikos.yaml
@@ -24,7 +24,7 @@
databaseName: sharding_db
dataSources:
write_ds:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -33,7 +33,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -42,7 +42,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-narayana.yaml
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-narayana.yaml
index 557f16d22a6..c077398f68c 100644
---
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-narayana.yaml
+++
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/jdbc/conf/mysql/config-readwrite-splitting-xa-narayana.yaml
@@ -24,7 +24,7 @@
databaseName: sharding_db
dataSources:
write_ds:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -33,7 +33,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -42,7 +42,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
index c4e830ceb66..59bcf8d7faa 100644
---
a/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
+++
b/test/e2e/operation/transaction/src/test/resources/env/scenario/readwrite-splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
@@ -24,7 +24,7 @@
databaseName: sharding_db
dataSources:
write_ds:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/write_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -33,7 +33,7 @@ dataSources:
maxPoolSize: 4
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -42,7 +42,7 @@ dataSources:
maxPoolSize: 4
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -51,7 +51,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_error:
- url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_error?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite-splitting.host:3306/read_ds_error?useSSL=false&characterEncoding=utf-8
username: test_user
password: wrong_password
connectionTimeoutMilliseconds: 5000
diff --git
a/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-alter.xml
b/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-alter.xml
index 59442df1530..c869aef6196 100644
--- a/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-alter.xml
+++ b/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-alter.xml
@@ -16,7 +16,7 @@
-->
<integration-test-cases>
<!-- TODO FIX HOST CANNOT CONNECT -->
- <!-- <test-case sql="ALTER STORAGE UNIT ds_2
(URL='jdbc:mysql://mysql.rdl.empty_rules.host:3306/rdl_ds_2?serverTimezone=UTC&useSSL=false',
USER='test_user',PASSWORD='Test@123',PROPERTIES('idleTimeout'='30000'));"
db-types="MySQL">-->
+ <!-- <test-case sql="ALTER STORAGE UNIT ds_2
(URL='jdbc:mysql://mysql.rdl.empty_rules.host:3306/rdl_ds_2?amp;useSSL=false',
USER='test_user',PASSWORD='Test@123',PROPERTIES('idleTimeout'='30000'));"
db-types="MySQL">-->
<!-- <assertion expected-data-file="alter_storage_unit.xml">-->
<!-- <assertion-sql sql="SHOW DATABASE RESOURCES" />-->
<!-- </assertion>-->
diff --git
a/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-register.xml
b/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-register.xml
index 1f3d6fc76a6..2be60a2721b 100644
--- a/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-register.xml
+++ b/test/e2e/sql/src/test/resources/cases/rdl/rdl-integration-register.xml
@@ -16,7 +16,7 @@
-->
<integration-test-cases>
<!-- TODO FIX HOST CANNOT CONNECT -->
- <!-- <test-case sql="REGISTER STORAGE UNIT ds_0
(URL='jdbc:mysql://mysql.rdl.empty_rules.host:3306/rdl_ds_0?serverTimezone=UTC&useSSL=false',
USER='test_user',PASSWORD='Test@123');" db-types="MySQL">-->
+ <!-- <test-case sql="REGISTER STORAGE UNIT ds_0
(URL='jdbc:mysql://mysql.rdl.empty_rules.host:3306/rdl_ds_0?amp;useSSL=false',
USER='test_user',PASSWORD='Test@123');" db-types="MySQL">-->
<!-- <assertion expected-data-file="register_storage_unit.xml">-->
<!-- <assertion-sql sql="SHOW DATABASE RESOURCES" />-->
<!-- </assertion>-->
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
b/test/e2e/sql/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
index 1e23711f3cb..168704b0dbf 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
@@ -19,7 +19,7 @@ databaseName: db
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.db.host:3306/db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.db.host:3306/db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_2:
- url:
jdbc:mysql://mysql.db.host:3306/db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_3:
- url:
jdbc:mysql://mysql.db.host:3306/db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_4:
- url:
jdbc:mysql://mysql.db.host:3306/db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_5:
- url:
jdbc:mysql://mysql.db.host:3306/db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_6:
- url:
jdbc:mysql://mysql.db.host:3306/db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_7:
- url:
jdbc:mysql://mysql.db.host:3306/db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_8:
- url:
jdbc:mysql://mysql.db.host:3306/db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 50
minPoolSize: 2
ds_9:
- url:
jdbc:mysql://mysql.db.host:3306/db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.db.host:3306/db_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
index 27dbd5211de..3d1b42a801f 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
@@ -19,7 +19,7 @@ databaseName: dbtbl_with_readwrite_splitting
dataSources:
write_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
index d4adb8cffe9..4405efa9cdd 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
@@ -19,7 +19,7 @@ databaseName: dbtbl_with_readwrite_splitting_and_encrypt
dataSources:
encrypt_write_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 20
minPoolSize: 2
encrypt_write_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
b/test/e2e/sql/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
index 2f4946c4b7d..9f54eda9c6d 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
@@ -19,7 +19,7 @@ databaseName: empty_rules
dataSources:
write_ds_0:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_1:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_2:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_3:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_4:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_5:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_6:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_7:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_8:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_9:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/write_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_2:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_3:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_4:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_5:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_6:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_7:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_8:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_9:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/read_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -199,7 +199,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
rdl_test_0:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/rdl_test_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.empty_rules.host:3306/rdl_test_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
b/test/e2e/sql/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
index 52e62adb616..ee5acbda668 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
@@ -19,7 +19,7 @@ databaseName: encrypt
dataSources:
encrypt:
- url:
jdbc:mysql://mysql.encrypt.host:3306/encrypt?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.encrypt.host:3306/encrypt?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/proxy/conf/mysql/config-encrypt-readwrite-splitting.yaml
b/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/proxy/conf/mysql/config-encrypt-readwrite-splitting.yaml
index b45a8c04f4a..c847752a555 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/proxy/conf/mysql/config-encrypt-readwrite-splitting.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/proxy/conf/mysql/config-encrypt-readwrite-splitting.yaml
@@ -19,7 +19,7 @@ databaseName: encrypt_and_readwrite_splitting
dataSources:
encrypt_write_ds:
- url:
jdbc:mysql://mysql.encrypt_and_readwrite_splitting.host:3306/encrypt_write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.encrypt_and_readwrite_splitting.host:3306/encrypt_write_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds:
- url:
jdbc:mysql://mysql.encrypt_and_readwrite_splitting.host:3306/encrypt_read_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.encrypt_and_readwrite_splitting.host:3306/encrypt_read_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/proxy/conf/mysql/config-encrypt-shadow.yaml
b/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/proxy/conf/mysql/config-encrypt-shadow.yaml
index a8f4c5ebf9e..3d6804693bc 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/proxy/conf/mysql/config-encrypt-shadow.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/proxy/conf/mysql/config-encrypt-shadow.yaml
@@ -19,7 +19,7 @@ databaseName: encrypt_shadow
dataSources:
db:
- url:
jdbc:mysql://mysql.encrypt_shadow.host:3306/db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.encrypt_shadow.host:3306/db?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_shadow_db:
- url:
jdbc:mysql://mysql.encrypt_shadow.host:3306/encrypt_shadow_db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.encrypt_shadow.host:3306/encrypt_shadow_db?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/mask/proxy/conf/mysql/config-mask.yaml
b/test/e2e/sql/src/test/resources/env/scenario/mask/proxy/conf/mysql/config-mask.yaml
index cb422ba05c5..af58ef811b7 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/mask/proxy/conf/mysql/config-mask.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/mask/proxy/conf/mysql/config-mask.yaml
@@ -19,7 +19,7 @@ databaseName: mask
dataSources:
mask:
- url:
jdbc:mysql://mysql.mask.host:3306/mask?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask.host:3306/mask?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/proxy/conf/mysql/config-mask-encrypt.yaml
b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/proxy/conf/mysql/config-mask-encrypt.yaml
index 9ab9d295c21..9c2c17c503e 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/proxy/conf/mysql/config-mask-encrypt.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/proxy/conf/mysql/config-mask-encrypt.yaml
@@ -19,7 +19,7 @@ databaseName: mask_encrypt
dataSources:
mask_encrypt:
- url:
jdbc:mysql://mysql.mask_encrypt.host:3306/mask_encrypt?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt.host:3306/mask_encrypt?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/proxy/conf/mysql/config-mask-encrypt-sharding.yaml
b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/proxy/conf/mysql/config-mask-encrypt-sharding.yaml
index 6a8d7427bb8..a051358fb7a 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/proxy/conf/mysql/config-mask-encrypt-sharding.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/proxy/conf/mysql/config-mask-encrypt-sharding.yaml
@@ -19,7 +19,7 @@ databaseName: mask_encrypt_sharding
dataSources:
mask_encrypt_ds_0:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 10
minPoolSize: 2
mask_encrypt_ds_1:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_2:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_3:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_4:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_5:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_6:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_7:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_8:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_encrypt_ds_9:
- url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_encrypt_sharding.host:3306/mask_encrypt_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/proxy/conf/mysql/config-mask-sharding.yaml
b/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/proxy/conf/mysql/config-mask-sharding.yaml
index 7e55eae321d..443762d989e 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/proxy/conf/mysql/config-mask-sharding.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/proxy/conf/mysql/config-mask-sharding.yaml
@@ -19,7 +19,7 @@ databaseName: mask_sharding
dataSources:
mask_ds_0:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 10
minPoolSize: 2
mask_ds_1:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_2:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_3:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_4:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_5:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_6:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_7:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_8:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
mask_ds_9:
- url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.mask_sharding.host:3306/mask_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/passthrough/proxy/conf/mysql/config-passthrough.yaml
b/test/e2e/sql/src/test/resources/env/scenario/passthrough/proxy/conf/mysql/config-passthrough.yaml
index f0b6f0ddbbe..97ab5b432a5 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/passthrough/proxy/conf/mysql/config-passthrough.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/passthrough/proxy/conf/mysql/config-passthrough.yaml
@@ -19,7 +19,7 @@ databaseName: passthrough
dataSources:
passthrough:
- url:
jdbc:mysql://mysql.passthrough.host:3306/passthrough?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.passthrough.host:3306/passthrough?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/rdl_empty_rules/proxy/conf/mysql/config-rdl-empty-rules.yaml
b/test/e2e/sql/src/test/resources/env/scenario/rdl_empty_rules/proxy/conf/mysql/config-rdl-empty-rules.yaml
index bc867670550..c25fafd5ae9 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/rdl_empty_rules/proxy/conf/mysql/config-rdl-empty-rules.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/rdl_empty_rules/proxy/conf/mysql/config-rdl-empty-rules.yaml
@@ -19,7 +19,7 @@ databaseName: rdl_empty_rules
dataSources:
ds_0:
- url:
jdbc:mysql://mysql.rdl_empty_rules.host:3306/rdl_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.rdl_empty_rules.host:3306/rdl_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.rdl_empty_rules.host:3306/rdl_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.rdl_empty_rules.host:3306/rdl_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_2:
- url:
jdbc:mysql://mysql.rdl_empty_rules.host:3306/rdl_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.rdl_empty_rules.host:3306/rdl_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
index ab1185be21b..ac0374abf22 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
@@ -19,7 +19,7 @@ databaseName: readwrite_splitting
dataSources:
write_ds:
- url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/write_ds?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_0:
- url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/read_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/read_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_1:
- url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/read_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/read_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/proxy/conf/mysql/config-shadow.yaml
b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/proxy/conf/mysql/config-shadow.yaml
index 251326bd725..5542391d940 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/proxy/conf/mysql/config-shadow.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/proxy/conf/mysql/config-shadow.yaml
@@ -19,7 +19,7 @@ databaseName: readwrite_splitting_and_shadow
dataSources:
write_db:
- url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/write_db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/write_db?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_db_shadow:
- url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/write_db_shadow?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/write_db_shadow?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_0:
- url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/read_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/read_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_1:
- url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/read_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.readwrite_splitting_and_shadow.host:3306/read_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
b/test/e2e/sql/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
index 7465a2051ce..799a48594ee 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
@@ -19,7 +19,7 @@ databaseName: shadow
dataSources:
db:
- url:
jdbc:mysql://mysql.shadow.host:3306/db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.shadow.host:3306/db?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db:
- url:
jdbc:mysql://mysql.shadow.host:3306/shadow_db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.shadow.host:3306/shadow_db?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/proxy/conf/mysql/config-sharding-and-encrypt.yaml
b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/proxy/conf/mysql/config-sharding-and-encrypt.yaml
index 9314c93c188..5cf05cde67f 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/proxy/conf/mysql/config-sharding-and-encrypt.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/proxy/conf/mysql/config-sharding-and-encrypt.yaml
@@ -19,7 +19,7 @@ databaseName: sharding_and_encrypt
dataSources:
encrypt_ds_0:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 20
minPoolSize: 2
encrypt_ds_1:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_2:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_3:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_4:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_5:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_6:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_7:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_8:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_ds_9:
- url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_encrypt.host:3306/encrypt_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/proxy/conf/mysql/config-sharding-and-shadow.yaml
b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/proxy/conf/mysql/config-sharding-and-shadow.yaml
index 660cae1aa74..317464a52e1 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/proxy/conf/mysql/config-sharding-and-shadow.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/proxy/conf/mysql/config-sharding-and-shadow.yaml
@@ -19,7 +19,7 @@ databaseName: sharding_and_shadow
dataSources:
db_0:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_1:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_2:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_3:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_4:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_5:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_6:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_7:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_8:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_9:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/db_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_0:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_1:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_2:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_3:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_4:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_5:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_6:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_7:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_8:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_9:
- url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_and_shadow.host:3306/shadow_db_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/proxy/conf/mysql/config-sharding-encrypt-shadow.yaml
b/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/proxy/conf/mysql/config-sharding-encrypt-shadow.yaml
index 5cc1692efe2..4b4cbe9c34d 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/proxy/conf/mysql/config-sharding-encrypt-shadow.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/proxy/conf/mysql/config-sharding-encrypt-shadow.yaml
@@ -19,7 +19,7 @@ databaseName: sharding_encrypt_shadow
dataSources:
db_0:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_1:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_2:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_3:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_4:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_5:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_6:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_7:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_8:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
db_9:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/db_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_0:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_0?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_1:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_1?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_2:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_2?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_3:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_3?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_4:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_4?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_5:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_5?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_6:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_6?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_7:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_7?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_8:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_8?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
shadow_db_9:
- url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.sharding_encrypt_shadow.host:3306/shadow_db_9?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
b/test/e2e/sql/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
index 748285f54c6..6086abd2664 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
@@ -19,7 +19,7 @@ databaseName: tbl
dataSources:
tbl:
- url:
jdbc:mysql://mysql.tbl.host:3306/tbl?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:mysql://mysql.tbl.host:3306/tbl?useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000