About @Query

forum_thread

Memory leak

Hi, We have a memory leak in our application which seems to be related with ObjectDB. Basically, we use single instance of EntityManager, which is opened on aplication initialization and closed when the user logs out, as well as EntityManagerFactory. We use em.clear() after every commit and after execution of query. Our classes are enhanced with ObjectDB enhancer. However, used memory is growing overtime until OutOfMemoryException is thrown on JBoss server. We use JBoss 7.1.1. and latest ObjectDB version. #1 2014-03-22 20:31 Hi, We have a memory leak in our application which seems to be related with ObjectDB. Basically, ...

 
issue

Index Rebuilder

When a new index is added to an existing entity classes that already has instances in the database, it cannot be used in queries, because it starts empty and it is not synchronized with the existing primary data. The Index Rebuilder tool will enable rebuilding indexes, synchronizing their data to the primary data. As a workaround, you can currently use the ObjectDB Doctor to build a new database file, in which such new indexes will be enabled. Feature Request Version: 1.04 Priority: Normal Status: Fixed Replies: 1 Type:  Feature Request ...

 
forum_thread

Selecting random rows

Hello is there way to get random rows? Functions line rand(), random(), newid() doesn't work ;/ for example: em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception: #1 2014-06-21 09:47 Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for e ...

 
issue

Issue with full cross joins

hi, There seems to be an issue with full cross joins & maps. This query: Bug Version: Priority: Normal Status: Fixed Replies: 1 Type:  Bug ...

 
forum_thread

persists and update together ?

hello on mysql i've seen;   INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6) ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b);   This query , inserts data or updates if its already available and this will reduce finding same object again. On jpa : User obj2 = ...; #1 2012-07-17 15:03 hello on mysql i've seen;   INSERT INTO TABLE ( a , b , c ) ...

 
api-jpa

getFetches()

Return the fetch joins that have been made from this type.(Method of javax.persistence.criteria.FetchParent)

 
api-jpa

subquery(type)

Create a subquery of the query.(Method of javax.persistence.criteria.AbstractQuery)

 
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 ?     #1 2017-06-28 05:49 when trying to execute in explorer (max heap size 1GByte) delete from LogEntry l it comes up with ...

 
forum_thread

Schema-Update: Rename superclass and remove one subclass

Hello, we renamed a superclass and removed one of the subclass. If we then try to open the Database (with ObjectDB-Explorer) we get a "Failed to generate dynamic type ..."   Small Example: Generate Database #1 2016-11-14 09:07 Hello, we renamed a superclass and removed one of the subclass. If we then try to open the Databa ...

 
api-jpa

javax.persistence.criteria.CriteriaBuilder.SimpleCase

Interface used to build simple case expressions.(Interface of JPA)