users@glassfish.java.net

selecting data using Embedded Entity

From: <glassfish_at_javadesktop.org>
Date: Thu, 10 Dec 2009 08:47:54 PST

Sorry, really new to JPA.

I have an Embedded ID class used as the primary key. How do I select data only using one of the fields in the key??

I have two fields in the EmployeePK: (emp_grp, hire_date). emp_grp and hire_date would be a unique record. I want to select all records with emp_grp.

I can do this: "select m from Employee m where m.id = 'id'"
But the id field is the EmployeePK class and I must also use the hire_date.

I want something like this: select m from Employee m where m.emp_grp = "emp_grp"
but the "m.emp_grp" field is not visible since its in the EmployeePK class.

Thanks
[Message sent by forum member 'larryl' ]

http://forums.java.net/jive/thread.jspa?messageID=375802