About named queries

api-jpa

setParameter(name, value, temporalType)

Bind an instance of java.util.Calendar to a named parameter.(Method of javax.persistence.Query)

 
issue

Error 990 when querying a class with persistence-capable-superclass

[ObjectDB 2.4.7_07] Unexpected exception (Error 990) Generated by Java HotSpot(TM) Server VM 1.7.0_10 (on Linux 3.2.0-39-generic-pae). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.InternalException.f(InternalException.java:236) at com.objectdb.o.STA.K(STA.java:339) at com.objectdb.o.ENT.D(ENT.java:533) at com.objectdb.o.ENT.M(ENT.java:681) at com.objectdb.o.LDR.F(LDR.java:589) at com.objectdb.o.LDR.E(LDR.java:466) ... query. execute ( ) ; All queries (eg ones with parameters) on the same class fail with the same error. ...

 
forum_thread

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java) takes about 10sec. I am using a recent MacBook (SSD blabla - disk I/O speed is about 400MB/sec - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146/400 = 0.35sec.. + some overhead). I was wondering if this kind of speed is "normal", or if this is something I should investigate. Thanks EKK ... the data from the disk. Using embedded objects or report queries (which return fields rather than entity objects) may help. If ... the data without the entity objects using "report queries" ( using projection ). Of course, you will lose much of the ...

 
api-jpa

javax.persistence.criteria.CollectionJoin

The CollectionJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.Collection.(Interface of JPA)

 
api-jpa

getParameter(name, type)

Get the parameter object corresponding to the declared parameter of the given name and type.(Method of javax.persistence.Query)

 
api-jpa

javax.persistence.criteria.SetJoin

The SetJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.Set.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.Root

A root type in the from clause.(Interface of JPA)

 
forum_thread

JPQL query to get entities that does not have a child entity in their child entities

I have 2 tables as shown below. Job Table ID JobId Name StartTime    FinishTime    .... 01 001   A  2105:12:10 14:00:00  2105:12:10 14:00:10 02    002  A  2105:12:10 14:00:00  2105:12:10 14:00:00 03    003  A  2105:12:10 14:00:00  2105:12:10 14:00:00 04    004  A  2105:12:10 14:00:00  2105:12:10 14:00:00 And ... using TomEE for deployment. I am using following queries. < strong > FINISHED </ strong > Jobs ... <> 'Finished' " ), With these queries I am getting wrong result for ACTIVE Jobs. A job even with failed or ...

 
forum_thread

Unexpected COUNT Results

We are working with objectDB version 2.5.5.b01. (we also tried to use the latest version 2.6.1) We have several issues with queries that can be seen with the attached database and using ObjectDB explorer: 1.       Using ObjectDB explorer... latest version 2.6.1) We have several issues with queries that can be seen with the attached database and using ObjectDB ...

 
api-jpa

javax.persistence.criteria.PluralJoin

The PluralJoin interface defines functionality that is common to joins to all collection types.(Interface of JPA)