1 Reply Latest reply: Jan 12, 2007 12:48 AM by 843844 RSS

    How to create relationships within tables using hibernate/mysql

    843844
      Hi,
      I need to create following relationships between tables i have below.
      I am new to hibernate.
      I am using Mysql as database.

      These are the following table with relationships.
      Need to write create,select,update query for these relationships between table.


      Bran_comm table
      =================
      Bran_ID:integer(primarykey), Comm_ID:integer(foreign key), Comp_ID:integer,Compliance_status:BOOL

      has the relation to Comm table as tracked by

      Comm_table
      ==========
      Comm_ID:integer(primarykey),Comp_ID:integer(foreign key),Name varchar,AF varchar,

      has the relation to test table as validates

      Test_table
      ==========
      Test_ID:integer (primarykey), Comm_ID integer (foreign key), Description varchar


      comp_table
      ==========
      comp_id:integer (primary key),name varchar,owner varchar.

      has the relation belongsto comm_table.

      Any pointers or sample codes where can i get this information ie create,update,select queries with hibernate and Mysql in java.


      Thanks,
      Srins.