7 | InternalError on multiple AND and JOIN QueryHi, 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='areacode |
7 | Query in JPA2 with LEFT JOIN on INNER JOIN and actionprof8_.ID=7 and actionprof9_.ID=9 while my query is select distinct (a.description |
7 | How to convert a boolean to an int in the query? DISTINCT m FROM Person m LEFT OUTER JOIN m.answers answers LEFT OUTER JOIN answers.persons |
7 | InternalError on query of empty database, Query I'm running is: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.attributeList $2 JOIN $1 |
7 | "Problem" with cross joinAt 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 |
1 | Issue with UPPER ? may generate duplicates. The second query with a small change, COUNT(distinct $1), returns 100. support |
1 | ObjectDB 2.2.7Added 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 |
1 | Error reading UTF string (Serialized Objects in Explorer)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 |
1 | Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary.chain == :chain"; TypedQuery |
1 | DeadlockHi, 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 |
