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?

score 102 · Answer 1 · edited Sep 17 '18 at 14:42

102

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

edited Sep 17 '18 at 14:42

Levente Orbán

67
12

answered Mar 31 '16 at 18:48

sudar

1,456
2
13
25

samlewis · Accepted Answer · 2020-05-13T20:36:07.993

71

spring.jpa.hibernate.ddl-auto=update

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

edited May 13 '20 at 20:36

answered Jan 14 '14 at 12:07

samlewis

3,810
26
27

2

@IllSc lots of discussion here: http://stackoverflow.com/questions/221379/hibernate-hbm2ddl-auto-update-in-production – samlewis Apr 14 '15 at 16:37
WHY should not be used in production? – lalilulelo_1986 May 07 '20 at 19:29
Check the link in my previous comment. – samlewis May 13 '20 at 20:39
Can't find this words – lalilulelo_1986 May 14 '20 at 19:31

Spring boot ddl auto generator

2 Answers2

Linked

Related