About jpql

forum_thread

How to query for list of lists ?

Hi, I have a problem with constructing query, that gets only embedded list of integers from Entity. Here's the example : Query query = em.createQuery("SELECT i.filterDescription FROM Inspiration i"); List<List<Integer>> result = query.getResultList(); where Inspiration is like this : ... w You cannot select a list, so this is an invalid JPQL query. SELECT s FROM PulseDataWareHouse w JOIN w . ...

 
release

2.2.2

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
forum_thread

Queries are slow on a large database

Hi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total number of entries Get 25 consecutive entries (i.e. 0-25) Get one specific entry On average each query needs 4 to 5 minutes to return a result. I have been adviced to use indexes but they are already used through the JDO Metadata file. For instance I use this class: ... 2014-05-29 18:47 In JPQL the count query is: SELECT COUNT ( m ) FROM ...

 
release

2.2.3

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
release

2.2.1

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
release

2.2.0

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
release

2.1.1

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
forum_thread

Package name for persisted entities

Hi, I have a question about package name and searching for entities. As for now we were using two different databases for two different parts of our system. But we want to make a 'common' model for both systems. After merging entities from two different projects, we get single jar with all entities. Unfortunately some of the names are the same for entities: - homplex.model.dbobject.Inspiration - pl.hplxtool.model.Inspiration ... dbobject .* and ObjectDB supports it also in JPQL queries. But this is per query - you cannot specify a preferred ...

 
forum_thread

Criteria query error: Unexpected query token

Using JPA2, I can save entities now in JBoss, and also fetch them uniquely by id. However, if I try to fetch it by getting back all instances (e.g. findAll, I get the following error:   ... with no SELECT may be valid in Hibernate HQL but not in JPQL and JPA Criteria API. ObjectDB Support ...

 
forum_thread

Object comparation never matches

Hi! I'm trying to compare 2 identical objects in SELECT with no success: @Embeddable public class PhoneNumber implements Serializable {     int countryCode;     long number;   Which is a part of Customer object: ... But what about: http://www.objectdb.com/java/jpa/query/jpql/comparison Section "Comparable Data Types" Comparison is ...