这是个什么错？求大神帮忙！！！

[啊哈前端]

org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.article.model.UserInfo.articlecontent#admin]

下面是两个实体类
import java.util.HashSet;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name = "UserInfo", schema = "scott")
public class UserInfo {
private String username;// varchar2(50) primary key, --用户名称
private String pasword;// varchar2(50) , --密码
private String email;// varchar2(50) not null,--电子邮箱
private String telepone;// varchar2(12),--电话
private int logintimes;// default(0),--登录次数
private String articIDs;// varchar2(1000)--文章编号
private Set<ArticleContent> articlecontent = new HashSet<ArticleContent>();

@Id
@GeneratedValue
public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPasword() {
return pasword;
}

public void setPasword(String pasword) {
this.pasword = pasword;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

public String getTelepone() {
return telepone;
}

public void setTelepone(String telepone) {
this.telepone = telepone;
}

public int getLogintimes() {
return logintimes;
}

public void setLogintimes(int logintimes) {
this.logintimes = logintimes;
}

public String getArticIDs() {
return articIDs;
}

public void setArticIDs(String articIDs) {
this.articIDs = articIDs;
}

@OneToMany(mappedBy = "userinfo", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
public Set<ArticleContent> getArticlecontent() {
return articlecontent;
}

public void setArticlecontent(Set<ArticleContent> articlecontent) {
this.articlecontent = articlecontent;
}

}





package com.article.model;

import java.util.HashSet;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name = "UserInfo", schema = "scott")
public class UserInfo {
private String username;// varchar2(50) primary key, --用户名称
private String pasword;// varchar2(50) , --密码
private String email;// varchar2(50) not null,--电子邮箱
private String telepone;// varchar2(12),--电话
private int logintimes;// default(0),--登录次数
private String articIDs;// varchar2(1000)--文章编号
private Set<ArticleContent> articlecontent = new HashSet<ArticleContent>();

@Id
@GeneratedValue
public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPasword() {
return pasword;
}

public void setPasword(String pasword) {
this.pasword = pasword;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

public String getTelepone() {
return telepone;
}

public void setTelepone(String telepone) {
this.telepone = telepone;
}

public int getLogintimes() {
return logintimes;
}

public void setLogintimes(int logintimes) {
this.logintimes = logintimes;
}

public String getArticIDs() {
return articIDs;
}

public void setArticIDs(String articIDs) {
this.articIDs = articIDs;
}

@OneToMany(mappedBy = "userinfo", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
public Set<ArticleContent> getArticlecontent() {
return articlecontent;
}

public void setArticlecontent(Set<ArticleContent> articlecontent) {
this.articlecontent = articlecontent;
}

}

这是action



import java.util.Iterator;
import java.util.Set;
import com.article.model.ArticleContent;
import com.article.model.UserInfo;
import com.article.service.ArticleSer;
import com.opensymphony.xwork2.ActionSupport;

public class ArticleQueryAction extends ActionSupport {

/**
*
*/
private static final long serialVersionUID = 1L;
private ArticleSer as = new ArticleSer();
private String username;
private String password;

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public String Query_Login() {

UserInfo ui = as.Search_Login(username, password);
if (ui == null) {
System.out.println("失败!");
return "fail";
} else {

System.out.println("成功！");
Set articlecontent= ui.getArticlecontent();
Iterator<ArticleContent> article=articlecontent.iterator();
while(article.hasNext()){
ArticleContent ac=article.next();
System.out.println(ac.getMaincontent());

}
as.Update_LoginTimes(ui);
return SUCCESS;
}
}

}
运行到
Iterator<ArticleContent> article=articlecontent.iterator();
这里就报错了
当我把one to many 的fetch改为eager也会报同样的错误！
org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.article.model.UserInfo.articlecontent#admin]

求大神帮忙！！！小弟感激不敬！！

[Mr_sqw]

你的多方ArticleContent是怎么配置的

[啊哈前端]

默认的，就写了个many to one

[Mr_sqw]

你应该把ArticleContent实体类贴出来吧，你都搞成UserInfo

[Mr_sqw]

没有配置@Manytoone的属性吗

[啊哈前端]

额额，搞错了，不好意思 package com.article.model; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.SequenceGenerator; import javax.persistence.Table; @Entity @Table(name = "ArticlesContent", schema = "scott") @SequenceGenerator(name = "artic_ID", sequenceName = "articID") public class ArticleContent { private Integer articID;// --文章编号() private String artictype;// not null, --文章类型() private String artictitle;// not null,--文章标题() private String maincontent;// not null,--主要内容 private String article;// not null,--文章内容 private String authorname;// 作者 private UserInfo userinfo; @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "artic_ID") public Integer getArticID() { return articID; } public void setArticID(Integer articID) { this.articID = articID; } public String getArtictype() { return artictype; } public void setArtictype(String artictype) { this.artictype = artictype; } public String getArtictitle() { return artictitle; } public void setArtictitle(String artictitle) { this.artictitle = artictitle; } public String getMaincontent() { return maincontent; } public void setMaincontent(String maincontent) { this.maincontent = maincontent; } public String getArticle() { return article; } public void setArticle(String article) { this.article = article; } public String getAuthorname() { return authorname; } public void setAuthorname(String authorname) { this.authorname = authorname; } @ManyToOne public UserInfo getUserinfo() { return userinfo; } public void setUserinfo(UserInfo userinfo) { this.userinfo = userinfo; } }

[啊哈前端]

恩恩，多的一方我是默认的属性

[Mr_sqw]

这坑定不行， 试试 @ManyToOne() @JoinColumn(name = "xxx") public UserInfo getUserinfo() { return userinfo; } xxx：ArticlesContent表的引用UserInfo的主键的外键列，是username吗，你自己检查一下吧

[啊哈前端]

恩恩，UserInfo的主键username是ArticlesContent的外键，对应的是ArticlesContent 的authorname

[啊哈前端]

我在数据库里已经建立了外键关系了，所以没有要joinColumn

[Mr_sqw]

你要在实体类ArticlesContent里指明啊

[啊哈前端]

加了joincolumn就会报这个错 %%%% Error Creating SessionFactory %%%% org.hibernate.MappingException: Repeated column in mapping for entity: com.article.model.ArticleContent column: authorname (should be mapped with insert="false" update="false")

[Mr_sqw]

@JoinColumn(name = "authorname")

[啊哈前端]

嗯嗯，我是这么写的，就是报org.hibernate.MappingException: Repeated column in mapping for entity: com.article.model.ArticleContent column: authorname (should be mapped with insert="false" update="false")

[Mr_sqw]

@JoinColumn(name = "authorname",insertable=false,updatable=false)，

[Mr_sqw]

错误不是很明显了吗

[啊哈前端]

额，可以了，多谢啊！！