Edit Question - KnowledgeHub

Title Body

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].

Tags (comma-separated) Cancel