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

3.0:

Hi,

My Db model is like

FLOW:
FLOW_ID PK
FLOW_NAME
TIMEOUT

PROMPT:
PROMPT_ID PK
PROMPT_NAME

PROMPT_INFO:
PROMPT_ID PK, FK
LANG_ID PK
PROMPT_FILE
PROMPT_TEXT


FLOW_PROMPT:
FLOW_ID PK, FK
PROMPT_ID PK, FK


Class Prompt {

int promptId
String promptName
Map<PromptInfo> info // where the keys are integer LANG_ID
}

Class PromptInfo {

String promptFile
String promptText
}

If I have to query the PROMPT and PROMFT_INFO tables based on the PROMPT_ID from FLOW_PROMPT which in turn is based on FLOW_ID,
on which class would I need to create the hbm mapping file and how would the query look.
The result of the query should be Set<Prompt>
I do not want to put the many-many mapping in the Flow class

Thanks
Sudhir