Spring Boot应用程序中的H2模式为空

Question

我正在设置一个barebones Spring Boot项目，我在基本设置中遇到了一些问题。

DatabaseLoader似乎没有被调用，并且当我打开这个项目的H2控制台时，我没有看到包含Employee表的模式。

以下是我的pom.xml的相关部分：

<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-data-rest</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-thymeleaf</artifactId>
    </dependency>

    <dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <!-- 
        <scope>runtime</scope>
         -->
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.16.4</version>
        <scope>provided</scope>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
        <optional>true</optional>
    </dependency>
</dependencies>

@Data
@Entity
public class Employee {
    private @Id @GeneratedValue Long id;
    private String firstName;
    private String lastName;
    private String description;

    public Employee() {}

    public Employee(String firstName, String lastName, String description) {
        this.firstName = firstName;
        this.lastName = lastName;
        this.description = description;
    }

}

    @Autowired
    public DatabaseLoader(EmployeeRepository repository) {
        this.repository = repository;
    }

    @Override
    public void run(String... strings) throws Exception {
        this.repository.save(new Employee("duke", "earl", "dude"));
    }

}

POST:{"firstName": "Bilbo", "lastName": "Baggxins", "description": "burglar"}

带着：

{
  "_links": {
    "self": {
      "href": "http://localhost:8080/api/employees/4"
    },
    "employee": {
      "href": "http://localhost:8080/api/employees/4"
    }
  }
}

Answer 1

Spring Boot的默认h2 url是:jdbc:h2:mem:testdb

要使用JDBC:H2:~/test，必须将其添加到应用程序中。properties:

spring.h2.console.enabled=true
spring.datasource.url=jdbc:h2:~/test

正在发生的是，您正在将雇员写入Spring-Boot的内存数据库（testdb）中。然后，打开h2-console到jdbc:h2:~/test，这将动态创建它，并让您浏览空状态。

null