Hibernate中insert出错inserted value too large for column
wooh 2005-02-05 11:10:39 数据库:
CREATE TABLE STAFF
(
MEMBER_ID VARCHAR(25) NOT NULL,
DEPARTMENT VARCHAR(25) NOT NULL,
NAME VARCHAR(25) NOT NULL,
SEX VARCHAR(2),
BIRTHDAY DATE,
DEGREE VARCHAR(25),
SPECIALTY VARCHAR(25),
SCHOOL VARCHAR(25),
TITLE VARCHAR(25),
POST VARCHAR(25),
SIGN VARCHAR(25),
CONSTRAINT PK_STAFF PRIMARY KEY (MEMBER_ID)
)
Staff.hbm.xml---------------------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<!-- Created Fri Jan 28 15:07:18 CST 2005 -->
<hibernate-mapping package="com.icbc.sdc.kf3.hibernate.humansource">
<class name="Staff" table="STAFF">
<id name="memberId" column="MEMBER_ID" type="java.lang.String">
<generator class="assigned"/>
</id>
<property name="department" column="DEPARTMENT" type="java.lang.String" not-null="true" />
<property name="name" column="NAME" type="java.lang.String" not-null="true" />
<property name="sex" column="SEX" type="java.lang.String" />
<property name="birthday" column="BIRTHDAY" type="java.util.Date" />
<property name="degree" column="DEGREE" type="java.lang.String" />
<property name="specialty" column="SPECIALTY" type="java.lang.String" />
<property name="school" column="SCHOOL" type="java.lang.String" />
<property name="title" column="TITLE" type="java.lang.String" />
<property name="post" column="POST" type="java.lang.String" />
<property name="sign" column="SIGN" type="java.lang.String" />
</class>
</hibernate-mapping>
StaffManager----------------------------------------------------------------------
public class StaffManager {
//更新或增加员工基本记录
public void saveMember(Staff memberValue) {
Session session=null;
Transaction tx=null;
try {
session=HibernateSessionFactory.currentSession();
tx=session.beginTransaction();
Staff member;
if (memberValue.getMemberId()!=null) {
//member=(Staff)session.get(Staff.class,memberValue.getMemberId());
System.out.println("............... READY...!!!!!!!!!!");
//session.update(memberValue);
session.saveOrUpdate(memberValue);
System.out.println("............... DONE...!!!!!!!!!!");
}
tx.commit();
} catch (HibernateException e) {
e.printStackTrace();
if (tx!=null) try {
tx.rollback();
} catch (HibernateException e1) {
e1.printStackTrace();
}
}finally {
try {
if(session!=null) HibernateSessionFactory.closeSession();
}catch(HibernateException e1) {
e1.printStackTrace();
}
}
}
---------------------------------------
已经校对过值了 没有错 但是会报错ORA-01401:inserted value too large for column