Hibernate连接MySQL报Could not create connection与NullPointerException求助
问题描述
我正在学习Hibernate框架,使用的开发工具为IntelliJ。我可以通过数据源正常连接MySQL并操作数据库,但是初始化SessionFactory时始终报错。
相关配置
hibernate.cfg.xml配置
<session-factory> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost:3306/bookstore?serverTimezone=UTC</property> <property name="connection.username">root</property> <property name="connection.password">root</property> <property name="show_sql">true</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property> <mapping class="codejava.Book" /> </session-factory>
SessionFactory初始化代码
protected void setup(){ final StandardServiceRegistry registry = new StandardServiceRegistryBuilder() .configure() // 从hibernate.cfg.xml加载配置 .build(); try { sessionFactory = new MetadataSources(registry).buildMetadata().buildSessionFactory(); } catch (Exception ex) { StandardServiceRegistryBuilder.destroy(registry); } }
报错日志
WARN: SQL Error: 0, SQLState: 08001 Aug. 15, 2021 7:31:07 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Could not create connection to database server. Aug. 15, 2021 7:31:07 PM org.hibernate.service.internal.AbstractServiceRegistryImpl stopService INFO: HHH000369: Error stopping service [class org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl] java.lang.NullPointerException at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.stop(DriverManagerConnectionProviderImpl.java:207) at org.hibernate.service.internal.AbstractServiceRegistryImpl.stopService(AbstractServiceRegistryImpl.java:390) at org.hibernate.service.internal.AbstractServiceRegistryImpl.destroy(AbstractServiceRegistryImpl.java:373) at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.destroy(StandardServiceRegistryImpl.java:129) at org.hibernate.boot.registry.StandardServiceRegistryBuilder.destroy(StandardServiceRegistryBuilder.java:389) at codejava.BookManager.setup(BookManager.java:22) at codejava.BookManager.main(BookManager.java:93) Exception in thread "main" java.lang.RuntimeException: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] at codejava.BookManager.setup(BookManager.java:23) at codejava.BookManager.main(BookManager.java:93)
我尝试过根据网上的解决方案在JDBC连接URL后添加serverTimezone参数,但是仅改变了报错类型,始终无法解决问题。
解决方案
- 第一步:核对MySQL服务版本和驱动版本匹配性
你遇到的08001连接失败错误90%以上是版本不匹配导致:
如果你本地安装的是MySQL 8.0+版本,按以下修改:- 项目依赖中更新mysql-connector-java版本到8.x系列,比如Maven配置:
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.26</version> </dependency>- 替换hibernate.cfg.xml中的驱动类为
com.mysql.cj.jdbc.Driver,旧的com.mysql.jdbc.Driver在8.x驱动中已被废弃 - 替换Hibernate方言为
org.hibernate.dialect.MySQL8Dialect,适配8.x版本特性 - 更新JDBC连接URL为:
替换UTC时区为国内时区,新增的参数可以解决SSL校验、公钥检索等常见连接问题jdbc:mysql://localhost:3306/bookstore?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true - 第二步:核对配置文件路径
确认hibernate.cfg.xml放在项目的src/main/resources根目录下,且IntelliJ已将该目录标记为「资源根」(右键目录→Mark Directory as→Resources Root),否则Hibernate无法加载到配置。 - 第三步:补充异常打印定位根因
你当前的catch块只销毁了资源没有打印异常,无法判断具体错误,修改catch块代码:
打印完整堆栈后可以直接定位到是配置错误、依赖缺失还是权限问题。catch (Exception ex) { ex.printStackTrace(); StandardServiceRegistryBuilder.destroy(registry); throw new RuntimeException("SessionFactory初始化失败", ex); } - 第四步:核对连接参数
确认你本地MySQL服务端口确实是3306,root账号密码为root,且root账号允许本地登录,bookstore库已提前创建。
内容的提问来源于stack exchange,提问作者TestModus
相关产品推荐
相关产品推荐

