This discussion is archived
1 Reply Latest reply: Jan 11, 2007 10:48 PM by 843844 RSS

How to create relationships within tables using hibernate/mysql

843844 Newbie
Currently Being Moderated
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.