ObjectDB ObjectDB

Internal Website Search

31-40 of 77 resultsRefresh

multiple LEFT JOINs do not work as expected

like this: SELECT DISTINCT $1 FROM Organisation $1 JOIN $1.attributeList $2 LEFT ... (             "SELECT DISTINCT n1 " +             "FROM Node n1 LEFT JOIN n1.parent n2 LEFT JOIN n2.parent n3 ... .createQuery( "SELECT DISTINCT n1 " + "FROM Node n1 LEFT JOIN n1.parent n2

Query with FETCH JOIN returns multiple results instead of one.

duplicates with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services WHERE d=:demand ... mentions that duplicates are not filtered unless DISTINCT is used, but many JPA providers do this (or

Issue with upper?

Hi, Query 1: SELECT DISTINCT $1, $2.lastName AS $O0 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 ORDER BY UPPER($2.lastName) Correctly returns all the different lastName's for each $1 Now the same but with upper SELECT DISTINCT $1, UPPER($2

IN expression in a Criteria Query

="0:6">         <token name="DISTINCT" code="94" postion="7:15" />         <token name="COUNT" code ... that this query: <queryRequest query="SELECT DISTINCT COUNT($1) FROM Computer $1 WHERE (($1.workplace.id

each 1-2 days objects on some objectdb level lock/block each other

distinct o from ObjectNode o join o.properties p1 join o.properties p2 where (o.classIdentifier ... = "startableState" and p2.doubleValue = 0))) select distinct o from ObjectNode o join o.properties p1 ... != 13) and (p1.name = 'plannedState' and p1.doubleValue > 0 ) select distinct o from ObjectNode o

InternalException when using MEMBER OF on a large list in a query

(); String propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid ... the following query don't works: "SELECT DISTINCT property.uid FROM CovPropImpl AS property ... , which should always be true, the query works "SELECT DISTINCT property.uid FROM CovPropImpl AS

Different behavior for casting and not casting

: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE $1 ... NO entities: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 ... is resolved: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1 ... COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER ... . Then I had to add another casting: SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact

queries more than 10 times slower using 2.8.1 versus 2.7.6

in 2.7.6 around 5-10 seconds takes in 2.8.1 around 150-200 seconds: SELECT DISTINCT o.parentNode FROM ... 2: "select distinct o from ObjectNode o join o.properties p1 join o.properties p2 join o.properties ... Support the query hint does not help, measures: version 2.8.1 query: select distinct o from ObjectNode o

Internal Exception during query execution

Most simple query one might think of: SELECT DISTINCT $1, UPPER($1.name) AS $O0 FROM com.quasado ... DISTINCT $1 FROM com.quasado.foundation.contact.Contact $1 Alex quasado Alexander Adam Yes

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