About batch

manual

Storing JPA Entity Objects

Explains how to use JPA to store (persist) entity objects in the database.... Global Cascading Persist Batch Store Explicit Persist The following code ... unit definition (in persistence.xml ). Batch Store Storing a large number of entity objects requires special ...

 
forum_thread

Insertion Speed Rate and Batch Load

1. I got about 10K inserts / second, is it normal? I would expect more than that, like close to 100K/second. I can definitely do 80K inserts/seconds on Oracle with batch insert on table with one primary key. 2. Is batch update/insert operation supported? I attached the files. ... I can definitely do 80K inserts/seconds on Oracle with batch insert on table with one primary key. 2. Is batch update/insert operation supported? I attached the files. ...

 
forum_thread

Significant I/O costs during batch update or insert data.

Our application has some complex entities. We do batch update(merge detached entity) every 2 minutes. We find the period significant IO costs these days, and disappeared when turn off the batch updating. 1.ObjectDB is in embedded mode. 2.ObjectDB version is 2.3.7 3.Database file size is nearly 600mb and increasing. ... Our application has some complex entities. We do batch update(merge detached entity) every 2 minutes. We find the period ... IO costs these days, and disappeared when turn off the batch updating. 1.ObjectDB is in embedded mode. 2.ObjectDB ...

 
forum_thread

ODB IndexActivation NullPointerException

Hi, We have created indexes on an existing database, which has 4.3 million objects. As soon we create first query, NullPointerException is thrown: ... java.lang.Thread.run(Thread.java:745) * Batch ended at 88 I've read that: "Indexing large amount of data ... 1) sometimes the following System out: * Batch ended at '2LG' * Batch ended at '2LG' * Batch ended at '2LG' * Batch ended at ...

 
issue

NullPointer on query

I'm getting a null pointer when running the following code: TypedQuery<ObjectDbMessagePayload> query = em.createQuery("SELECT m FROM ObjectDbMessagePayload m WHERE m.id = :id", ObjectDbMessagePayload.class); query.setParameter("id", msg.getId()); List<ObjectDbMessagePayload> loaded = query.getResultList(); Stack trace follows: ... within the application but only towards the end of a 6hr batch! Its odd as this is one of our "queue" database and many similar message ... but will post a cut-down test as soon as I can. The same batch did not produce the error in versions earlier than 2.3.5_05 but I dont ...

 
issue

NullPointer when accessing entity field

Hello, following exception occurs when using objectdb: ... in transaction and close the EntityManager for batch operations we use ThreadLocal for storing EntityManagers:  - ... not exists), do the operations using EM in ThreadLocal, on batch end we commit transaction,delete from ThreadLocal and close EM ...

 
forum_thread

Client server mode no longer works after JRE install

Hi I had client server mode working with no problems with my application. Then suddenly I was getting the following error "Error: missing 'server' at 'C:\Program Files\Java\jre7\bin\server\jvm.dll' on a client machine. It worked in embedded mode but not client server mode. ... So this can only be done from the command line or batch file? The conf file cannot be used to state which jvm is being used? ... Hi. I fumbled around with batch files and now think I have it working ok. Thanks for the help. ...

 
issue

Use temporary files to enable very large transactions

We have transactions in which many objects are created. These objects are no longer needed in the current transaction after creation. Unfortunately, we will receive an OutOfMemory exception because the objects are kept in the first level cache of ObjectDB. In the forum thread http://www.objectdb.com/database/forum/921 on post #4 you wrote, that ObjectDB should support very large transactions in further version. Can you implement it that ObjectDB used temporary files? ... Can we assume single user mode (i.e. batch background load) or do you need multi threading support? ...     Can we assume single user mode (i.e. batch background load) or do you need multi threading 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? #1 2011-11-20 12:23 The attached test creates 1000 large objects and then attempts to delete them all in one go using a DELETE statem ...

 
forum_thread

Feature Request: Improved ObjectDB Explorer

ObjectDB explorer is mainly designed as database viewer, not editor. However, I think it can be improved to function as a capable editor also, and I think this will make ObjectDB an even better product. ... in, for instance, MySQL workbench. We can write methods to batch the process, but this becomes annoying if we need to frequently, manually ...