how to use spring.jpa.hibernate.ddl-auto

Question

I currently have hibernate.ddl set:

spring.jpa.hibernate.ddl-auto = create-drop

I don't to lose my data again and again... What value I can use Instead of deleting and creating the schema every time Is there a way to update the existing one?
I was trying to use update in place of create-drop but it throws an exception:

 [ERROR] Failed to execute goal org.springframework.boot:spring-boot-maven-plugin:1.3.3.RELEASE:run (default-cli) on project fno-connector-core: 
An exception occurred while running. null: InvocationTargetException: 
Failed to execute SQL script statement #1 of URL [file:/D:/..../classes/data.sql]: 
insert into users (username, enabled, password, first_name, last_name, email) 
values ('admin', true, '************', 'Flexera', 'Admin', 'aurovindosahu@*****.com'); 
nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry 'admin' for key 'PRIMARY'

Rohit Gaikwad · Accepted Answer · 2017-10-30 06:17:12Z

2

Possible values of spring.jpa.hibernate.ddl-auto are e.g. none | validate | update | create | create-drop. Reference

Make use of update in your usecase.

answered Oct 30, 2017 at 6:17

Rohit Gaikwad

3,9443 gold badges21 silver badges42 bronze badges

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

2 Comments

Aurovindo Over a year ago

First i am using create and after that If i use update then it throws exception

Rohit Gaikwad Over a year ago

What is the exception? You can first drop the tables then re-run a fresh program with update.

Collectives™ on Stack Overflow

how to use spring.jpa.hibernate.ddl-auto

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related