EntityBean with SecondaryTable
ceene Mar 11, 2008 6:22 AMI 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;} }