How to set an entity with enum column with default property value in SpringBoot

Question

I am using Springboot 2.7.2with Hibernate and Mysql 8. Is there a way to make an Entity class so as to execute a create table Query like this.

CREATE TABLE `settings` (
    `SettingsId` enum('1') NOT NULL,
    ................,
    ................,
     PRIMARY KEY (`SettingsId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

score 0 · Answer 1 · answered Aug 25 '22 at 06:58

0

Did you try this?

add @EnableAutoConfiguration
add application.properties. like below :
- spring.jpa.hibernate.ddl-auto=create
- spring.jpa.generate-ddl=true

answered Aug 25 '22 at 06:58

arthur.yoon

1
4

Please note that `Mysql` `data type` is `enum`. – Renoj Joseph Aug 25 '22 at 10:15
1

Oh I missed it. @Column(columnDefinition = "ENUM('1', ... , '10' )") will be do that – arthur.yoon Aug 25 '22 at 13:26

score 0 · Accepted Answer · answered Aug 25 '22 at 14:14

I have got the answer from here and made the Entity Class like this

@Entity
public class Settings {
    public enum SettingsId {
    }

    @Id
    @Enumerated(EnumType.STRING)
    @Column(columnDefinition = "ENUM('1')")
    private SettingsId settingsId;

    ........;
    ........;
}

How to set an entity with enum column with default property value in SpringBoot

2 Answers2