one to one mapping in hibernate..exception while saving.

[vani venkat]

I have one to one relation between user and candidate. ideally user is used for authentication purposes and candidate holds all other information. i defined many to one relation in candidate hm file. when i try to save candidate bean, it gives lock wait time out exception. can some one point out what the problem is. i searched and could not get good infromation of solution for this.

Here are the hbm files.
User.hbm.xml

<?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="beans">
    
    <class name="User" table="CSS_User">
        <id name="id" column="userSeq">
            <generator class="native"/>
        </id>

       <property name="userId"/>
       <property name="password"/>
       <property name="firstName"/>
       <property name="lastName"/>
       
    </class>

</hibernate-mapping>

Candidate.hbm.xml

<?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="beans">
    
    <class name="Candidate" table="css_candidate">
        <id name="id" column="candidateSeq">
            <generator class="native"/>
        </id>

       <property name="firstName"/>
       <property name="lastName"/>
       <property name="emailId"/>
       <property name="businessPhone"/>
       <property name="homePhone"/>
       <property name="cellPhone"/>
       <property name="street"/>
       <property name="apt"/>
       <property name="city"/>
       <property name="state"/>
       <property name="zip"/>
       <property name="country"/>
       <property name="createDate"/>
       <property name="modifiedDate"/>
       <many-to-one name="candidateUserId" class="beans.User" column="userId" not-null="true" cascade="all" unique="true" />
       <set name="jobs" table="css_candidatejob" inverse="true">
       	  <key column="candidateSeq"/>
          <many-to-many column="jobSeq" class="Job"/>
    	</set>
       
    </class>

</hibernate-mapping>

candidate.java

private User candidateUserId;
public User getCandidateUserId() {
return candidateUserId;
}

public void setCandidateUserId(User candidateUserId) {
this.candidateUserId = candidateUserId;
}

saving candidate bean in DAO.

    public void createAndStoreUser(UserDTO userDTO,CandidateDTO candidateDTO) {

        Session session = HibernateUtil.getSessionFactory().getCurrentSession();

        session.beginTransaction();

      
        User user = new User();

        user.setUserId(userDTO.getUserId());
        user.setPassword(userDTO.getPassword());
        user.setFirstName(userDTO.getFirstName());
        user.setLastName(userDTO.getLastName());
        
        Candidate candidateBean = new Candidate();
        
        candidateBean.setFirstName(candidateDTO.getFirstName());
        candidateBean.setLastName(candidateDTO.getLastName());
        candidateBean.setEmailId(candidateDTO.getEmailId());
        candidateBean.setBusinessPhone(candidateDTO.getBusinessPhone());
        candidateBean.setCellPhone(candidateDTO.getCellPhone());
        candidateBean.setHomePhone(candidateDTO.getHomePhone());
        candidateBean.setApt(candidateDTO.getApt());
        candidateBean.setStreet(candidateDTO.getStreet());
        candidateBean.setCity(candidateDTO.getCity());
        candidateBean.setCountry(candidateDTO.getCountry());
        candidateBean.setCandidateUserId(user);
        System.out.println("User in cbean "+candidateBean.getCandidateUserId().getFirstName()+candidateBean.getCandidateUserId().getId());
        //session.save(user);
        session.save(candidateBean);

        session.getTransaction().commit();
        System.out.println("saving user and commiting");

    }

[vani venkat]

I restarted Jboss server and here is the new exception.
is there anything wrong with mapping?

15:46:21,259 INFO [STDOUT] Hibernate: insert into CSS_User (userId, password, f
irstName, lastName) values (?, ?, ?, ?)
15:46:21,291 INFO [STDOUT] Hibernate: insert into css_candidate (firstName, las
tName, emailId, businessPhone, homePhone, cellPhone, street, apt, city, state, z
ip, country, createDate, modifiedDate, userId) values (?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?)
15:46:21,291 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1452, S
QLState: 23000
15:46:21,291 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot add or upda
te a child row: a foreign key constraint fails (`ssln`.`css_candidate`, CONSTRAI
NT `FK_Candidate_userId` FOREIGN KEY (`userId`) REFERENCES `css_user` (`userId`)
ON UPDATE CASCADE)

why is it not creating record in css_user table? should i save user too?