How to build and populate DB using JPA entities?

Question

I have Java Spring project which is using CrudRepository for the entities in the DB (postgresql).

I need to have a quick way to use the entities definitions in order to create the DB tables and constraints, I don't want to use SQL queries to do that, or Java code.

Also, I want to create a populator for these entities with fake data, using maven plugin.

I was looking in the WEB to find best practices to reach above functionality and I couldn't find.

Did you see Liquibase: liquibase.org

0xh3xa
– 0xh3xa

2020-03-23 14:22:29 +00:00
Commented Mar 23, 2020 at 14:22 — 0xh3xa
– 0xh3xa, Commented Mar 23, 2020 at 14:22

Marcos Barbero · Accepted Answer · 2020-03-23 14:26:33Z

2

To create the database schema from the entities' definition, you can use the property spring.jpa.hibernate.ddl-auto.

And for the data initialization, you can create a data.sql script at your resources, and it will run on the application initialization.

You can read more about it at the docs.

For a more fine-grained solution, you can use tools like Liquibase and Flyway.

answered Mar 23, 2020 at 14:26

Marcos Barbero

1,1198 silver badges14 bronze badges

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

1 Comment

cactuschibre Over a year ago

For me data.sql is not read when spring.jpa.hibernate.ddl-auto is not none. It is only read when spring.jpa.hibernate.ddl-auto is none so the schema needs to exist. Any idea ?

Collectives™ on Stack Overflow

How to build and populate DB using JPA entities?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related