Hi,
I have seen the option in Hibernate to create XML annotation files, however is there a tool to create POJO annotation file direct from SQL commands?
Example SQL input:
CREATE TABLE T126_PROJECTS( PID BIGINT NOT NULL, CL_COMMIT_RPID BIGINT NOT NULL, COMMENCED TIMESTAMP NOT NULL, PROJECT_CODE SMALLINT NOT NULL, PROJECT_OFFSET BIGINT NOT NULL, PROJECT_NAME VARCHAR(100) NOT NULL );
and generate output as the POJO Java annotation file as:
@Entity @Table(name="T126_PROJECTS") public class T126_Projects { @Id @Column(name="PID") private long pid; @Column(name="CL_COMMIT_RPID") private long clCommit; @Column(name="COMMENCED") private String timeStamp; @Column(name="PROJECT_CODE") private int projectCode; @Column(name="PROJECT_OFFSET") private long projectOffset; @Column(name="PROJECT_NAME") private String projectName; public T126_Projects() { System.out.println("T126_Projects constructor"); } }
I am using Eclipse so the get/set methods and toString() can be automatic generated if I have the basis annotation class setup.
Nils