0 Replies Latest reply on Mar 11, 2008 6:22 AM by Sascha Hoffmann

    EntityBean with SecondaryTable

    Sascha Hoffmann Newbie

      I get an error-message from JBoss

      11:18:52,328 INFO [EntityBinder] Bind entity tcejb.LOV_Right on table LOV_USER_RIGHT
      11:18:52,328 INFO [EntityBinder] Adding secondary table to entity tcejb.LOV_Right -> LOV_RIGHT_TYP
      11:18:52,359 WARN [ServiceController] Problem starting service persistence.units:jar=LoginBean.jar,unitName=tcdb
      org.hibernate.AnnotationException: Cannot find the expected secondary table: no LOV_USER_RIGHT available for tcejb.LOV_Right
       at org.hibernate.cfg.Ejb3Column.getJoin(Ejb3Column.java:293)
      


      Why can't JBoss find the table? I have all Anotiations
      package tcejb;
      
      import javax.persistence.*;
      
      @Entity
      @NamedQueries({
       @NamedQuery(name="LOV_Right.findRight",
       query= "SELECT a FROM LOV_Right a " +
       "WHERE a.lov_urt_right_rule_sign = a.lov_rt_right_rule_sign " +
       "AND a.lov_urt_status_sign = 'A' " +
       "AND a.lov_urt_user = :name ")
      })
      @Table(name="LOV_USER_RIGHT")
       @SecondaryTable(name="LOV_RIGHT_TYP",
       pkJoinColumns={
       @PrimaryKeyJoinColumn(name="LOV_RT_RIGHT_RULE_SIGN")})
      public class LOV_Right implements java.io.Serializable {
      
       private static final long serialVersionUID = 1;
      
      
       private String lov_urt_user;
       private int lov_urt_right_rule_sign;
      
       private int lov_rt_right_rule_sign;
       private int lov_rt_right_class;
       private String lov_rt_right_read;
       private String lov_rt_right_confirm;
       private String lov_rt_right_update;
       private String lov_rt_right_new;
       private String lov_rt_right_excel_reason;
      
      
       @Id
       @Column(name="LOV_URT_USER", table="LOV_USER_RIGHT")
       public String getlov_urt_user() {return lov_urt_user;}
       public void setlov_urt_user(String lov_urt_user) {this.lov_urt_user = lov_urt_user;}
      
       @Id
       @Column(name="LOV_URT_RIGHT_RULE_SIGN", table="LOV_USER_RIGHT")
       public int getlov_urt_right_rule_sign() {return lov_urt_right_rule_sign;}
       public void setlov_urt_right_rule_sign(int lov_urt_right_rule_sign) {this.lov_urt_right_rule_sign = lov_urt_right_rule_sign;}
      
       @Id
       @Column(name="LOV_RT_RIGHT_RULE_SIGN", table="LOV_RIGHT_TYP")
       public int getlov_rt_right_rule_sign() {return lov_rt_right_rule_sign;}
       public void setlov_rt_right_rule_sign(int lov_rt_right_rule_sign) {this.lov_rt_right_rule_sign = lov_rt_right_rule_sign;}
      
       @Column(name="LOV_RIGHT_CLASS", table="LOV_RIGHT_TYP")
       public int getlov_rt_right_class() {return lov_rt_right_class;}
       public void setlov_rt_right_class(int right_class) {this.lov_rt_right_class = right_class;}
      
       @Column(name="LOV_RT_RIGHT_READ", table="LOV_RIGHT_TYP")
       public String getlov_rt_right_read() {return lov_rt_right_read;}
       public void setlov_rt_right_read(String right_read) {this.lov_rt_right_read = right_read;}
      
       @Column(name="LOV_RT_RIGHT_CONFIRM", table="LOV_RIGHT_TYP")
       public String getlov_rt_right_confirm() {return lov_rt_right_confirm;}
       public void setlov_rt_right_confirm(String right_confirm) {this.lov_rt_right_confirm = right_confirm;}
      
       @Column(name="LOV_RT_RIGHT_UPDATE", table = "LOV_RIGHT_TYP")
       public String getlov_rt_right_update() {return lov_rt_right_update;}
       public void setlov_rt_right_update(String right_update) {this.lov_rt_right_update = right_update;}
      
       @Column(name="LOV_RT_RIGHT_NEW", table="LOV_RIGHT_TYP")
       public String getlov_rt_right_new() {return lov_rt_right_new;}
       public void setlov_rt_right_new(String right_new) {this.lov_rt_right_new = right_new;}
      
       @Column(name="LOV_RT_RIGHT_EXCEL_REASON", table="LOV_RIGHT_TYP")
       public String getlov_rt_right_excel_reason() {return lov_rt_right_excel_reason;}
       public void setlov_rt_right_excel_reason(String right_excel_reason) {this.lov_rt_right_excel_reason = right_excel_reason;}
      
      
      }