About query

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

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 = ...; ... VALUES ( b ) ;   This query , inserts data or updates if its already available and this will reduce ...

 
issue

NPE using AND TRUE in WHERE clause

The following (dynamically generated) query causes an NPE: SELECT e FROM Event e WHERE e.account=:account AND TRUE When I change it to a trivial term which evaluates to true, it works fine: SELECT e FROM Event e WHERE e.account=:account AND 1=1 Here is the stack trace: ... The following (dynamically generated) query causes an NPE: SELECT e FROM Event e WHERE e . ...

 
api-jpa

get(alias, type)

Get the value of the tuple element to which the specified alias has been assigned.(Method of javax.persistence.Tuple)

 
api-jpa

distinct(distinct)

Specify whether duplicate query results will be eliminated.(Method of javax.persistence.criteria.Subquery)

 
api-jpa

createQuery()

Create a CriteriaQuery object.(Method of javax.persistence.criteria.CriteriaBuilder)

 
api-jdo

Constants.JDOQUERY_DTD_RESOURCE

The name of the resource for the DTD of the standard JDO query metadata file.(Static Field of javax.jdo.Constants)

 
issue

probable error in text of manual about embeddable classes

at http://www.objectdb.com/java/jpa/entity/types website in "Embeddable Classes" section there is a phrase "e.g. their instances cannot be shared by different entity objects" which seems to be wrong. Bug Version: 1.04 Priority: Normal Status: Closed Replies: 1 Type:  Bug ...

 
forum_thread

Does aggregate function "greatest" work on entity objects?

do not come to the function "compareTo" @Entity public class ChatHistoryItem extends AbstractObject implements Comparable {     private static final long serialVersionUID = 1L; #1 2013-08-01 11:39 Does aggregate function "greatest" work on entity objects? do not come to the function "compareTo" ...

 
forum_thread

Failing to read entities under load in multithreaded tests

Hi, We are experiencing an issue in our application that only occurs under load - we sometimes fail to read entities from the database. ... them from the DB with "No matching results for a unique query" error. The error occurs in 2-3% of iterations. When I run the same ...