File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Criteria Query with Composite Key Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Criteria Query with Composite Key Table" Watch "Criteria Query with Composite Key Table" New topic

Criteria Query with Composite Key Table

Phoenix Kilimba
Ranch Hand

Joined: Oct 10, 2006
Posts: 64
Dear Sirs et Madames,

I am stuck, and have been stuck on this issue for a little less than a week now, and I fear for my sanity if I do not get a solution soon. The situation is this, I have a table with a composite key. However I am interested in extracting all data from this table where just one of the keys match (group_id). The following is my mapping file (hibernate) looks thus

And lastly, this is an excerpt from, where am attempting to extract all rows which have a particular group_id:

I know am not doing it right as am getting no resultset whatsoever (no exceptions though).

Would anyone be able to save my follicles by helping me out here?
thanks in advance...

You are what you know
I agree. Here's the link:
subject: Criteria Query with Composite Key Table
It's not a secret anymore!