Internal Website Search

;  String q1 = "select distinct s_location "          ... ;     q1 = "select distinct s.location "         ... ;      String q2 = "select distinct s.location "     

hi, How can I realize multi selection with the criteria api concerning distinct? I.e. doing something like SELECT DISTINCT $1, $2 wouldn't work because I do only have something like criteria.multiselect(...) and nothing like builder.distinct(selection

Hi, I'm getting a NullPointerException thrown on using DISTINCT. The query works fine if I don't have distinct. However thats NOT a solution as the code generating the query is used for other queries, and some of them do need the distinct. Its only a simple query:

="Interface in javax.persistence.criteria">CriteriaQuery<T> distinct(  boolean distinct) Specify whether duplicate query results ... duplicates to be retained. If distinct has not been specified, duplicate results must be retained

javax.persistence.criteria">Subquery<T> distinct(  boolean distinctdistinct has not been specified, duplicate results must be retained. This method only overrides ... "> Parameters: distinct - boolean value specifying whether duplicate results

="Interface in javax.persistence.criteria">AbstractQuery<T> distinct(  boolean distinct) Specify whether duplicate query results ... duplicates to be retained. If distinct has not been specified, duplicate results must be retained.

), but they are more lightweight, they are built faster and they consume less memory. SELECT DISTINCT Queries ... can be eliminated easily in JPQL by using the DISTINCT keyword: SELECT DISTINCT c.currency FROM Country AS c WHERE c.name LIKE 'I%' The only difference between SELECT

-toc> GROUP BY as DISTINCT (no Aggregates) The following query groups all the countries ... . Actually, without aggregate calculations - the GROUP BY functions merely as a DISTINCT operator ... class="pre-query"> SELECT DISTINCT SUBSTRING(c.name, 1, 1) FROM Country c GROUP BY

It is getting more and more frustrating :( We've introduced distinct select instead of regular ... .UserException: Invalid order expression '$3' for distinct results at com.objectdb.o.MSG.d(MSG.java ... . support Support hi, Well, the query works perfect without using distinct select so I doubt

I observed that on new ObjectDb v.2.6.4.b10 query below causes internal exception SELECT DISTINCT $1 FROM Pa3DictionaryItem $2 JOIN $2.values $1 WHERE ($2.namespace == 'com.anritsu.pa3 ... , the problems not in '', just remove DISTINCT and you will see no problems with this query Second