ObjectDB ObjectDB

Internal Website Search

11-20 of 77 resultsRefresh
143

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
16

FROM clause (JPQL / Criteria API)

,DELETE, DESC, DISTINCT, ELSE, EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE, FETCH,FROM, GROUP, HAVING, IN
16

JPA Query Structure (JPQL / Criteria)

on how to set criteria query clauses are provided as follows: Criteria SELECT (select, distinct
16

JPA Criteria API Queries

in the following page sections: SELECT clause (select, distinct, multiselect, array, tuple, construct
14

javax.persistence.criteria.Subquery

Subquery<T> distinct(boolean distinct) Specify whether duplicate query results will be eliminated ... 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
14

javax.persistence.criteria.CriteriaQuery

> distinct(boolean distinct) Specify whether duplicate query results will be eliminated. Specify ... . 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 results
10

javax.persistence.criteria.CriteriaBuilder

distinct operation. Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Returns: count distinct expression
10

javax.persistence.criteria.AbstractQuery

. Since: JPA 2.0 AbstractQuery<T> distinct(boolean distinct) Specify whether duplicate query results ... duplicates 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
8

countDistinct(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Long> countDistinct( Expression<?> x ) Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Returns: count distinct expression Since: JPA 2.0
4

combined index not used

: (version 2.7.6 it takes 47 ms, version 2.8.0_02 it takes 700 ms): SELECT DISTINCT o.parentNode FROM ... on executing this query what we never had before: SELECT DISTINCT o from ObjectNode o join o.properties p1 ... : how can we hint to go the direction it goes in 2.7.6 ?): SELECT DISTINCT o from ObjectNode o join o

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