使用Druid创建MySQL链接时在DruidAbstractDataSource.createPhysicalConnection产生SQLException异常

 一、使用Druid创建数据库链接时报错

1.  
   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
2.  
   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
3.  
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1627)
4.  
   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+8&allowPublicKeyRetrieval=true

注意斜线等内容

这篇好文章是转载于：学新通技术网