Spring boot ddl auto generator

Question

I'm using spring boot with spring.jpa.hibernate.ddl-auto=create, but when application restarted, all tables drops and creates again. Is there some way to avoiding re-creation for already existing tables?

Prosecutor

Answer 1

spring.jpa.hibernate.ddl-auto=update

hibernate.ddl-auto should usually not be used in production.

Britannia

@IllSc lots of discussion here: #221879 – Britannia

WHY should not be used in production? – Calloway

Check the link in my previous comment. – Britannia

Can't find this words – Calloway

Answer 2

The list of option which is used in the spring boot are

• validate: validate the schema, makes no changes to the database.
• update: update the schema.
• create: creates the schema, destroying previous data.
• create-drop: drop the schema at the end of the session
• none: is all other cases.

So for avoiding the data lose you use update

Orta