ObjectDB ObjectDB

Internal Website Search

1-10 of 76 resultsRefresh
147

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
145

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
140

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
136

ObjectDB internal error on 2.6.4.b10 for query with DISTINCT

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 ... Could you comment this? Raised issue: Issue #1176 - DISTINCT key causing internal exception on 2.6.4.b10
115

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
115

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
115

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
73

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
70

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
31

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

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