About bulk delete

manual

DELETE Queries in JPA/JPQL

Explains how to apply server side bulk delete using a JPA/JPQL query.... by calling the commit method. JPQL DELETE queries provide an alternative way for deleting entity ... which are used to retrieve data from the database, DELETE queries do not retrieve data from the database, but when executed, delete specified entity objects from the database. Removing entity ...

 
manual

UPDATE SET Queries in JPA/JPQL

Explains how to apply server side bulk update using a JPA/JPQL query.... Query's method Execute an update or delete statement. See JavaDoc Reference Page... method: ... Query's method Execute an update or delete statement. See JavaDoc Reference Page... ( ) ; ... Query's method Execute an update or delete statement. See JavaDoc Reference Page... ( ) ; ...

 
issue

Bulk load of eager mapped by (inverse) relationships

When a collection of objects is retrieved by ObjectDB (e.g. by a query) ordinary referenced objects and collection of objects that have to be loaded eagerly are loaded in bulk for better performance. However, inverse (mapped by) references that have to be loaded eagerly currently do not participate in a bulk load, which means that every reference requires running a separate query and doing a separate client-server round trip. Future versions of ObjectDB should load eager mapped by (inverse) fields in bulk as well. ... of objects that have to be loaded eagerly are loaded in bulk for better performance. However, inverse (mapped by) references ... edit delete support ...

 
forum_thread

Bulk Delete and Update - best practice?

The attached test creates 1000 large objects and then attempts to delete them all in one go using a DELETE statement. I'm trying to run with -Xmx512m but the test runs out of memory during the delete. The attachment also contains an update test which has similar memory problems. I'm running both tests with the default objectdb.conf. In general is an UPDATE/DELETE statement the most efficient way to update/remove a large number of objects? ... test creates 1000 large objects and then attempts to delete them all in one go using a DELETE statement. I'm trying to run with -Xmx512m but the test runs out of ...

 
issue

GC Memory

Hi there, I was hoping to get some support on ObjectDB regarding memory usage.  I received the following error.  Context for the error is found below. [2015-04-27 13:16:18 #20 server] ... com.objectdb.o.QRM.Vb(QRM.java:286) I am doing a bulk load for customer data.  The customer data is sharded over 16 ... edit delete kevinwh ...

 
forum_thread

How best to unbind all names?

My JDO application does inserts with binds, and then subsequently does bulk deletes using this code: ... does inserts with binds, and then subsequently does bulk deletes using this code: pm. currentTransaction ( ) ... of the above code, I could iterate over the Extent and delete the entities and the bindings one at a time, but this seems less ...

 
issue

Mapped by fields are not initialized by JOIN FETCH in queries

As demonstrated in this forum thread, a mapped by collection field with lazy fetch mode is not initialized in results of a query that uses JOIN FETCH on that collection field (when enhancement is used). ... edit delete support ... and the test in the forum passes), but still loading bulk of inverse fields requires performance improvement. ...

 
forum_thread

Pessimistic Lock Timeouts setting

Hi,   I realise that JPA2 doesn't necessarily define a standard API way for Lock Timeouts. However, there is a standardised query 'hint' that can be setup to make the underlying DB lock a record for a specific time. The hint property is: "javax.persistence.lock.timeout" ... clients from 1 company are accessing the same counter when bulk uploading products.   edit delete Willks ...

 
forum_thread

Server closes if large query runs out of memory

We are using ObjectDB in production, and have found what we thing to be a serious problem:  the objectdb server can run out of memory and stop if a query deals with too many objects. This isn't the behaviour we expected for a product that we want to use to deliver 24/7 high-volume data collection. ObjectDB surely has some idea of the sizes of objects that it persists and retrieves, and so should be able to fail safely if it finds too many objects being retrieved to fit into memory. There must be some alternative to crashing! ... edit delete sjzlondon ... smaller number of objects.  I understand that JPA bulk delete doesn't involve any object retrieval, whereas perhaps JDO ...

 
issue

NullPointerException when using multithreading

[ObjectDB 2.4.4_08] Unexpected exception (Error 990)   Generated by Java HotSpot(TM) Client VM 1.6.0_29 (on Windows 7 6.1). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: java.lang.NullPointerException: null java.lang.NullPointerException at com.objectdb.o.ENT.C(ENT.java:557) at com.objectdb.o.OBM.bz(OBM.java:385) at com.objectdb.o.OBM.bz(OBM.java:261) at com.objectdb.jpa.EMImpl.persist(EMImpl.java:377) at ... ... edit delete kevinwh ... instead of client server mode. Persisting bulk of objects every transaction (instead of a transaction per entity ...