ObjectDB ObjectDB

Internal Website Search

1-10 of 77 resultsRefresh
155

Problem with distinct select, order by and equivalent alias/attribute path

distinct s_location "             + "from Street s "             + "left join s.location as s_location ... ();                 q1 = "select distinct s.location "             + "from Street s ... , Location.class).getResultList();                 String q2 = "select distinct s.location
154

Multi selection and distinct in a criteria query

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) so that I could do something like criteria
148

Distinct Error

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: QUERY: SELECT DISTINCT $1 FROM
122

distinct(distinct)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery<T> distinct( boolean distinct ... to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified ... AbstractQuery method. Parameters: distinct - boolean value specifying whether duplicate results
122

distinct(distinct)

Method javax.persistence.criteria.Subquery Subquery<T> distinct( boolean distinct ) Specify ... . A false value will cause duplicates to be retained. If distinct has not been specified, duplicate ... method. Parameters: distinct - boolean value specifying whether duplicate results must be eliminated
122

distinct(distinct)

Method javax.persistence.criteria.AbstractQuery AbstractQuery<T> distinct( boolean distinct ... to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate
44

SELECT clause (JPQL / Criteria API)

and they consume less memory. SELECT DISTINCT Queries that use projection may return duplicate results ... 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 and SELECT DISTINCT
41

GROUP BY and HAVING clauses

to grouping by the GROUP BY clauses before arriving at the SELECT clause. GROUP BY as DISTINCT ... calculations - the GROUP BY functions merely as a DISTINCT operator. For example, the above query (which does not use aggregates) is equivalent to the following query: SELECT DISTINCT SUBSTRING(c
33

Issue with DISTINCT Select

It is getting more and more frustrating :( We've introduced distinct select instead of regular ... expression '$3' for distinct results at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.QNF.l ... distinct select so I doubt its an issue in our query. Here it goes: SELECT DISTINCT $1 FROM com.quasado
28

DISTINCT key causing internal exception on 2.6.4.b10

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.ttcn3' AND $2 ... since it's worked on prev ObjectDb releases, the problems not in '', just remove DISTINCT

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support