ObjectDB ObjectDB

Internal Website Search

11-20 of 76 resultsRefresh
27

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
15

FROM clause (JPQL / Criteria API)

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

JPA Criteria API Queries

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

JPA Query Structure (JPQL / Criteria)

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

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
13

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
9

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
9

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