Fast Object Database for Java - with JPA/JDO support

Issue #2562: selective update not working

Type: DocumentationVersion: 2.7.5_05Priority: HighStatus: ClosedReplies: 1

we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error:


UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and  o.state = 0 and o.type = 1 and o.parentNode.classIdentifier = '(NC)'

This query includes an implicit JOIN (o.parentNode.classIdentifier), which is not allowed in UPDATE queries. See this stackoverflow thread for a more detailed explanation.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

Post Reply