Hibernate many-to-many ...with DetachedCriteria/ Criteria

[Jeevan Sunkersett]

Hi,

In our project we have a many-to-many relationship between 2 tables, so looked up many webpages explaning the how-to etc.

but none of the examples I found, used DetachedCriteria/ Criteria....all explained the nuances using HQL

In our project, the user is shown a search screen, with many fields (name, from-date, to-date and so on) and so we are using DetachedCriteria

but the hibernate generated query cannot be executed ...getting a ORA:00942 (table or view does not exist).

Could there be issue between detachedCriteria and its hibernate generated sql and Many-to-Many table mappings?

Any example that explains fetching data of many-to-many mapped tables and using hibernate criteria ?

~g1