Eclipse Community Forums: EclipseLink » Selecting data using EmbeddedID

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

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 10:37:27 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter