How can I transform Entity-Based diagram to a JPA java code

Question

I have class diagram created with "Sparx Enterprise Architect v8.0" and i need to generate JPA-based classes with annotations that reflect relations to use it in the code. The problem is that i can convert it to EJB but not JPA which is required for my task.

if you are interested in MDA I would invite you to follow this stack overflow like QA group dedicated to MDA topics [>MDA<](http://area51.stackexchange.com/proposals/36533/model-driven-architecture). — Andrea Sindico, Nov 21 '11 at 13:01

score 2 · Accepted Answer · answered Nov 20 '11 at 15:14

2

I don't know this product, however they claim that it:

supports modeling of database schema and automatic generation of DDL scripts for eleven DBMS targets out-of-the-box

Once you have the database schema I believe there are various tools that can reverse engineer it and generate JPA entities. Few random hits in Google:

answered Nov 20 '11 at 15:14

Tomasz Nurkiewicz

334,321
69
703
674

Dear Tomasz, Thank you for your response, actually I not am looking for reverse engineering, the Idea is generating the database schema and DAO classes from class diagram. – user1056442 Nov 21 '11 at 08:50
Sorry, maybe I wasn't clear enough and you misunderstood me. I don't know *Sparx Enterprise Architect*, but it can generate database schema for you (DDL script, see quote above), and from DDL script (existing databse schema) you can easily create JPA entities with various tools (see links). – Tomasz Nurkiewicz Nov 21 '11 at 09:01
If you find this approach helpful consider accepting an answer. Otherwise please provide more detail so me and other could think about it more. – Tomasz Nurkiewicz Nov 21 '11 at 10:36

jGauravGupta · Answer 2 · 2014-02-27T11:12:40.843

0

Have a look at the JPA Modeler for Netbeans, will be best fit for your requirement :

generate the database schema and DAO classes from class diagram

You can find the demo here : JPA Modeler Demo - Youtube

edited Feb 27 '14 at 11:12

answered Feb 25 '14 at 11:06

jGauravGupta

155
8

score 0 · Answer 3 · answered Oct 08 '15 at 06:32

0

If you export your model to ecore format, then you can use Texo to generate JPA annotated POJO for your model.

answered Oct 08 '15 at 06:32

Vladimir Vaschenko

508
3
19

score 0 · Answer 4 · answered Oct 23 '18 at 07:04

G9 plugin from Marketplace in Spring Tool Suit did job.

Install Plugin G9
Select Project (JAVA)
Import "Import Database Model"
Select JDBC Driver (In my case mysql)
Maintain JDBC Connection
- New
- Provide Driver Name, Add Jar, Port, Driver Class and connection url along with schema (jdbc:mysql://localhost:3306/{schema_name})
Close JDBC Connection Box
Port, DB Name, User Name and PWD
Fetch

Reference URL https://www.esito.no/produkter/dbimport/

How can I transform Entity-Based diagram to a JPA java code

4 Answers4

Linked