How to prevent db from initialize when spring boot restart

Question

I started to learn spring boot and now currently working on a simple authentication project. But I have a problem. Database is always initialized. I configure application properties like this.

spring.datasource.initialization-mode=never
spring.jpa.open-in-view=false
spring.thymeleaf.cache=false

I set initialization-model "never". But it does not work. Db is consist of two tables: users and roles. Of course users and roles has ManyToMany relation and has user_role table.

public class User {

//...

@ManyToMany(cascade=CascadeType.ALL)
    @JoinTable(name="user_role", joinColumns = @JoinColumn(name="user_id", referencedColumnName = "id"),
            inverseJoinColumns = @JoinColumn(name="role_id" , referencedColumnName = "role_id"))
    private Set<Role> roles;
}

What could be a problem?

Can you share more details. Property you added is correct and should work. Is it causing you any failure or anything else?? If error is there you can use property -> spring.datasource.continue-on-error=true — Kunal Vohra
– Kunal Vohra, Commented Dec 7, 2019 at 12:49

Felipe Bonfante · Accepted Answer · 2019-12-07 09:29:02Z

1

Assuming you're using spring-data-jpa, you could set the following property:

spring.jpa.hibernate.ddl-auto

The possible values are: create, create-drop, validate, and update.

On your case, it would be better set update.

answered Dec 7, 2019 at 9:29

Felipe Bonfante

7036 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam · Accepted Answer · 2019-12-07 10:22:32Z

0

If you do not want spring-boot to a reinitialize your db, then you should use the property spring.jpa.generate-ddl=false

answered Dec 7, 2019 at 10:22

Sam

6321 gold badge5 silver badges11 bronze badges

1 Comment

devcrazy Over a year ago

Thank for your answer. But it does not work for me. I configure spring.jpa.generate-ddl=false. But data in db always be cleared when restart.

Collectives™ on Stack Overflow

How to prevent db from initialize when spring boot restart

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related