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%2B8,GMT%2B8表示:东八区,或 serverTimezone=Asia/Shanghai
3.密码或帐号有误;
4.数据库未启动或无权访问;
5.补充:mysql 8.0 需要对应更高的 c3p0 版本,可使用:0.9.5.2