About execute

api-jdo

close(queryResult)

Close a query result and release any resources associated with it.(Method of javax.jdo.Query)

 
forum_thread

Performance and memory usage of queries

Hello, we can't understand why the performance of queries is not the best and the execution requires so much memory. In the implementation of our UnitTests we have used "DELETE FROM Object" to delete the database. That did not work because we often get an "out of memory" exception. What's all done in the execution of queries? Why is so much memory is required, although from the application point of view, no object is loaded. #1 2015-03-10 09:22 Hello, we can't understand why the performance of queries is not the best and the execution requires ...

 
api-jpa

setLockMode(lockMode)

Set the lock mode type to be used for the query execution.(Method of javax.persistence.Query)

 
api-jdo

javax.jdo.JDODataStoreException

This class represents data store exceptions that can be retried.(Exception of JDO)

 
forum_thread

impossible to drop a table with 50 million objects

when trying to execute in explorer (max heap size 1GByte) delete from LogEntry l it comes up with a Java heap error after 20 minutes of executing. How to empty such a table ?     ... 05:49 when trying to execute in explorer (max heap size 1GByte) delete from LogEntry l ...

 
api-jpa

javax.persistence.QueryTimeoutException

Thrown by the persistence provider when a query times out and only the statement is rolled back.(Exception of JPA)

 
release

2.2.9

Release date: 2011-08-10 Download (5.15 MB) Binary:  objectdb-2.2.9.zip You should start by following a  tutorial or reading the manual ...

 
api-jdo

javax.jdo.JDOOptimisticVerificationException

This class represents optimistic verification failures.(Exception of JDO)

 
forum_thread

Optimistic locking: prevent version increment on entity collection attribute

Hello, I have an entity E with an attribute which is a collection of entities (one to many relationship) with an optimistic locking strategy supported by a version field. Is it possible to prevent the increment of the version of entity E when entities are added to or removed from the collection? Something like the equivalent of @OptimisticLock(excluded=true) in Hibernate? Thanks, Farid #1 2013-04-30 15:49 Hello, I have an entity E with an attribute which is a collection of entities (one to many relationship) ...

 
forum_thread

find repeated records by JPQL

Hi, I know a single command in MySQL can find repeated records: Select * from TTT t where id in (select id from TTT s group id having count(id)>1) I dont know how to do this using JPQL, but I use query from 430,000 records and put them into hashmap, finally it cost one hour and failed: ... You may try splitting the query into two queries - first execute the inner query and then use the result collection as a parameter ... may try splitting the query into two queries - first execute the inner query and then use the result collection as a parameter ...