Home » Search

About fetch

31-40 of 200Refresh
Forum
20

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
19

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
Forum
19

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
19

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
19

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
18

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
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
18

@OneToMany(fetch = FetchType.LAZY) list is always null

Hello. @OneToMany(fetch = FetchType.LAZY) doesn't work when using EJB or something else related ... ") private int id; @OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL) private List ... ; } // getters and setters } public class Parent { // ...id @OneToOne(fetch
Forum
18

Eager Fetch is not stable for collection or map types?

types is not stable, we lost them sometimes after JVM restarted. Eager fetch is properly set ... and fetch is: @Entity public class Game {     .......     @ElementCollection(fetch=FetchType ... .size() > 0) { Game g = result.get(0); logger.debug("[trace_fetch] ["+g.getMembers
Forum
18

Mapped By Fetch is very Slow

, go the MyEntity class and remove "mapped-by". You obtain 1 second max of query fetch. So my performance issue ... ) {    System.out.println("FAILED TO FETCH !");   } } Regards,  Xirt Thank you for this report ... if this query. Using the Enhancer can improve performance. Support, When you fetch 10 000 entities