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

 
issue

Issue with full cross joins

hi, There seems to be an issue with full cross joins & maps. This query: ... be an issue with full cross joins & maps. This query: SELECT $1 FROM com . lexware . vereinsverwaltung . ...

 
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

createQuery()

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

 
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 ... message.   If we try to ecexute a Query (in the second main method): TypedQuery<RenamedSuperClass> q ...

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

 
api-jpa

javax.persistence.criteria.CriteriaBuilder.SimpleCase

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