Home » Search

About DISTINCT

41-50 of 66Refresh
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
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
Issue
1

Critical error:: com.objectdb.o.InternalException: Unexpected internal exception with query

This is the query on the attached db (run in explorer): SELECT DISTINCT $1 FROM com.quasado.foundation.warehouse.payment.Payment $1 LEFT JOIN $1.receivable $2 WHERE (( ((($2 IS NOT NULL) AND ($2.receiver.qubletId=22))))) and this is the result: [ObjectDB 2.4.4] Unexpected exception (Error 990