About bulk update

manual

UPDATE SET Queries in JPA/JPQL

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

 
manual

DELETE Queries in JPA/JPQL

Explains how to apply server side bulk delete using a JPA/JPQL query.... executeUpdate() Query's method Execute an update or delete statement. See JavaDoc Reference Page... method: ... executeUpdate() 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 ... to be loaded eagerly currently do not participate in a bulk load, which means that every reference requires running a separate query ... To post a reply and/or subscribe to update notifications - please login . ...

 
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? ... 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 ...

 
page

What is new in ObjectDB 2.0?

... files (terabytes). Reducing round trips in JDO bulk operations (e.g. refreshAll). JDO Enhancer supports enhancing 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 ... that only commit can release memory, not flush . So bulk load of data into the database should be done in smaller transaction (with ... To post a reply and/or subscribe to update notifications - please login . ...

 
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.   ... aggressive test) Exception is: Failed to update object com.x.y.z.ProductCodeTracking:1 - locked by another owner (error ...

 
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 ( ) ... To post a reply and/or subscribe to update notifications - please login . ...

 
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). ... and the test in the forum passes), but still loading bulk of inverse fields requires performance improvement. ... To post a reply and/or subscribe to update notifications - please login . ...

 
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! ... smaller number of objects.  I understand that JPA bulk delete doesn't involve any object retrieval, whereas perhaps JDO ... To post a reply and/or subscribe to update notifications - please login . ...