Fetch strategies in hibernate and relation of fetchtype with fetchmode

up vote3down votefavorite 2

I have gone thru some of the links for hibernate fetch strategies on net.One brief and concise link i liked is http://www.mkyong.com/hibernate/hibernate-fetching-strategies-examples/. We have four type of fetch strategies. these are :- fetch-”join” = Disable the lazy loading, always load all the collections and entities. fetch-”select” (default) = Lazy load all the collections and entities. batch-size=”N” = Fetching up to ‘N’ collections or entities, Not record. fetch-”subselect” = Group its collection into a sub select statement. My first question which one of the above qualifies for eager or lazyloading fetch type? To raise my queries about hibernate fetch strategies the i am considering below code snippet in my Department class @OneToMany(mappedBy = "department", cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true) @Fetch(value = FetchMode.SELECT) @BatchSize(size = 10) private Set<EmployeeData> employees = new HashSet<EmployeeData>(); As per my understanding As soon as i mention fetchtype as eager, i am left only with join fetch strategy but when i mention as fetchtype as lazyloading, i have other three options i.e select,batch-size and subselect.Agreed? Now if i look at code snippet in one my legacy project , it mentioned fetch type as eager and fetch strategy as select which contracdicts each other. Right? Another query is i do not see batch-size option when i write FetchMode. and do control + space in eclipse though i see other three fetch strategies? java hibernate fetching-strategy share|improve this question asked Jan 23 '12 at 10:58 M Sach 4,185951113

add comment

1 Answer

activeoldestvotes

up vote8down voteaccepted

Hibernate collections have fetch type and fetch mode settings. Fetch type specifies when elements of collection are retrieved, and fetch mode specifies how Hibernate retrieves them. So, FetchMode.SELECT and FetchMode.SUBSELECT are legal with both FetchType.EAGER andFetchType.LAZY. The difference is that with FetchType.EAGER an additional select query is executed immediately, whereas with FetchType.LAZY it's executed after the first access to the collection. FetchMode.JOIN, however, doesn't make sense with FetchType.LAZY. Batch size is an additional optimization for FetchMode.SELECT, so that it should be configured by its own annotation (@BatchSize) and has nothing to do with FetchMode enumeration itself. See also: 21.1. Fetching strategies share|improve this answer edited Apr 22 at 12:46 Brad Cupit 2,26621731 answered Jan 23 '12 at 11:39 axtavt 109k11162234

Amazing and quick clarification –  M Sach Jan 23 '12 at 11:55 +1 Fantastic answer –  Brad Cupit Apr 22 at 16:43 add comment