Is it possible to reference Object children to any depth:
The query below fails with exception:
Code:
ca.edbc.util.EdbcEx: line 1, Syntax error on ','. The correct syntax is:
UPDATE table
[FROM table {, ... }]
SET column = expression|NULL {, ... }
[WHERE search_condition]
This is the Query:
Code:
String hqlUpdate = "update CaseStage caseStage set caseStage.stageEnd=:stageEndValue where caseStage.stageType.finalStage=:finalStage";
Query query = createQuery(hqlUpdate);
query.setDate("stageEndValue", assignedDate);
query.setLong("caseId", caseKey);
query.setBoolean("finalStage", true);
return query.executeUpdate();
I think it is the addition of the stageType.finalStage which is a Boolean, I have tried various things, is this a valid query.
Login
FAQ
Search