Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Selecting data using EmbeddedID(how to select data using a field in the EmbeddedID class)
Selecting data using EmbeddedID [message #503062] Thu, 10 December 2009 12:55 Go to next message
Larry  is currently offline Larry
Messages: 30
Registered: December 2009
Member
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
Re: Selecting data using EmbeddedID [message #503164 is a reply to message #503062] Thu, 10 December 2009 23:07 Go to previous message
Doug Clarke is currently offline Doug Clarke
Messages: 155
Registered: July 2009
Senior Member
You should simply navigate to the fielkds you want within the embedded id class:

select m from Employee m where m.id.emp_grp = "emp_grp"

Doug
Previous Topic:JPA NamedQuery Result
Next Topic:Exception while using static weaving
Goto Forum:
  


Current Time: Wed Jul 23 01:54:07 EDT 2014

Powered by FUDForum. Page generated in 0.01816 seconds