[JDO-617] JDOQL : Bulk Update and Delete Operations

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: JDO 3.1
• Assignee: Craig L Russell
• Reporter: Eric SULTAN
• Created: 22/Nov/08 10:36
• Updated: 17/Feb/22 19:55
• Resolved: 31/Jul/15 16:46

Description

It would be usefull that the JDO Query Langage could do some UPDATE and DELETE on Persistent Object like this :

UPDATE [<candidate-class>] SET item1=<newValue>, item2=<newValue> [WHERE <filter>]

The new_value specified for an update operation must be compatible in type with the state-field to
which it is assigned.
Bulk Update must modify the value of the version column and refresh Level1 and Level2 cache.

DELETE FROM [<candidate-class>] [WHERE <filter>]
By default Bulk Delete is appy on the specified class and its subclasses and doesn't do cascade delete.
A keyword like CASCADE must be set if we want to does a cascade delete :
DELETE CASCADE FROM [<candidate-class>] [WHERE <filter>]

Issue Links

• relates to: JDO-652 Provision of a typesafe refactor-friendly query capability for JDOQL