Following are the tables with relationship


tbl_spot_media
___________________
spot_media_id
spot_id
cmedia_id
description
--------------------------
* Above table associates with cmedia_id with spot



tbl_spot_media_video_format
___________________
video_format_id
video_type
min_video_size
max_video_size
spot_media_id
description
--------------------------
* Above table contains multiple entry for video format associated with spot_media_id


tbl_spot_media_video_format
___________________
image_format_id
img_type
height
width
spot_media_id
description
--------------------------
* Above table contains multiple entry for video format associated with spot_media_id


I need to define a class like SpotMedia with

class SpotMedia {

//that returns values associated with spot media either of audio or video format
Set/List getMediaFormats()
{ }
}



class AudioFormat{}
class VedioFormat{}


Any suggestion on implementing above. I can create view/or any other intermediate class/table required.

First ,

if you use Eclipse IDE , you can install the Hibernate plugin and do a reverse engineer on the database .This will automatically create the POJOs and the mapping files for you .


http://www.hibernate.org/hib_docs/tools ... ugins.html


if this is not the case , let me see if i get it right :


you have two tables with the same name , so i'm going to try and map only the first and second table , the third should be the same thing :


you have a one to many relationship between tbp_spot_media -> tbl_spot_media_video_format with the foregin key column spot_media_id






and in the SpotMediaVideoFormat.hbm.xml you should have something like this :




hope it helps .
Victor[/code]