2 Replies Latest reply on Mar 19, 2008 11:11 AM by Pete Muir

    Too many tables, MySQL

    Caye Newbie

      Hi,


      I have been facing this problem quite many times with one of my projects, the fact is that i couldnt solve it 100%. It  happens when i try to load an entity that is a list of entities.


      For example, these are my basic entities in tis problem.



      @Entity
      @Table(name="userproperties")
      @Scope(SESSION)
      public class UserProperty {
           @Id @GeneratedValue(strategy = GenerationType.AUTO)
           private Long id;
           private String name;
           private String info;
           private boolean critical;
           private boolean deadline;
           private String path;
           private Allowance allowance;
           
           @OneToOne
           private Userdata userdata;
           @OneToOne
           private UserdataExtended userdataExtended;
           
           *@ManyToOne
           private UserPropertyList propertyList;*
           
           @Lob @Basic(fetch = FetchType.LAZY)
           @Column(length = 15000000)
           private byte[] data = null;
           
           @Temporal(TemporalType.TIMESTAMP)
           private Date issuance;
           
           @Temporal(TemporalType.TIMESTAMP)
           private Date expire;
           
           public UserProperty() {}
           
           public UserProperty(String name,boolean critical) {
                this.name = name;
                this.critical = critical;
                deadline = false;
           }
           
           public UserProperty(String name,boolean critical,boolean deadline) {
                this.name = name;
                this.critical = critical;
                this.deadline = deadline;
           }
      getters and setters....




      And then the list of properties.



      @Entity
      @Table(name="userpropertiesList")
      @Scope(SESSION)
      public class UserPropertyList {
           @Id @GeneratedValue(strategy = GenerationType.AUTO)
           private Long id;
           private String name;
           private String info;
           private boolean critical;
           private boolean stored;
           private boolean deadline;
           private Allowance allowance;
           
           @OneToOne
           private Userdata userdata;
           
           @OneToOne
           private UserdataExtended userdataExtended;
           
           *@OneToMany(mappedBy="propertyList")
           private Collection<UserProperty> properties = new HashSet();*       
           
           public UserPropertyList() {}
           
           public UserPropertyList(String name,boolean critical) {
                this.name = name;
                this.critical = critical;
                this.stored = false;
                this.deadline = false;
           }
           
           public UserPropertyList(String name,boolean critical,boolean deadline) {
                this.name = name;
                this.critical = critical;
                this.stored = false;
                this.deadline = deadline;
           }
      getters and setters....



      So basically i have a userProperty and a userPropertyList that have the name of the list, the critical, allowance...etc and the list of properties. When i tried to load this is when it complains about too many tables in a join... My question is... there is some way to make the ManyToOne without try to load all the related class to the properties???


      I would like really to know this, because obviously i am doing something wrong in the whole structure.


      Thanks in advance!