About DISTINCT

41-50 of 67Refresh
Forum
2

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1 ... follows: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE (($1.id IN :cdiids
Forum
2

Updating Entities

the manual you linked) - objects within two separate EntityManagers are in fact distinct objects ... that contain a distinct Entity each: Employee and Paygrade. Paygrade must remain unique and in
Forum
2

IN expression in a Criteria Query

name="SELECT" code="132" postion="0:6">         DISTINCT COUNT($1) FROM Computer $1 WHERE (($1.workplace.id=:l1) AND $1.employeeEntity
Issue
2

ClassCastException in Tuple.get

.multiselect(joinDemand, rootDemandAnswer).distinct(true); cq.where( cb.equal ... (joinDemand.alias("d"), rootDemandAnswer.alias("a")).distinct(true); //... Demand demand = (Demand
Forum
1

"Problem" with cross join

At first, this is my first JPA Projekt - and the code should work with Hibernate and JPA, using the specifc DAOs. Following query string returns no result using ObjectDB - using Hibernate, or EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name like :SSTR or (c.id
Result
1

ObjectDB version 2.1.0

to NonTransactionalWrite enabled (issue #142). Fixed a bug in distinct queries (duplicates due to bad
Result
1

ObjectDB version 2.2.4

a bug in using JOIN FETCH with DISTINCT. Fixed Metamodel API's getTypeId method to support single ID field.
Result
1

ObjectDB version 2.2.7

Version 2.2.7 Added support of report generation using BIRT. Fixed a bug in query optimization of DISTINCT. Fixed a bug in keeping removed entity object in the L2 cache. Fixed orphan removal of owner entity object in bidirectional relationship. Fixed an "Attempt to persist a reference to a non
Result
1

ObjectDB version 2.3.7

issue #632 and issue #634). Fixed a bug in using JPQL operations (e.g. UPPER) in DISTINCT results
Forum
1

An InternalException occurs when gets an result list

query: select distinct m from ArchitectureImpl m with query option: query.setHint("objectdb.result