masato-san masato-san - 4 months ago 28
Java Question

How to write JPQL SELECT with embedded id?

I'm using Toplink essentials (JPA) + GlassFish v3 + NetBean 6.9

I have one table with composite primary key:

table (machine)
----------------
|PK machineId |
|PK workId |
| |
|______________|


I created 2 entity classes one for entity itself and second is PK class.

public class Machine {
@EmbeddedId
protected MachinePK machinePK;

//getter setters of fields..
}

public class MachinePK {
@Column(name = "machineId")
private String machineId;

@Column(name = "workId")
private String workId;

}


Now.. how do I write SELECT clause with JPQL with WHERE???

This fails.

SELECT m FROM Machine m WHERE m.machineId = 10


http://www.mail-archive.com/users@openjpa.apache.org/msg03073.html

According to the web page, add "val"? No it fails too.

SELECT m FROM Machine m WHERE m.machineId.val = 10


In both case, the error is:

Exception Description: Error compiling the query
[SELECT m FROM Machine m WHERE m.machineId.val = 10],
line 1, column 30: unknown state or association field
[MachineId] of class [entity.Machine].

Answer
SELECT m FROM Machine m WHERE m.machinePK.machineId = 10
Comments