`
jhyimu2005
  • 浏览: 181874 次
  • 性别: Icon_minigender_2
  • 来自: 苏州
社区版块
存档分类
最新评论

AnnotationException: Cannot find the expected secondary table

阅读更多
今天遇到一个比较奇怪的问题就是表明明就存在,却总是抛出异常说表不存在,其异常代码如下:
Caused by: org.hibernate.AnnotationException: Cannot find the expected secondary table: no bio_experiment_protocol available for com.founder.cims.bio.model.Protocol
	at org.hibernate.cfg.Ejb3Column.getJoin(Ejb3Column.java:293)
	at org.hibernate.cfg.Ejb3Column.getTable(Ejb3Column.java:272)
	at org.hibernate.cfg.AnnotationBinder.bindManyToOne(AnnotationBinder.java:1946)
	at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:1368)
	at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:754)
	at org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(AnnotationConfiguration.java:534)
	at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:286)
	at org.hibernate.cfg.Configuration.buildMappings(Configuration.java:1148)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:673)
	at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
	... 59 more



在项目中我用的一对多的双向关联,并且用的是中间表来进行两个表关联的。其关联关系如下:
@Entity
@Table(name = "BIO_NOTEBOOK")
@SequenceGenerator(name = "BIO_NOTEBOOK_SQ", sequenceName = "BIO_NOTEBOOK_SQ",
		allocationSize = 1, initialValue = 1)
public class Notebook implements Serializable{
	
	private static final long serialVersionUID = 7346303079987267177L;
	
	private Integer id;
	private String name;
	private String description;
	private int staus;
	private String author;
	
	
	private Experiment experiment;

        @ManyToOne(fetch = FetchType.LAZY, targetEntity = Experiment.class)
	@JoinTable(name = "BIO_EXPERIMENT_NOTEBOOK",
			joinColumns = {@JoinColumn(name = "NOTEBOOK_ID")},
			inverseJoinColumns = {@JoinColumn(name = "EXPERIMENT_ID")}
			)
        public Experiment getExperiment() {
		return experiment;
	}

	public void setExperiment(Experiment experiment) {
		this.experiment = experiment;
	}

一对多的那端
@Entity
@Table(name = "BIO_EXPERIMENT")
@SequenceGenerator(name = "BIO_EXPERIMENT_SQ", sequenceName = "BIO_EXPERIMENT_SQ", allocationSize = 1, initialValue = 1)
public class Experiment implements Serializable{
	
	private static final long serialVersionUID = 1315584437277200383L;
	
	private Integer id;
	private Study study;
	private String type;
	private Integer status;
	private InVivoExperiment invivoExperiment;
	private InVitroExperiment invitroExperiment;
	private DmpkExperiment dmpkExperiment;
	
	private Set<Notebook> notebooks;

        @OneToMany(mappedBy = "experiment")
	public Set<Notebook> getNotebooks() {
		return notebooks;
	}

	public void setNotebooks(Set<Notebook> notebooks) {
		this.notebooks = notebooks;
	}


当我把注解写到变量声明的上面就正确了即:
@Entity
@Table(name = "BIO_NOTEBOOK")
@SequenceGenerator(name = "BIO_NOTEBOOK_SQ", sequenceName = "BIO_NOTEBOOK_SQ",
		allocationSize = 1, initialValue = 1)
public class Notebook implements Serializable{
	
	private static final long serialVersionUID = 7346303079987267177L;
	
	private Integer id;
	private String name;
	private String description;
	private int staus;
	private String author;
	
	@ManyToOne(fetch = FetchType.LAZY, targetEntity = Experiment.class)
	@JoinTable(name = "BIO_EXPERIMENT_NOTEBOOK",
			joinColumns = {@JoinColumn(name = "NOTEBOOK_ID")},
			inverseJoinColumns = {@JoinColumn(name = "EXPERIMENT_ID")}
			)
	private Experiment experiment;

        public Experiment getExperiment() {
		return experiment;
	}

	public void setExperiment(Experiment experiment) {
		this.experiment = experiment;
	}

目前我也不知道是什么原因,有哪位知道的话可以给留言呀,期待中,谢谢!
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics