Post subject: POJO generator from SQL query

[kubap.]

Hi,

Is this possible to generate in JBoss Tools (or using Eclipse any plugin) POJO class from SQL query e.g.

SELECT e.first_name,
 e.last_name,
 e.salary,
 d.department
 FROM emp e,
 dept d
 WHERE e.deptno = d.deptno

I need paste this query into any tool and generate POJO class like this:

public class Employee{

 public Employee(){}

 private String firstName;
 private String lastName;
 private Number salary
 private String department;

 /* getters and setters here*/
}

Kuba

[vyemialyanchyk]

Hi.

if I do not dig into the details - it is possible to generate POJO classes from DB tables. You can use Hibernate Tools for this. Take a look od documentation.

From SQL query - this is not possible.

[ochikvina]

Take a look at Hibernate Tools docs: http://download.jboss.org/jbosstools/nightly-docs/en/hibernatetools/html_single/index.html#refeng_codegen