过去运用xml文件对Mysql数据库进行配置时,在url字段经常需要使用 & 对 & 进行转义,而在yml文件或properties文件中,直接用 & 进行url不同参数间连接即可,无需加转义符
示例如下
加转义符的代码
server:
port: 8080
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/aa?useSSL=false&serverTimezone=UTC
username: root
password: "1234"
报错如下
java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near ';serverTimezone=UTC'.
改正后(如下图,即可正常运行)
server:
port: 8080
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/aa?useSSL=false&serverTimezone=UTC
username: root
password: "1234"