表article的sectorname 是表 sector(主键名也是sectorname)的外键
[color=red]Article.hbm.xml[/color]
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
name="Article"
table="ARTICLE"
>
false
name="Topic"
column="TOPIC"
type="string"
length="40"
>
<!--
name="Sectorname"
column="SECTORNAME"
type="string"
not-null="true"
length="40"
/> -->
name="sector"
column="sectorname
class="com.struts_learn.data.Sector"
/>
[color=red]代码:[/color]
Sector sector = new Sector();
sector.setSectorname("vu5");
sector.setCreateid("aaa");
sector.setCreatetime(new Date());
Article article = new Article();
article.setTopic("fadg5");
article.setSector(sector);
session.save(article);
tx.commit();
[color=red]log:[/color]Hibernate: insert into ARTICLE (SECTORNAME,TOPIC) values (?, ?)
报错:Caused by: java.sql.BatchUpdateException: ORA-01400: 无法将 NULL 插入 ("AB"."ARTICLE"."SECTORNAME")
<!-- <property
name="Sectorname"
column="SECTORNAME"
type="string"
not-null="true"
length="40"
/> -->
把mapping文件注释去掉
[color=red]代码: [/color]
Sector sector = new Sector();
sector.setSectorname("vu5");
sector.setCreateid("aaa");
sector.setCreatetime(new Date());
Article article = new Article();
article.setTopic("fadg5");
article.setSector(sector);
article.setSectorname("vu5");
session.save(article);
tx.commit();
[color=red]log:Hibernate:[/color] insert into ARTICLE (SECTORNAME, sectorname, TOPIC) values (?, ?, ?)
报错:Caused by: java.sql.BatchUpdateException: ORA-00957: 列名重复
搞半天没明白,到底哪配错了...