The Error message is:-------------------------------------------------------------------
Hibernate: insert into TBL_S_USER_MASTER (PASSWORD, NAME, KANA) values (?, ?, ?)
WARN [Thread-5] (JDBCExceptionReporter.java:77) - SQL Error: 515, SQLState: 23000
ERROR [Thread-5] (JDBCExceptionReporter.java:78) - 値 NULL を列 'USERID'、テーブル 'Sandeep.dbo.TBL_S_USER_MASTER' に挿入しようとしましたが、この列は NULL を挿入できません。 INSERT は失敗します。-------------------------------------------------------------------
The japanese msg means -
This row cannot insert NULL though it tried to insert value NULL in row 'USERID' and table 'Sandeep.dbo.TBL_S_USER_MASTER'. INSERT fails. --------------------------------------
UserMaster class Hibernate Mapping
--------------------------------------
<hibernate-mapping auto-import="true" default-lazy="false" default-cascade="none" default-access="property">
<class name="entities.UserMaster" table="TBL_S_USER_MASTER" mutable="true" polymorphism="implicit" dynamic-update="true" dynamic-insert="true" select-before-update="false" optimistic-lock="version">
<id name="
userId" type="java.lang.String" column="USERID">
<generator class="native" />
</id>
<property name=
"pwd" type="java.lang.String" column="PASSWORD" not-null="true" length="8" unique="false" optimistic-lock="true" lazy="false" generated="never"/>
<property name="
name" type="java.lang.String" column="NAME" not-null="false" length="40" unique="false" optimistic-lock="true" lazy="false" generated="never"/>
<property name="
kana" type="java.lang.String" column="KANA" not-null="false" length="40" unique="false" optimistic-lock="true" lazy="false" generated="never"/>
<set name="
details" inverse="true" cascade="save-update">
<key column="userId"></key>
<one-to-many class="
entities.UserMasterDetails"/>
</set>
</class>
</hibernate-mapping>
-------------------------------------------------
UserMasterDetails class Hibernate mapping
-------------------------------------------------
<hibernate-mapping auto-import="true" default-lazy="false" default-cascade="none" default-access="property">
<class name="entities.UserMasterDetails" table="TBL_S_USER_MASTER_DETAILS" mutable="true" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" select-before-update="false" optimistic-lock="version">
<id name="mgmtId" type="int" column="MGMTID" unsaved-value="null">
<generator class="native"/>
</id>
<property name="userId" type="java.lang.String" column="USERID" not-null="true" length="8" unique="false" optimistic-lock="true" lazy="false" generated="never"/>
<property name="dob" type="java.util.Date" column="DOB" not-null="false" unique="false" optimistic-lock="true" lazy="false" generated="never"/>
<property name="committee" type="java.lang.String" column="COMMITTEE" not-null="false" length="40" unique="false" optimistic-lock="true" lazy="false" generated="never"/>
<many-to-one name="userMaster" class="entities.UserMaster" column="userId" not-null="true" update="false" insert="false"></many-to-one>
</class>
</hibernate-mapping>
and the
CODING is-
public boolean SaveorUpdateUser(UserMaster user, UserMasterDetails userDetails){
/* Retrieve Hibernate Session */
Session session = null;
try {
HibernateUtil.createSessionFactory();
session = HibernateUtil.getSession();
} catch (Exception ex) {
ex.printStackTrace();
}
try {
// Begin Hibernate Session
Transaction transaction = session.beginTransaction();
transaction.begin();
System.out.println(user.getUserId());
System.out.println(user.getPwd());
System.out.println(user.getName());
System.out.println(user.getKana());
String usId = null;
usId = user.getUserId();
user.setUserId(usId);
user.getDetails().add(userDetails);
//System.out.println("Session getidentifier:"+session.getIdentifier(user));
session.save(user);
transaction.commit();
transaction = session.beginTransaction();
userDetails.setMgmtId(1);
session.save(userDetails);
transaction.commit();
session.close();
}
catch(Exception e)
{
e.printStackTrace();
}
finally {
session.close();
}
return true;
}
#########################
I am very New to Hibernate and Struts both..
All i know is, I created classes and then mapped in hibernate, created associations between the classes.
Then i got the data from a FORM
I set the values to the class objects
and i simply Save the object instance using hibernate session...
Isnt this all?
WHAT MISTAKE have i made??
ANY HELP please??
#########################
Login
FAQ
Search