1 Reply Latest reply on Aug 26, 2011 8:51 AM by wolfgangknauf

    returned values are empty!

    aupres

      I coded 2 entity class and joined them with @ManyToOne annotation like below

       

      - Members.java

       

      @Entity
      @Table(name = "family")
      public class Members implements Serializable {
          @Id
          @Column(name = "EMP_ID")
          private String id ;

         

         @Column(name = "EMP_Passwd")
          private String passwd ;
         
          @Column(name = "EMP_Name")
          private String name ;

         

          @Column(name="EMP_Record")
          @OneToMany(fetch=FetchType.EAGER, mappedBy="member", cascade=CascadeType.ALL)
          private List<Records> record;

       

          ...getter and setter method...

       

         

          public List<Records> getRecord() {
             return record;
          }

       

          public void setRecord(List<Records> record) {
             this.record = record;
          }

      }

       

      - Records.java

      @Entity
      @Table(name = "info")
      public class Records implements Serializable {
         
         @Id
         @GeneratedValue(strategy=GenerationType.AUTO)
          @Column(name = "EMP_ID")
          private int i;
         
          @ManyToOne(fetch=FetchType.EAGER, cascade=CascadeType.ALL)
          @JoinColumn(name="EMP_Record")
          private Members member;

         

         @Column(name = "EMP_Bank_Account")
          private String account;

         

         @Column(name = "EMP_Hobby")
          private String hobby;

         

          @Column(name = "EMP_Phone")
          private int phone;

       

          ...getter and setter method..

      }

       

      EntityManager.persist is OK. Data were inserted well. But Members.getRecord() method is problem.

       

      In Bean class I coded to return value List<Records> like below

       

      @Stateless
      public class MappingTestBean implements IMappingTestPort {

          @PersistenceContext(unitName="MyFamily")
          EntityManager em;

       

          public List<Records> getFamilyMember(String name) {
              // TODO Auto-generated method stub
              Members m = (Members)em.find(Members.class, name); // EntityManager.find() works well
              System.out.println(m.toString()); // The method prints some value
              List<Records> records = m.getRecord(); // getRecord() return empty value
              System.out.println(records.toString());
       
              return records;

         }

      }

       

      in console

      Joined select is executed well.

      [STDOUT] Hibernate: select members0_.EMP_ID as EMP1_49_1_, members0_.EMP_Name as EMP2_49_1_, members0_.EMP_Passwd as EMP3_49_1_, record1_.EMP_Record as EMP5_3_, record1_.EMP_ID as EMP1_3_, record1_.EMP_ID as EMP1_50_0_, record1_.EMP_Bank_Account as EMP2_50_0_, record1_.EMP_Hobby as EMP3_50_0_, record1_.EMP_Record as EMP5_50_0_, record1_.EMP_Phone as EMP4_50_0_ from family members0_ left outer join info record1_ on members0_.EMP_ID=record1_.EMP_Record where members0_.EMP_ID=?

       

      But records value is empty nor null.

       

      I need your advice! Thanks in advance.

        • 1. Re: returned values are empty!
          wolfgangknauf

          Hi,

           

          your code seems OK to me.

           

          Did you check in database that the entries in "INFO" have valid data in their field "EMP_RECORD"? Did you execute the query against the database?

           

          Best regards

           

          Wolfgang