how to create table which contains object-column?

[aupres]

I am develoiping simple entity-mapping project on jboss 7 and indigo.

This is my source code :

======Members.java =======

@Entity

@Table(name = "family")

public class Members implements Serializable {

    @Id

    @Column(name = "EMP_ID")

    private String id ;

    @Column(name = "EMP_Passwd")

    private String passwd ;

    @Column(name = "EMP_Name")

    private String name ;

    @Column(name="EMP_Record")

    @OneToMany(fetch=FetchType.EAGER, mappedBy="member", cascade=CascadeType.ALL)

    private List<Records> record = new ArrayList();

..........

======Records.java=========

@Entity

@Table(name = "info")

public class Records implements Serializable {

    @Id

    @GeneratedValue(strategy=GenerationType.IDENTITY)

    @Column(name = "EMP_ID")

    private int i;

    @ManyToOne(fetch=FetchType.EAGER, cascade=CascadeType.ALL)

    @JoinColumn(name="EMP_Record")

    private Members member;   // this is the problem....

    @Column(name = "EMP_Bank_Account")

    private String account;

    @Column(name = "EMP_Hobby")

    private String hobby;

    @Column(name = "EMP_Phone")

    private int phone;

I try to create 2 tables(family and info). Creation of family table is succeeded but i have some problem in creation of table info.

I don't know how to create Members column in info table. It is java obejct class.

create table info

(

   ...

   Membser ????? //pls, advise me

   EMP_Bank_Account varchar(20) not null,

   EMP_Hobby varchar(20) not null,

   phone int

..........

Pls inform me how to create table with java-object-column!

Best Regards,

[riggs]

Hello Joseph,

to me your problem seems to be a JPA (or hibernate)-specific one. You want to know how to map a reference between your entities to a table in a relational database, right? You then might want to have a look at this page: http://en.wikibooks.org/wiki/Java_Persistence/OneToMany

Or try a google search with "jpa onetomany".

Does this help you?