Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

HI All,
I have searched the forum but wasn't able to find close to my
requirements. I am a newbie to hibernate would greatly appreciate
if any inputs on how can i go about solving this issue

I have composite key based table to retrieve more like a tree
structure based entries



basically wanted insert values based on foreign key constraints
e.g categoryDetails can contain values only for the available categoryId
and subcatId available on parent tables

Also retrieve details by giving categoryId and subcategoryId

I would greatly appreciate if someone could give me some pointers/examples/tutorials
whether i should use composite key mappings or parent child relations
to achieve the above functionality.

PS:- All PK e.g categoryId, subcatId, catdetailId is generated by sequence
iam using hibernate version 3.1 and MySql 5

Thanks a lot

This forum should have lots of cases like that -- having extra columns on the association table. Just do a search for "extra columns association table".

Here are some pointers
http://www.hibernate.org/118.html#A10
or check out the hibernate doc at
http://www.hibernate.org/hib_docs/v3/re ... ollections