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