Internal Website Search

;      .getModelElementsByQuery("select distinct m from " + PoolImpl.class

( issue #142 ). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a bug in

DISTINCT m FROM Person m LEFT OUTER JOIN m.answers answers LEFT OUTER JOIN answers.persons likedPersons

then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT . support Support

yet? support Support it is actually a simple query: select distinct m from ArchitectureImpl m

Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4.valueAsString='Los Angeles')) AND (($6.name

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

In earlier versions this query worked fine. In version 2.5.2_05 does not work .orderBy(cb.desc(cb.greatest(root.get("createDate").as(Date.class)))). distinct (true) Thank you for your help. galandor Orlov Sergey Please try build 2.5.2_06 that should fix this regression (of casting to Date ). support Support

(Unknown Source)   for that query: SELECT DISTINCT a from Action a WHERE a.objectsInCharge

distinct databases concurrently? If not and you only have one database, try to build

This is the message I get for attached db and this query: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE ((($1.qubletID=278) AND NOT (((com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment) $1.qubletFRAGMENTMAP.get('com

We have an issue with following query: SELECT DISTINCT instance, instanceEntryArtifactSet, artifact FROM com.btc.ep.engine.bl.internal.dmos.EngineInstanceImpl AS instance JOIN instance.artifacts AS instanceEntryArtifactSet , com.btc.ep.engine.bl.internal.dmos.ArtifactImpl AS artifact LEFT JOIN

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 managed instance

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

we have queries like (see the database that we handed over to you for other issues) select distinct o from ObjectNode o join o.properties p1 join o.properties p2 where o.classIdentifier = "(OP)" and (o.linkedObjects.classIdentifier = "(TC)" and  o.linkedObjects.objectNameUpper = "MILLING-EL

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

we face performance issues on queries and therefore compared the times of 2 (same) databases, 2.9.0_05, one after adding statistics and one after additional doctor, here are the results: Query : select distinct o from ObjectNode o where (o.classIdentifier = '(RG)' and o.properties.name

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

of the technology, because without any relationships there is no way of demonstrating the distinction

Added a new Doctor.run(srcPath, dstPath) static method. Added an option to exclude inherited @Id fields in embeddable classes. Added support for manual starting of online backup threads ( feature request #2855 ). Added support for  distinct mapped-by (inverse) fields. Improved query plan

Hello, Please run this query on the attached DB: SELECT DISTINCT $1 FROM com.quasado.serviceplaza.customer.VendorCustomer $1 JOIN $1.qubletFRAGMENTMAP $2, com.quasado.foundation.warehouse.contract.customer.CustomerContractsFragment $3 WHERE ((NOT (($2=$3) AND ($3.contracts IS EMPTY)))) The problem

Hi, Query: SELECT DISTINCT $1, UPPER($1.name) AS $O0, UPPER($2.lastName) AS $O1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 WHERE (($1.getClass().getName()='com.lexware.vereinsverwaltung.verein.api.model.mitglied.Mitglied')) ORDER BY $O0, $O1 -- Causes

; String queryString = "select DISTINCT (summary.store) from AbstractClientSummary summary WHERE summary

DISTINCT results. Fixed an exception in handling user defined serializable classes in the Explorer ( issue #647 ).

is expected to work (has not been tested): SELECT DISTINCT item FROM Item item JOIN item.labels label1 JOIN

) [objectdb-2.4.4_05.jar:] ... 1 more   With this query: SELECT COUNT( DISTINCT $1) FROM com

(             "SELECT DISTINCT b.a FROM B b