generating java entities from MySQL tables

Question

I have 3 MySQL tables and i need to generate their corresponding entities in java (eclipse) is there an easy way ? im working on a spring boot application

Have you tried this

Sudoss
– Sudoss

2020-08-11 08:22:34 +00:00
Commented Aug 11, 2020 at 8:22 — Sudoss
– Sudoss, Commented Aug 11, 2020 at 8:22
@Sudoss i did i couldn't find the jpa tools...

jayzee
– jayzee

2020-08-11 08:43:18 +00:00
Commented Aug 11, 2020 at 8:43 — jayzee
– jayzee, Commented Aug 11, 2020 at 8:43

Roie Beck · Accepted Answer · 2020-08-11 10:08:46Z

1

While the majority of people will recommend jpa(spring data) this is codeFirst approach, for DB first approach I have a great framework recommendation:

If you have some time on your hand I will go and try Jooq

Jooq website

Jooq has a maven dependency for creating all necessary objects from your db:

Jooq auto code generation from db

codeGen configuration in maven

Jooq can connect to your db, and even connect to your liquibase schema upgrades so that the object are always on the same stage with the db

I don't have any connection to Jooq but Lukas Eder (@lukaseder) is an awsome guy, he always answer questions in stack Overflow, so you are in good hands, also if you are using reactor Jooq is fully compatible(also compatible with JavaRX)

edited Aug 11, 2020 at 10:08

answered Aug 11, 2020 at 9:08

Roie Beck

1,1753 gold badges19 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

generating java entities from MySQL tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related