[jboss-user] [EJB 3.0] - EntityBean with SecondaryTable

[Ceene]

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;}
  | 	
  | 	
  | }
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135563#4135563

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4135563