Notes(一):Connections could not be acquired from the underlying database!
自定义持久层框架问题问题:解决方式:
自定义持久层框架问题
问题:
连接数据库时,出现:Connections could not be acquired from the underlying database!
解决方式:
1. 驱动配置有误:
mysql 5.0 配置:com.mysql.jdbc.Driver mysql 8.0 配置:com.mysql.cj.jdbc.Driver
2.数据库连接地址有误:
当出现如下错误时:
Caused by
: java
.sql
.SQLException
: The server time zone value
'�й���ʱ��' is unrecognized or represents more than one time zone
. You must configure either the server or JDBC driver
(via the
'serverTimezone' configuration property
) to use a more specifc time zone value
if you want to utilize time zone support
.
是由于mysql 8.0的驱动包需要设置时区, 在 jdbcUrl 后面加 :serverTimezone=GMT+8,GMT+8表示:东八区,或 serverTimezone=Asia/Shanghai
3.密码或帐号有误;
4.数据库未启动或无权访问;
5.补充:mysql 8.0 需要对应更高的 c3p0 版本,可使用:0.9.5.2