Home » Search

About fetch

31-40 of 200Refresh
Forum
18

LEFT JOIN FETCH over empty embedded collection returns no results

First of all, thank you for promptly implementing JOIN FETCH over nested paths in response ... , but I attempt to LEFT JOIN FETCH all the members of a collection within a (non-existent) member ... FETCH c.bList WHERE id=:id; But if I include the full nested fetch, it fails, returning an empty result
Forum
18

How to use JOIN FETCH?

JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c ... addresses (obviously fetched lazily), but still 2 results.  What should I be doing to get what I want out of this query? Note that I need to get the fetch mode specified in the query, not in
JPA Doc
18

javax.persistence.criteria.FetchParent

javax.persistence.criteria Interface FetchParent Subinterfaces: CollectionJoin, Fetch, From ... which may function as the parent of Fetches. Since: JPA 2.0 Fetch fetch(String attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join to the specified
Forum
17

Problem with @Basic(fetch = FetchType.LAZY)

I have a class where two fields are annotated with @Basic(fetch = FetchType.LAZY ... app). Yet they don't seem to be fetched lazily. This class should hopefully demonstrate the problem ... ; @Basic(fetch = FetchType.LAZY) private String description; @Basic(fetch = FetchType.LAZY
Forum
17

Fetching Collections Puzzle

If I dont declare explicitly the fetch strategy for "children" as FetchType.Eager, then how can I ... default JPA spec says that  colletions are to be lazy fetched. You can try this in a query.  "select n from Node n left outer join fetch n.children where ....." this will also fetch your collection
Forum
17

Query with FETCH JOIN returns multiple results instead of one.

jpqlResult = em.createQuery( "SELECT d FROM Demand d JOIN FETCH d.services WHERE d=:demand ... and fetch its services. Demand object is identified and found correctly, but as it is associated ... should return only one result, with fetched service sub-elements, shouldn't it? I am almost sure
Forum
17

Detaching objects after JOIN FETCH

Hi, I have a question about detaching objects after issuing query with JOIN FETCH. Let's say I ... { @OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL) List aClasses; } Now, I want to fetch all B classes with all A classes skipping lazy loading: select b from B b join fetch b
JPA Doc
17

javax.persistence.criteria.CollectionJoin

of the expression Returns: new expression of the given type Since: JPA 2.0 Fetch fetch(String attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join ... for the target of the join Returns: the resulting fetch join Throws: IllegalArgumentException - if attribute
JPA Doc
17

javax.persistence.criteria.From

Since: JPA 2.0 Fetch fetch(String attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join to the specified attribute using an inner join. Parameters: attributeName - name of the attribute for the target of the join Returns: the resulting fetch join Throws
JPA Doc
17

javax.persistence.criteria.Join

expression of the given type Since: JPA 2.0 Fetch fetch(String attributeName) Create a fetch join to the specified attribute using an inner join. Create a fetch join to the specified attribute using ... : the resulting fetch join Throws: IllegalArgumentException - if attribute of the given name does not