Notes(一):Connections could not be acquired from the underlying database!

    科技2022-07-10  143

    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

    Processed: 0.027, SQL: 8