Re: [eclipselink-users] DeleteAllQuery selectionCriteria ignored?

["Andrei Ilitchev" <andrei.ilitchev@xxxxxxxxxx>]

Should be:

        ExpressionBuilder builder = query.getExpressionBuilder();
        _expression_ selectionCriteria = builder.anyOf("causedBy").get("referenceId").equal(entity.getObjectId());

----- Original Message -----

From: Magnus Heino

To: EclipseLink User Discussions

Sent: Thursday, January 15, 2009 10:00 AM

Subject: [eclipselink-users] DeleteAllQuery selectionCriteria ignored?

Hi.

Why does this code:

public void deleteEntityDefects(final ChangeObject entity) {
        DeleteAllQuery query = new DeleteAllQuery(Defect.class);
        ExpressionBuilder selectionCriteria = query.getExpressionBuilder();
        selectionCriteria.anyOf("causedBy").get("referenceId").equal(entity.getObjectId());
        query.setSelectionCriteria(selectionCriteria);
        query.setShouldDeferExecutionInUOW(false);
        this.entityManager.getActiveSession().executeQuery(query);
    }

produce this sql:

DELETE FROM DEFECT_REFERENCE WHERE EXISTS(SELECT ID FROM DEFECT WHERE ID = DEFECT_REFERENCE.Defect_ID)

DELETE FROM DEFECT

It seems as if the selectionCriteria is being ignored?

 /Magnus Heino

---

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users