CODEWITHSUNDEEP
javadatabasehibernate
Optiplex980
Optiplex980

Reputation:

How to generate model from database

I have an existing database. I need to generate the model classes in Java from it. Are there any tool/library that will allow me to do this. It will be of great help if it can emulate the entity relationships in the database into the model classes as well.

It is acceptable if the tool/library works with only one database vendor. I will create a database there and then generate the model.

Thanks in advance.

EDIT : I will probably use Hibernate as the ORM framework if I manage to generate the model.

Upvotes: 7

Views: 14720

Answers (4)

lgu
lgu

Reputation: 2460

Telosys does exactly this job

Let's have a look : http://www.telosys.org/

Upvotes: 4

xflorian
xflorian

Reputation: 365

Minuteproject 4 JPA2 (http://minuteproject.wikispaces.com/JPA2) track does this task. Minuteproject can be run from console or command line.

You can have a quick result by generating from the console where generate a maven project containing the JPA2 mapping classes in java or groovy. If you use the command line then you need to fill an xml file that can contain additional customisation of your generated code such as packaging, enum, aliasing etc...

You can also try other track built on top JPA2 such as DAO with spring or EJB; REST; front end with Primefaces or Openxava; etc...

Upvotes: 1

Vineet Reynolds
Vineet Reynolds

Reputation: 76709

The Hibernate Tools project (available as an Eclipse plug-in, as well as an Ant task) allows for "reverse-engineering" of database schemas into appropriate entity classes.

This project is also available in the JBoss Tools project.

The facility allows for reverse-engineering of the database metadata into a Hibernate configuration file. All artifacts (including the .java files) are generated from this config file.

You can control the nature of the reverse engineering process to suit your database structure. In other words, you can specify the schemas that you wish to have the tool reverse-engineer. You could also override the JDBC type mapping, apart from limiting the reverse-engineering process to a selected set of tables.

Obligatory link:

Upvotes: 5

Danny D'Amours
Danny D'Amours

Reputation: 712

Hibernate has an Eclipse plugin Hibernate Tools http://www.hibernate.org/subprojects/tools.html that has reverse engineering capabilities.

See: http://docs.jboss.org/tools/3.2.0.GA/en/hibernatetools/html/plugins.html#refeng_codegen for more details on how to run and customize the reverse engineering process.

Upvotes: 0

Related Questions