ObjectDB ObjectDB

Internal Website Search

71-80 of 200 resultsRefresh

How do I achieve a Deep Fetch using JOIN FETCH?

that I can express one level of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c.bList WHERE c.id=:id But when I attempt to take it to the 2nd level: SELECT c FROM C JOIN FETCH c.bList JOIN FETCH c.bList.aList WHERE c.id=:id I get an error along the lines of: Invalid fetch path

LazyInitialization / join fetch

descrica2_2_3_ from the User usuario0_ left outer join on area area1_ usuario0_.codigo_area = area1_.codigo left outer join on User usuario2_ usuario0_.codigo_chefe = usuario2_.codigo left outer join company empresa3_ on usuario2_.codigo_empresa = empresa3_.codigo left outer join on specialty especialid4

Issue with Casting / Joins

MyEntity(); entity.getEmbeddeds().put("test", new EmbeddedA); ... // Try to query using join From<MyEntity> from = criteria.from(MyEntity.class); MapJoin<?,?,?> join = from.joinMap("embeddeds"); Path<?> pathToEmbeddedAName = join.value().get("name") <-- fails with attribute "name" not found

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

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

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

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

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

Problem using "and" for joined entities and indexed fields

join p.children c where c.age = 42", Parent.class).getResultList().size());         System.out.println(em.createQuery("select from Parent p join p.children c where c.name = 'Foo'", Parent.class).getResultList().size());         System.out.println(em.createQuery("select from Parent p join p.children


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

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