Creating Java objects from SQL DDL statements

Question

I am looking for some existing library in java which is capable of parsing a SQL DDL statements, which is capable of doing this:

Say I have a table as follows :

create table emp
(
  name varchar(20),
  empid int,
  date_of_joining date
);

Then, I want a class with the following constructor:

Emp(String name, int empid, Date date_of_joining)

Now, if we someone changes the schema of the table as follows:

alter table emp 
add salary double;

Emp(String name, int empid, Date date_of_joining, double salary)

alter table emp 
modify empid varchar(6);

Emp(String name, String empid, Date date_of_joining, double salary)

Is there something already existing, which does something lie this ?

Those are ORM libraries like Hibernate, TopLink and DataNucleus. — Luiggi Mendoza
– Luiggi Mendoza, Commented Aug 8, 2014 at 16:59
Duplicate as well of stackoverflow.com/questions/4794777/… — Andrew Scott Evans
– Andrew Scott Evans, Commented Aug 8, 2014 at 17:04
I have never used Hibernate, but from what I am guessing they are based on `xml' files. At least, That's how they do it in my company's ORM. But I don't want to read fem a xml file, but from a sql file. — OneMoreError
– OneMoreError, Commented Aug 8, 2014 at 17:05

Neil McGuigan · Accepted Answer · 2014-08-10 00:59:36Z

1

Use Hibernate Tools Reverse Engineering.

It doesn't parse raw SQL files, but can connect to a SQL database, and generate Java POJOs from your schema.

http://docs.jboss.org/tools/4.1.0.Final/en/hibernatetools/html_single/index.html#refeng_codegen

It won't make parameterized constructors for you out-of-the-box, but you could customize its templates, or use Lombok:

http://projectlombok.org/features/Constructor.html

Frankly, I'd go the other way. Update the database schema from Java POJOs. Why? Database Table Inheritance. It's easy to declare using JPA, but there's no common pattern for declarative table inheritance in SQL.

edited Aug 10, 2014 at 0:59

answered Aug 8, 2014 at 17:59

Neil McGuigan

48.5k12 gold badges130 silver badges156 bronze badges

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

Collectives™ on Stack Overflow

Creating Java objects from SQL DDL statements

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related