Hibernate does not create table automatically in mysql

Question

I’m studying Spring with a little hibernate, where I stopped in a situation I can’t pass.

I configured the code with Hibernate for creating tables in the database but when I run the application it does not create.

My model class:

@Entity

@Table(name="cliente")

public class Cliente {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int id;

    private String nome;


    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getNome() {
        return nome;
    }

    public void setNome(String nome) {
        this.nome = nome;
    }
}

My properties:

server.port=${port:8080}
spring.datasource.url=jdbc:mysql://localhost:3306/clientesdb
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.jpa.hibernate.ddl-auto = update

Mysql without password.

I’m doing something wrong?

Answer 1

I decided to put the annotation to scan my entity package in my Application class:

@Entityscan(basePackages = {"br.com.springboot.model"})

Answer 2

I solved my problem by making the correct import(javax.persistence.Entity) I am using spring.jpa.Hibernate.ddl-auto=update

Answer 3

I was making that same mistake.

I managed to solve using:spring.jpa.hibernate.ddl-auto=update. Remember that I had put ?useTimezone=true&serverTimezone=UTC in my datasource.url, but I think this served only for another problem I had before. My properties got this way:

spring.jpa.hibernate.ddl-auto=update spring.datasource.url=jdbc:mysql://localhost:3306/nome_do_database?useTimezone=true&serverTimezone=UTC spring.datasource.username=usuario spring.datasource.password=senha spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

Answer 4

Missing add the dialect in their properties

spring.datasource.url=jdbc:mysql://localhost:3306/clientesdb​;create=true
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.jpa.hibernate.ddl-auto=update

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.show-sql=true

I also put the show-sql if not certain, post the sql being generated

Another important point is also to check the import of your Entity, check if your import is javax.persistence.Entity