一、使用Druid创建数据库链接时报错
2023-02-15 15:53:49.353 [planflight] [Druid-ConnectionPool-Create-1819862363] ERROR [DruidDataSource.java:2471] - create connection SQLException, url: jdbc:mysql:127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true, errorCode 0, state null
java.sql.SQLException: connect error, url jdbc:mysql:127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true, driverClass com.mysql.cj.jdbc.Driver
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1627)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468)
二、造成本次异常原因
根本原因为jdbc-url错误,标准格式为
jdbc:mysql://[host][:port]/[database]
例如本例应修改为
jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
注意斜线等内容