IntelliJ中SpringBoot通过JDBC连接MySQL失败排查求助

使用IntelliJ IDEA开发SpringBoot 3.2.0（Java17）项目，通过JDBC连接MySQL时，代码无语法错误但始终无法建立连接。按application.yaml配置，应自动创建cloud_vendor schema，但运行后抛出异常，核心错误为无法获取JDBC元数据、无法确定Hibernate Dialect。

pom.xml配置 #

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>3.2.0</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.restApi</groupId>
    <artifactId>RestAPI</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>RestAPIDemo</name>
    <description>Demo project for RestAPI</description>
    <properties>
        <java.version>17</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <version>8.2.0</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

application.yaml配置 #

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/cloud_vendor?useSSL=false
    username: root
    password: root

#jpa settings
  jpa.hibernate.ddl_auto: create

报错日志 #

2023-12-11T21:01:13.209+05:30  WARN 17680 --- [           main] o.h.e.j.e.i.JdbcEnvironmentInitiator     : HHH000342: 无法获取连接以查询元数据

java.lang.NullPointerException: Cannot invoke "org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(java.sql.SQLException, String)" because the return value of "org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.sqlExceptionHelper()" is null
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:116) ~[hibernate-core-6.3.1.Final.jar:6.3.1.Final]
    ...
2023-12-11T21:01:13.211+05:30 ERROR 17680 --- [           main] j.LocalContainerEntityManagerFactoryBean : 初始化JPA EntityManagerFactory失败：无法创建请求的服务[org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]，原因：无JDBC元数据时无法确定Dialect（请设置'javax.persistence.jdbc.url'、'hibernate.connection.url'或'hibernate.dialect'）
...
Process finished with exit code 1

解决方案 #

1. 修复application.yaml缩进错误 #

YAML对缩进敏感，原配置中JPA属性未正确归到spring节点下，同时显式指定Hibernate方言避免自动检测失败：

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/cloud_vendor?useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: root
  # JPA配置
  jpa:
    hibernate:
      ddl-auto: create
    properties:
      hibernate:
        dialect: org.hibernate.dialect.MySQL8Dialect

2. 检查MySQL基础状态 #

• 确认本地MySQL服务正在运行，端口3306未被占用
• 验证root账号密码正确性，确保该账号拥有创建数据库、表的权限

3. 补充时区参数 #

MySQL 8.0+必须指定时区，在JDBC URL中添加&serverTimezone=Asia/Shanghai（根据所在地区调整时区值）

4. 手动创建目标数据库 #

ddl-auto: create仅负责创建表，不会自动创建数据库，需手动执行SQL创建：

CREATE DATABASE IF NOT EXISTS cloud_vendor;

内容的提问来源于stack exchange，提问作者Laishram Trinity