87 words

Issue #11 - JPQL Update & Delete (JPA 1.0)

JPA FeatureVersion: Priority: HighStatus: FixedReplies: 3
#1
2010-05-14 11:16

JPQL (Java Persistence Query Language) supports updating and deleting database objects by queries.

Currently ObjectDB supports only JPQL SELECT (retrieval) queries.
Delete queries are supported for JDOQL (JDO Query Language).

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #12
#2
2011-04-30 07:35

spring-data-jpa uses delete queries to implement repository.deleteAll()

public static final String DELETE_ALL_QUERY_STRING = "delete from %s x";

 

chris
chris's picture
Joined on 2011-04-29
User Post #5
#3
2011-05-01 09:06

Interesting point.

At least the implementation of delete queries should be easy since ObjectDB already supports delete queries in JDO. Hopefully this could be added in one of the next builds.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #230
#4
2011-05-03 03:00

Implementation of both DELETE and UPDATE queries was added in build 2.2.3_03.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #232

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Attachments:
Maximum file size: 32 MB
Cancel