ObjectDB ObjectDB

Internal Website Search

61-70 of 200 resultsRefresh
86

InternalError on multiple AND and JOIN Query

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='areacode
86

Lazy Init / Eager / Join Fetch collection strategy ? What to choose ?

,join fetch seems to be the right choice. What about ObjectDb ? The implementation is totally different. Is an "All eager strategy" more efficient that many join fetch ( cartesian product + distinct ... all strategy" Or "Fetch Join strategy" for ObjectDb ? Regards, Xirt xirt Sylvain > Is an "All eager
86

Possible issue for JPQL "LEFT [OUTER] JOIN"

Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN". Thanks. eurojet P. F. Martinez ... A a LEFT OUTER JOIN a.listB b WHERE b IS NULL" where the output would be [A4, null] or even throw ... FROM A a LEFT OUTER JOIN a.listB b WHERE b.id IS NULL" but it works fine with an relationship
85

How to use JOIN FETCH?

JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c ... .   TypedQuery<Person> q = em.createQuery(         "select p from Person p join fetch p.addressHistory ... duplication then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT
85

Multiple joins did not return expected result

a specific calendar by its id like: SELECT event FROM Calendar c1, SharedCalendar c2 INNER JOIN c1.events AS event INNER JOIN c2.original.events AS event WHERE c1.id=?1 OR c2.id=?1 Unfortunately ... FROM Calendar c1, SharedCalendar c2 INNER JOIN c1.events AS event1 INNER JOIN c2.original.events
83

Join performance in Objectdb

fields in Page and Image are not annotated with @Id or @Index. In that case, executing the JOIN ... a JOIN on ID fields, similarly to your original query. The second query uses JOIN on direct
83

Join query problem with new statetment

when using query with join. The query code is: TypedQuery<InspirationsPerSupplierResult> inspirationQuery ... ) from Inspiration insp join insp.products p where (p.supplier = ?1 ... InspirationsPerSupplierResult(insp, p) from Inspiration insp join insp.products p where (p.supplier
17

javax.persistence.criteria.Subquery

root Since: JPA 2.0 Join<X,Y> correlate( Join<X,Y> parentJoin) Create a subquery join object correlated to a join object of the enclosing query. Create a subquery join object correlated to a join object of the enclosing query. Parameters: parentJoin - join object of the containing query Returns
16

Problem with JOIN and inheritance

.customer.VendorCustomer $1 JOIN $1.qubletFRAGMENTMAP $2, com.quasado.foundation.warehouse.contract ... I do select from "VendorCustomer" yet through using the join, he is also selecting all "Customer ... should not even join the $1.qubletFRAGMENTMAP of any other class but "VendorCustomer"!? thanks Alex quasado
16

Issue with full cross joins

hi, There seems to be an issue with full cross joins & maps. This query: SELECT  $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied  $1 LEFT JOIN $1.qubletFRAGMENTMAP $4 ... It seems that simple iteration on map values in JOIN has not been implemented and a map was handled as a collection

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