Jpa Hibernate does not create table in H2

Question

Good night,

I am new in Java development - Spring Boot and following a tutorial I can not generate the table in the H2 database, already tried to make some changes in the application.propreties but without success.

<?xml version="1.0" encoding="UTF-8"?>

http://maven.apache.org/xsd/maven-4.0.0.xsd"> 4.0.0 org.springframework.boot spring-boot-Starter-Parent 2.0.0.RELEASE com.julio.curswto curswto 0.0.1-SNAPSHOT curswto Java home study for conceptual modeling course with UML

<properties>
    <java.version>1.8</java.version>
</properties>

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

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <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-devtools</artifactId>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>
</dependencies>

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

Answer 1

You are using wrong properties, it should be:

spring.jpa.hibernate.ddl-auto=update

As described in Ocds:

spring.jpa.hibernate.ddl-auto= # DDL mode. This is actually a shortcut for the "hibernate.hbm2ddl.auto" property. Defaults to "create-drop" when using an embedded database and no schema manager was detected. Otherwise, defaults to "none". 

You can check the correct properties on documentation

---

Your package structure is incorrect, please follow the structure described in documentation.

In short:

• Component Scan is the Spring feature that scans your classes and automatically configures entities and service classes, repositories, etc...

This is automatically performed for all packages that are below the hierarchy of their class main, in your case com.example.demo.

You have classes outside this hierarchy (such as curso.julio.cursomc.domain. These classes shall not be scanned.

Change the hierarchy of your packages and should work accordingly.