今天遇到一个比较奇怪的问题就是表明明就存在,却总是抛出异常说表不存在,其异常代码如下:
在项目中我用的一对多的双向关联,并且用的是中间表来进行两个表关联的。其关联关系如下:
一对多的那端
当我把注解写到变量声明的上面就正确了即:
目前我也不知道是什么原因,有哪位知道的话可以给留言呀,期待中,谢谢!
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;
}
目前我也不知道是什么原因,有哪位知道的话可以给留言呀,期待中,谢谢!