i have a exception when i try to fetch from the database.
I have three entities with a ManyToOne relation. One A -> Many B, One A -> C and One B -> Many D. I use the EAGER'Type. but i get exception. See below.
The first entity:
@Entity
@Table
public class A {
    @Id
    @Column(columnDefinition = "VARCHAR(50)", nullable = false)
    private String aId;
    @OneToMany(mappedBy = "a", targetEntity = B.class, fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    private List<B> b;
    @OneToMany(mappedBy = "a", targetEntity = C.class, cascade = CascadeType.ALL)
    private List<C> c;
The second one:
@Entity
@Table
public class B {
    @Id
    @Column(columnDefinition = "VARCHAR(50)", nullable = false)
    private String bId;
    @ManyToOne(targetEntity = A.class, cascade = CascadeType.ALL)
    @JoinColumn(name = "aId", referencedColumnName = "aId")
    private A a;
    @OneToMany(mappedBy = "b", targetEntity = D.class, fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    private List<D> d;
The last one:
@Entity
@Table
public class D {
    @Id
    @Column(columnDefinition = "VARCHAR(50)", nullable = false)
    private String dId;
    @ManyToOne(targetEntity = B.class, cascade = CascadeType.ALL)
    @JoinColumn(name = "bId", referencedColumnName = "bId",)
    private B b;
when i run the query, i got this execption:
Invocation of init method failed; nested exception is org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:956)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:747)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
    at org.springframework.context.annotation.AnnotationConfigApplicationContext.<init>(AnnotationConfigApplicationContext.java:84)
    at de.emo.cit.tuberlin.GetController.getUDDISLA(GetController.java:44)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
when i change the fetch'type to LAZY, i get this execption:
Caused by: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: B.d, could not initialize proxy - no Session
Any idea? Thanks ;-)
 
     
    