Spring H2驱动程序问题

Question

我正在尝试运行一个CRUD应用程序，但我得到了一个错误

2020-12-22 09:48:40.787警告83274--[main]ConfigServletWebServerApplicationContext：上下文初始化过程中遇到异常-取消刷新尝试：org.springframework.beans.factory.unsatistifiedDependencyException：创建名为“org.springframework.boot.autocigure.orm.jpa.HibernateJpaConfiguration”的bean时出错：通过构造函数参数0表示了不满足的依赖关系；嵌套异常为org.springframework.beans.factory.beanCreationException：创建类路径资源[org/springframework/boot/autoconfigure/jdbc/datasourceConfiguration$hikari.class]中定义的名为“data source”的bean时出错：通过工厂方法实例化bean失败；嵌套异常为org.springframework.beans.beanInstantiationException：无法实例化[com.zaxxer.hikari.hikaridataSource]:工厂方法“data source”引发异常；嵌套异常为java.lang.IllegalStateException：无法加载驱动程序类:org.h2.driver

我连不上H2。它在application.properties中以红色键入，如下所示。

这也是我的完整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>2.3.2.RELEASE</version>
    <relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>API</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>API</name>
<description>Demo project for Spring Boot</description>

<properties>
    <java.version>11</java.version>
</properties>

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <scope>runtime</scope>
    </dependency>
    <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>javax.validation</groupId>
        <artifactId>validation-api</artifactId>
        <version>2.0.1.Final</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <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-html" target="_blank">maven-plugin</artifactId>
        </plugin>
    </plugins>
</build>

Answer 1

您不需要指定driverclassname或database-platform，在添加了h2依赖项之后，Spring将使用默认值。是否需要在依赖项中使用mysql-connector-java？