数据库是MYSQL5.0
报错代码:
16:25:21,915 WARN JDBCExceptionReporter:71 - SQL Error: 1452, SQLState: 23000
16:25:21,918 ERROR JDBCExceptionReporter:72 - Cannot add or update a child row: a foreign key constraint fails (`xa00053/t_discussion`, CONSTRAINT `FKE7807CD362B8682A` FOREIGN KEY (`threamid`) REFERENCES `t_postsale` (`id`))
16:25:21,946 WARN RequestProcessor:528 - Unhandled Exception thrown: class org.springframework.dao.DataIntegrityViolationException代码:
PostSale Model类
public class PostSale {
private int id;
private String threamname;
private String info;
private String createDate;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getThreamname() {
return threamname;
}
public void setThreamname(String threamname) {
this.threamname = threamname;
}
public String getCreateDate() {
return createDate;
}
public void setCreateDate(String createDate) {
this.createDate = createDate;
}
public String getInfo() {
return info;
}
public void setInfo(String info) {
this.info = info;
}
}
报错代码:
16:25:21,915 WARN JDBCExceptionReporter:71 - SQL Error: 1452, SQLState: 23000
16:25:21,918 ERROR JDBCExceptionReporter:72 - Cannot add or update a child row: a foreign key constraint fails (`xa00053/t_discussion`, CONSTRAINT `FKE7807CD362B8682A` FOREIGN KEY (`threamid`) REFERENCES `t_postsale` (`id`))
16:25:21,946 WARN RequestProcessor:528 - Unhandled Exception thrown: class org.springframework.dao.DataIntegrityViolationException代码:
PostSale Model类
public class PostSale {
private int id;
private String threamname;
private String info;
private String createDate;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getThreamname() {
return threamname;
}
public void setThreamname(String threamname) {
this.threamname = threamname;
}
public String getCreateDate() {
return createDate;
}
public void setCreateDate(String createDate) {
this.createDate = createDate;
}
public String getInfo() {
return info;
}
public void setInfo(String info) {
this.info = info;
}
}
解决方案 »
- FileNotFoundException
- ajax返回值
- 前辈们:怎么用dreamweaver开发struts的view层
- 求助:hibernate脏数据的问题,请高手解答
- 关于配置jforum的问题,请朋友们帮忙看看,谢谢!
- 关于设置 jboss-3.2.0_tomcat-4.1.24 连接数的问题,迫切希望高手指点。
- 数据库连接的时候问题
- 请问如何将IP地址定向到某个固定文件
- hibernate4.3需不需要搭建log4j的日志环境?
- RPCServiceClient调用webservice时Connection reset
- hibernate 一对一的问题
- 如何对excel进行增删改查到数据库中
private int id;
private String name;
private String info;
private String createDate;
private PostSale postSale; public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getName() {
return name;
} public void setName(String name) {
this.name = name;
} public String getInfo() {
return info;
} public void setInfo(String info) {
this.info = info;
} public String getCreateDate() {
return createDate;
} public void setCreateDate(String createDate) {
this.createDate = createDate;
} public PostSale getPostSale() {
return postSale;
} public void setPostSale(PostSale postSale) {
this.postSale = postSale;
}
}配置文件:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.xghj.model"> <class name="Discussion" table="t_discussion">
<id name="id">
<generator class="native" />
</id>
<property name="name" />
<property name="info" length="800" not-null="true" />
<property name="createDate" />
<many-to-one name="postSale" column="threamid" />
</class></hibernate-mapping>
你要插入或者更新的Discussion的threamid的值在postsale里不存在